topic Re: IF ELSE STATEMENT in QlikView

IF ELSE STATEMENT

Shinigaloo — Thu, 24 Dec 2020 10:18:29 GMT

Hello everyone ,

Please i have a trouble with this statement :

=Num(Count(if(aggr(money(Sum({($<Date= {">=$(=$(vDateDebFormat))"}>) * ($<Date= {"<=$(=$(vDateFinFormat))"}>)*($<[Type Service demandé]= {'Messagerie vocale'}>)* <[USER_MEVO]= {'1'}>} NbAppel),'# ##0 ;-# ##0 ')<>0,ID_UTI),0))
/Count(DISTINCT {$<activation_uti= {">=$(=$(vDateDebFormat))"}> * <activation_uti= {"<=$(=$(vDateFinFormat))"}> * <[USER_MEVO]= {'1'}>} ID_UTI),'#,%')&chr(10)&'Avec usage'

I want to show 0% , if the condition into statement is not valid , how can i do this ?

Please help me

Re: IF ELSE STATEMENT

edwin — Thu, 24 Dec 2020 19:20:49 GMT

i would first validate the individual expressions like

Sum({($<Date= {">=$(=$(vDateDebFormat))"}>) * ($<Date= {"<=$(=$(vDateFinFormat))"}>)*($<[Type Service demandé]= {'Messagerie vocale'}>)* <[USER_MEVO]= {'1'}>} NbAppel)

i suspect the operation between the sets may be erroneous especially using brackets to separate the sets >)*(<

Re: IF ELSE STATEMENT

edwin — Thu, 24 Dec 2020 19:23:57 GMT

also these sets can be translated into just 1:

Sum({($<Date= {">=$(=$(vDateDebFormat))<=$(=$(vDateFinFormat))"}, [Type Service demandé]= {'Messagerie vocale'}, [USER_MEVO]= {'1'}>} NbAppel)

separating them by comma is the same as an AND especially since they have different fields anyway

Re: IF ELSE STATEMENT

Shinigaloo — Fri, 25 Dec 2020 13:21:32 GMT

thank you edwin for you responses 🙂

Re: IF ELSE STATEMENT

edwin — Mon, 28 Dec 2020 15:37:09 GMT

Re: IF ELSE STATEMENT

priya0323 — Wed, 06 Jan 2021 22:03:46 GMT

Can you please help me in understanding the use of * to separate the sets?

I am new to Qlikview!

Re: IF ELSE STATEMENT

edwin — Thu, 07 Jan 2021 12:41:09 GMT

modifiers (anything inside the <> ) specify the criteria for the data set you wish to apply an operation against (sum, count, etc..)

* is an operation done on 2 data sets which is an AND operation. this is a very good reference for set analysis:

LivingQlik Roots: The Ultimate QlikView Set Analysis Reference - Living Qlik (livingqlikview.com)

Re: IF ELSE STATEMENT

priya0323 — Thu, 07 Jan 2021 13:42:10 GMT

Thank you so much Edwin !

Re: IF ELSE STATEMENT

edwin — Thu, 07 Jan 2021 14:15:54 GMT