Show all values, solution for drill-down dimensions

pbeemster — Thu, 12 Jul 2018 10:01:22 GMT

Hi all,

Looking at Henric's solution in thread QlikSense Dimension: show all values like QlikView? , I've got a followup question.

Using 'Count(Distinct Field) + 0 * Sum( {1} Field )' works properly for the first dimension, to show all values even when the count is 0.

Is there a way that this would also be possible when using a drill down dimension (in Qlik Sense)?

For the second it should do the same, but only for those values that fall under a specific value of the first dimension, hierarchically (for instance: only show mm and nn when B is selected (also when count for nn =0), don't show all values in Fieldname2 ).

Now, it shows all possible values from the second dimension (ll,mm,nn,oo,pp), also ones that don't fall under a specific value of the first dimension.

Fieldname1	Fieldname2
A	ll
B	mm
B	nn
C	oo
C	pp

Hoping anyone might know a solution.

Thanks in advance!

Pam

topic Show all values, solution for drill-down dimensions in App Development

Show all values, solution for drill-down dimensions