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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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