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.
