Set analysis

[sspawar88]

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.

[sunny_talwar]

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))

[sspawar88]

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.

[sunny_talwar]

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?

[sspawar88]

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

[sunny_talwar]

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

[sspawar88]

here

i'm trying to get the row wise count at denominator.

if you have some new way.

please suggest.

[rubenmarin]

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().

[sspawar88]

Hi Ruben,

i'm using group of dimensions for drilled down purpose.

at first level of branch_type it shows 100% which is correct but at second level it is not showing 100% that is not correct.

i'm trying to get 100% on each level of chart from my expression

Each branch_type has a branch_names

1)

2)

[rubenmarin]

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.