Monthly Archives: décembre 2018

Hi James, Try to use this where statement: WHERE not wildmatch(FieldName, 'value', 'value2', 'value3') value, value2, value3 should be data you want to exclude. You can either use wildmatch or mixmatch function. wildmatch...

Management summary: Ctrl + Shift + S overrules all conditional show expressions making every hidden sheet and sheet object visible. Full story: Condtional show expressions are used in...

Extracting embedded images from QlikView By Barry Harmsen ImageExtractor for QlikView ImageExtractor is a small utility that extracts images from your QlikView applications and stores them as...

Please follow below. 1. In the load script, Add below codes LEt vColorLight=rgb(176,242,242); LEt vColorMiddle=rgb(153,204,255); LEt vColorMixDark=rgb(40,115,204); 2. Create a var chart object. 3. Go to  Appearance  > Colors >...

The -= in the set expression may show a red underline indicating an error but the expression will work.      sum({<Type -={'Var'}>} Amount) An alternative is sum({<Type...

  On crée la dimension : =ValueList('CARD_DATA_GP','CARD_VOIX_GP','CONTRAT_DATA_GP','CONTRAT_DATA_ENT','CONTRAT_VOIX_GP','CARD_VOIX_ENT','FIDELISATION') On crée l'expression : /*IF(ValueList('DMC_NIV1','Nom_acte')='DMC_NIV1', Pick(Match(DMC_NIV1,'CARD_DATA_GP','CARD_VOIX_GP'), count({<DMC_NIV1={'CARD_DATA_GP'}>} Q02_ACT_NAME), count({<DMC_NIV1={'CARD_VOIX_GP'}>} Q02_ACT_NAME) ),*/ /*IF(ValueList('DMC_NIV1','Nom_acte')='Nom_acte', Pick(Match(Nom_acte,'Fidélisation'), count({<Nom_acte={'Fidélisation'}>} Q02_ACT_NAME)))*/ //num(Count({<Nom_acte = {'Nouvelle Acquisition'}>} Q02_ACT_NAME),'# ##0;(# ##0)') IF(ValueList('CARD_DATA_GP','CARD_VOIX_GP','CONTRAT_DATA_GP','CONTRAT_DATA_ENT','CONTRAT_VOIX_GP','CARD_VOIX_ENT','FIDELISATION')='FIDELISATION', count({<Nom_acte={'PCM'}>} Q02_ACT_NAME), IF(ValueList('CARD_DATA_GP','CARD_VOIX_GP','CONTRAT_DATA_GP','CONTRAT_DATA_ENT','CONTRAT_VOIX_GP','CARD_VOIX_ENT','FIDELISATION')='CARD_DATA_GP', count({<Nom_acte={'Nouvelle Acquisition'},DMC_NIV1={'CARD _ DATA _ GP'}>} Q02_ACT_NAME), IF(ValueList('CARD_DATA_GP','CARD_VOIX_GP','CONTRAT_DATA_GP','CONTRAT_DATA_ENT','CONTRAT_VOIX_GP','CARD_VOIX_ENT','FIDELISATION')='CARD_VOIX_GP', count({<Nom_acte={'Nouvelle Acquisition'},DMC_NIV1={'CARD _...

Les fonctions de fichier (disponibles uniquement dans les expressions de script) renvoient des informations sur le fichier de table en cours de lecture. Elles...

AuthorClientPlatformComputerNameDocumentNameDocumentPathDocumentTitleGetCollationLocaleGetActiveSheetIDGetExtendedPropertyGetObjectFieldGetRegistryStringInputIsPartialReloadMsgBoxOSUserQlikViewVersionQVuserReloadTimeStateName

Ignore selection in Dimension: count({$<CaYear=>}IncidentID) Ignore All Dimensions in chart: count(TOTAL IncidentID) Ignore Specific Dimension (eg: Dim3) in chart: count(TOTAL <Dim1, Dim2, Dim4> IncidentID) Count(Q02_ACT_NAME)/Count(TOTAL {$<ACT_NAME=,=>} Q02_ACT_NAME)