Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

 

Tags (1)
1 Solution

Accepted Solutions
jagannalla
Valued Contributor III

Re: Set Analysis with Variable

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

2 Replies
jagannalla
Valued Contributor III

Re: Set Analysis with Variable

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

Re: Set Analysis with Variable

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

Eduardo

Community Browser