topic Re: Set analysis. in QlikView

Set analysis.

sspawar88 — Wed, 08 Jul 2015 10:41:35 GMT

Hi,

i'm working on expression in which i will

count all temperature which is less than -1 for XY branch_type /

Count of all temperature for XY branch_type

is below set analysis is correct?

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

Count(total{$<param_name={'Temperature'},branch_type={'XY'}>}param_value)

BUT i can have multiple branch_types.

so how can i have only one formulae for all branch_types?

Re: Set analysis.

Anonymous — Wed, 08 Jul 2015 10:46:12 GMT

Just remove

branch_type={'XY'}

from your expressions.

Re: Set analysis.

Anonymous — Wed, 08 Jul 2015 10:48:22 GMT

what do you want to achieve?

why don't you use branch_type as Dimension and you would not Need to provide it in Expression?

or do you only want some branches? do you have a listbox then to seletc the branches?

provide us with more infos

Re: Set analysis.

Wed, 08 Jul 2015 10:49:11 GMT

remove branch_type from expression and add it as a dimension.

Re: Set analysis.

er_mohit — Wed, 08 Jul 2015 10:51:39 GMT

As per mentioned for all branch type try this

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

Count(total{$<param_name={'Temperature'}>}param_value)

Re: Set analysis.

jagan — Wed, 08 Jul 2015 11:00:49 GMT

Hi Satish,

Try like this

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

Count(total <branch_type>{$<param_name={'Temperature'}>}param_value)

Regards,

Jagan.

Re: Set analysis.

sspawar88 — Wed, 08 Jul 2015 11:14:31 GMT

Actually when i put following expression in simple bar chart it gives correct result.

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

Count(total{$<param_name={'Temperature'}>}param_value)*100

But i want stack chart for some temperature ranges suppose

-1 to -10

-10.1 to -13.9

-14 to -17.9

-18 and below

for this i used following calculated dimension

if(param_name='Temperature' and (param_value)<='-1' and (param_value)>= '-10', 'Red',

if(param_name='Temperature' and (param_value)<= '-10.1' and (param_value)>='-13.9', 'Yellow',

if(param_name='Temperature' and (param_value)<= '-14' and (param_value)>='-17.9', 'Amber',

if(param_name='Temperature' and (param_value)<= '-18', 'Green'))

))

but in stack bar chart it showing value 400%.

whats wrong in my expression or input?

Re: Set analysis.

sspawar88 — Wed, 08 Jul 2015 11:27:51 GMT

Actually when i put following expression in simple bar chart it gives correct result.

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

Count(total{$<param_name={'Temperature'}>}param_value)*100

But i want stack chart for some temperature ranges suppose

-1 to -10

-10.1 to -13.9

-14 to -17.9

-18 and below

for this i used following calculated dimension

if(param_name='Temperature' and (param_value)<='-1' and (param_value)>= '-10', 'Red',

if(param_name='Temperature' and (param_value)<= '-10.1' and (param_value)>='-13.9', 'Yellow',

if(param_name='Temperature' and (param_value)<= '-14' and (param_value)>='-17.9', 'Amber',

if(param_name='Temperature' and (param_value)<= '-18', 'Green'))

))

but in stack bar chart it showing value 400%.

whats wrong in my expression or input?

Re: Set analysis.

Anonymous — Wed, 08 Jul 2015 12:46:39 GMT

Since it is a different question, it will be appropriate to open a separate thread for it.