topic Re: Row level Count in QlikView

Row level Count

sspawar88 — Tue, 04 Aug 2015 06:30:40 GMT

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 for branch_type which i have required.

but when i drill down for branch_name, loc_code, loc_type it won't show 100%. i require all bars with perfect 100%

what Changes need to be put in expression?

gwassenaar‌

swuehl‌

Re: Row level Count

swuehl — Tue, 04 Aug 2015 06:35:07 GMT

Instead of the aggr() function, try the TOTAL qualifier in the second count(), with all drill down dimension fields stated in the qualifier field list.

Re: Row level Count

sspawar88 — Tue, 04 Aug 2015 06:42:42 GMT

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

/count({<param_name={'TEMP'},param_value={'<=-1'}>}total<branch_type,branch_name,loc_code,loc_type> param_value)

when i used Total in denominator it gives 400% and all stacks are in same proportion which is incorrect.

Re: Row level Count

Kushal_Chawda — Tue, 04 Aug 2015 06:45:16 GMT

Please use the below expression. It's working for me

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

Re: Row level Count

swuehl — Tue, 04 Aug 2015 07:56:40 GMT

Would be better next time you post a request if you fully describe your scenario, best by posting a small sample QVW.

Everything else is kind of guessing and inefficient.