topic Re: Set analysis for Drill down in QlikView

Set analysis for Drill down

sspawar88 — Fri, 10 Jul 2015 14:26:28 GMT

i have drill down group for branch_type, branch_name, loc_type as a dimension

Dimension= branch_type--branch_name--loc_type (Drilled group)

Expression:

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count(total <branch_type>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)

i want to show 100% for all drilled dimension.

it shows branch_type as 100% which is correct..but when i drilled it shows less value than 100%

i want to check the following param_value ranges thats why i required 100% for each dimention.

-1 to -10

-10.1 to -13.9

-14 to -17.9

-18 & Below.

Re: Set analysis for Drill down

Anonymous — Fri, 10 Jul 2015 14:32:25 GMT

may be you have some null branch names or null loctype. if not change your expression to following

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count(total <branch_type,branch_name,loc_type >{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)

Re: Set analysis for Drill down

sunny_talwar — Fri, 10 Jul 2015 14:34:28 GMT

I think the problem is related to your denominator's expression which is using TOTAL <branch_type>, I feel that once you drill down into your second dimension, that should change as well, but since it is static it doesn't. May be create a variable like this:

vVar = '[' & GetCurrentField(branch_type--branch_name--loc_type) & ']'

And then see if this works:

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count(total <$(vVar)>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)

Note: Never tried it before, so don't know if it will work, but worth experimenting.

HTH

Best,

Sunny

Re: Set analysis for Drill down

sspawar88 — Fri, 10 Jul 2015 14:34:46 GMT

Thanks Vinay

Re: Set analysis for Drill down

Anonymous — Fri, 10 Jul 2015 14:37:13 GMT

glad was able to help you..