Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

How To add Variables in such Expression?

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.

1 Solution

Accepted Solutions
avinashelite

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)

View solution in original post

6 Replies
avinashelite

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

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)

Not applicable

Hi

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

use above expreesion hope it will work

Thanks

Manju

sspawar88
Creator II
Creator II
Author

Thanks Sunny

sspawar88
Creator II
Creator II
Author

Thank u so much Manjunath

maxgro
MVP
MVP

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)

1.png