Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)/
Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type)
This expression gives me 100% Stack bar chart which i have required.
but when i drill down for branch_name it won't show 100% for branch_name.
what Changes need to be put in expression?
can please provide sample data so that i can able to understand the scenario
Hi manjunath,
right now i could not able to give a sample data.
but i can give u idea.
i have drill down group of dimensions like branch_type,branch_name,loc_code.
when i used above expression it gives 100% for branch_type but when i drilled it, further dimensions are not 100%
which is somewhere mistake in my expression or i don't have a idea to add all dimension name on the place of branch_type.
try below expression
=Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)/
Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),$(=GetCurrentField(YourDrillGroupName)))
Hi Kush,
I'm working in Qlik sense..here there is no option to add drilled down group in Expression.
i have to manually add field names.
but it won't work.
Agree, you'll need to include all of the objects' dimensions in the AGGR function, to make it work.
Hi,
Post this question in Qlik sense community
How ?
Try this
sum(Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type,branch_name,loc_code))
Hi Jens,
it won't work..even it shows % Which is less than 100% in first level of drill down which is incorrect.
it should shows 100% for all levels.