topic IF statement with two measures one with set analysis other without it in App Development

IF statement with two measures one with set analysis other without it

Pragun — Tue, 26 Feb 2019 13:41:53 GMT

When I write this code in measure without Else Condition:

if(vDate=4,
pick(vEarning,
Sum({<ProdWorkDate={">=$(=WeekStart(Max(ProdWorkDate)))<=$(=Max(ProdWorkDate))"}>} Wages)))

Code With Else Condition of Sum(Wages)

if(vDate=4,
pick(vEarning,
Sum({<ProdWorkDate={">=$(=WeekStart(Max(ProdWorkDate)))<=$(=Max(ProdWorkDate))"}>} Wages)),Sum(Wages))

Without Else ConditionWith Else Condition

I want to know why is qlik showing all the dates when i put something in else condtion

Re: IF statement with two measures one with set analysis other without it

sunny_talwar — Tue, 26 Feb 2019 14:14:33 GMT

May be all you need to do is to uncheck 'Include zero values' under Add-ons -> Data handling

Re: IF statement with two measures one with set analysis other without it

Pragun — Tue, 26 Feb 2019 14:20:59 GMT

Hi, I can do that but the problem is I have date for which I have no data but I still want to show that on UI. Also I am interested in knowing the reason behind this behavior

Re: IF statement with two measures one with set analysis other without it

sunny_talwar — Tue, 26 Feb 2019 14:26:05 GMT

I am not sure, but if you are able to share a sample, we can take a look at it to see what might be going on

Re: IF statement with two measures one with set analysis other without it

Pragun — Tue, 26 Feb 2019 14:29:40 GMT

Sorry but I would not be able to share the sample but I discussed this with my colleague he said he also faced the same issue when using 2 measure one with set analysis and other without it