Re: Set analysis - Page 3 - Qlik Community

sspawar88 · ‎2015-07-31

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?

Kushal_Chawda · ‎2015-08-04

Try this expression

Num(Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)

/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),$(=GetCurrentField([BT-BN-LT-LC]))),'#,##0.00%')

sspawar88 · ‎2015-08-04

i think i have to ask in Qlik sense community to How to add the BT-BN-LN-LC in expression.

beacuse there is no way to add drill down group in epression in Qlik sense.

looks strange.

Kushal_Chawda · ‎2015-08-04

I think in qlik sense also there should be provision to add drill group in aggr as almost all fucntions are same as QlikView

sspawar88 · ‎2015-08-04

lets see

sspawar88 · ‎2015-08-04

By the way..thanks a lot kush..its very helpful for me.

Anonymous · ‎2015-08-04

Play like below:

Count({<param_name={'TEMP'}, param_value={'<=-1'}>} TOTAL <branch_type,branch_loc> param_value)/

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

sspawar88 · ‎2015-08-04

FYI

Qlik sense not supported to following functions

Set analysis