topic Re: How To add Variables in such Expression? in QlikView

How To add Variables in such Expression?

sspawar88 — Tue, 28 Jul 2015 12:42:23 GMT

Set VgreenMin=-1;

Set VgreenMax=-10;

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

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

and

i'm trying like that

Count({$<param_name={'TEMP'},param_value={'<=$(VgreenMin)>=$(VgreenMax)'}>}param_value)/

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

what need to be change in way of using Variables?

Thanks In advance.

avinashelite — Tue, 28 Jul 2015 12:47:36 GMT

change the single quotes to double and check, when your using the variable inside the value its should be double quotes

Count({$<param_name={'TEMP'},param_value={"<=$(VgreenMin)>=$(VgreenMax)"}>}param_value)/

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

sunny_talwar — Tue, 28 Jul 2015 12:56:27 GMT

You can also try this:

Count({$<param_name={'TEMP'},param_value={"$(='<=' & $(VgreenMin) & '>=' & $(VgreenMax))"}>}param_value)/

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

Tue, 28 Jul 2015 13:01:43 GMT

param_value={">=$(=VgreenMin)<=$(=VgreenMax)"} >}

use above expreesion hope it will work

Thanks

Manju

sspawar88 — Tue, 28 Jul 2015 13:01:51 GMT

Thanks Sunny

sspawar88 — Tue, 28 Jul 2015 13:02:20 GMT

Thank u so much Manjunath

maxgro — Tue, 28 Jul 2015 13:14:00 GMT

I think (as Avinash suggested) your expression is correct, you can change quote with double quote in search string (but also quote should work)

a small test

sum({$ <exp={"<=$(VgreenMin)>=$(VgreenMax)"}>} exp)