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?

[#2]

can please provide sample data so that i can able to understand the scenario

[sspawar88]

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.

[Kushal_Chawda]

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

[sspawar88]

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.

[jfkinspari]

Agree, you'll need to include all of the objects' dimensions in the AGGR function, to make it work.

[Kushal_Chawda]

Hi,

Post this question in Qlik sense community

[sspawar88]

How ?

[jfkinspari]

Try this

sum(Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type,branch_name,loc_code))

[sspawar88]

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.

Set analysis