Discussion board where members can get started with QlikView.
i have data like
if I select a date it should show data for that date and for rest, it should show as zero.
ex: selected 1/9/2018
below is expected output
Say you are using expression Sum(sal) for sal calculation. Re-write it like:
And, uncheck 'Supress zero values' in presentation tab.
View solution in original post
Perhaps look at: Set Analysis - Ignore all selections except certain field
perfect thanks Tresesco.
I Tried with Avg(1). But no luck.