topic Re: Set analysis in QlikView

Set analysis

sspawar88 — Fri, 31 Jul 2015 09:46:21 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 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?

Re: Set analysis

Fri, 31 Jul 2015 09:49:35 GMT

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

Re: Set analysis

sspawar88 — Fri, 31 Jul 2015 10:10:11 GMT

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.

Re: Set analysis

Kushal_Chawda — Fri, 31 Jul 2015 10:33:35 GMT

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

Re: Set analysis

sspawar88 — Fri, 31 Jul 2015 10:43:25 GMT

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.

Re: Set analysis

jfkinspari — Fri, 31 Jul 2015 10:45:07 GMT

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

Re: Set analysis

Kushal_Chawda — Fri, 31 Jul 2015 10:54:47 GMT

Hi,

Post this question in Qlik sense community

Re: Set analysis

sspawar88 — Fri, 31 Jul 2015 11:24:00 GMT

How ?

Re: Set analysis

jfkinspari — Fri, 31 Jul 2015 11:32:27 GMT

Try this

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

Re: Set analysis

sspawar88 — Fri, 31 Jul 2015 11:35:42 GMT

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

Re: Set analysis

Kushal_Chawda — Sat, 01 Aug 2015 17:25:41 GMT

any luck?

Re: Set analysis

sspawar88 — Mon, 03 Aug 2015 05:32:48 GMT

no dear

Re: Set analysis

Kushal_Chawda — Mon, 03 Aug 2015 06:00:24 GMT

Have you tried the expression which I had suggested? or else share the app

Re: Set analysis

Anonymous — Mon, 03 Aug 2015 07:07:25 GMT

Try This:

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

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

BR,

Chinna

Re: Set analysis

sspawar88 — Mon, 03 Aug 2015 07:50:40 GMT

yes tried but not working

Re: Set analysis

sspawar88 — Mon, 03 Aug 2015 07:51:03 GMT

Error in Expression

Re: Set analysis

Anonymous — Mon, 03 Aug 2015 09:40:53 GMT

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

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

Re: Set analysis

sspawar88 — Mon, 03 Aug 2015 09:53:58 GMT

it gives 100%.

but at second level it gives same stacks for all the bar's.

Re: Set analysis

sspawar88 — Tue, 04 Aug 2015 05:58:47 GMT

Hi Kush,

Have u any idea?

Re: Set analysis

Kushal_Chawda — Tue, 04 Aug 2015 06:34:03 GMT

let me check your app.