Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
I want to know why is qlik showing all the dates when i put something in else condtion
May be all you need to do is to uncheck 'Include zero values' under Add-ons -> Data handling
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