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?
In Qlikview we can add the whole group of drilled down dimensions at branch _type
how can workout for this in Qlik sense?
please suggest.
Hi Satish, this expression worked:
If(Count(total DISTINCT branch_type)>1,
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type),
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_name)
)
You can add more "levels":
If(Count(total DISTINCT branch_type)>1,
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type),
If(Count(total DISTINCT branch_name)>1,
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_name),
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),loc_code),
))
May be try this:
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)/
Sum(Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type, branch_name))
Hi Sunny,
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.
Makes sense. How are you drilling into a different dimension as there is no groups available in Qlik Sense (if I am not wrong)? Are you using variable to switch from one dimension to another?
No i'm not using variable.
there is one option from where we can create group for drill down and also manipulate in Chart.
Qlik Sense - Drill-down Group Dimension (video)
but there is no option to add such group into expression.
its quite strange
I guess I understand the issue, but I am new to Qlik Sense as well. May be somebody from Qlik Tech might be able to help you better.
Best,
Sunny
here
i'm trying to get the row wise count at denominator.
if you have some new way.
please suggest.
Hi, just guessing, maybe:
If(Count(Distinct branch_name)>1,
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)/
Sum(Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type),
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)/
Sum(Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value), branch_name))
)
I'm trying to check where the dimension is branch_name or branch_type, and each has his aggr. If some branch_type only has 1 branch_name there should be no difference between using branch_type or branch_name for aggr().
Hi Satish, maybe this expression:
If(Count(Distinct branch_name)>1,
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Sum(Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type),
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)/
/Sum(count(TOTAL {<param_name={'TEMP'}, param_value={'<=-1'}>}param_value))
)
If doesn't works please upload a sample to make tests.