Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello qlikers 🙂 ,
I have the dimension "Position". The dimension position there are the values 1,2,3,4.
Now if you select position value 1, the reference line should be 2.5. If you select position value 2 the reference line should be 1.5. But if you select more then one value, no reference line should be visbile.
How can I do that? Thank you in advance! 🙂
Hi Steven,
Try this:
Pick(Match(GetFieldSelections([Position]),1,2,3,4),2.5,1.5,null(),null())
Jordy
Climber
Hi Steven,
Try this:
Pick(Match(GetFieldSelections([Position]),1,2,3,4),2.5,1.5,null(),null())
Jordy
Climber
Thank you very much! 🙂
Hello,
I have a further question. How can I say Field Substrate AND Field xy and then show the reference line?
For example Substrate 1 AND Field xy Berlin should be 1.0, Substrate 2 AND Field xy Hamburg should be 3.0.
Thank you in advance. 🙂
Hi Steven,
That is a bit more complex, but you could try an IF for this.
IF(GetFieldSelection([FieldX]) = 1 AND GetFieldSelection([FieldY]) = 2, ResultTRUE, ResultFALSE)
This can of course be expanded as far as you want.
Jordy
Climber