Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with Variable

Hey!

I have this expression:

Avg ({<L_Z1V2={'>0,120'}>*<L_Z1V2={'<0,249'}>}L_Z1V2)

I just want to change 0,120 for a variable called UG_KH and 0,249 for OG_KH. It should be easy but I don't find the right syntaxe.

Thank you very much!!!!

Eduardo

 

1 Solution

Accepted Solutions
jagannalla
Partner - Specialist III
Partner - Specialist III

Hello,

try this :

=(Avg({$<L_Z1V2={">$(vUG_KH)<$(vOG_KH)"}>} L_Z1V2))

Create two variables vUG_KH and vOG_KH with values 0,120  and 0,249

Cheers!!

Jagan

View solution in original post

2 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Hello,

try this :

=(Avg({$<L_Z1V2={">$(vUG_KH)<$(vOG_KH)"}>} L_Z1V2))

Create two variables vUG_KH and vOG_KH with values 0,120  and 0,249

Cheers!!

Jagan

Not applicable
Author

Thank you very much! This "v" solves the problem with "." und ","!!!

Eduardo