When certain filter is selected should change reference line

[Anonymous]

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! 🙂

[JordyWegman · Accepted solution]

Hi Steven,

Try this:

Pick(Match(GetFieldSelections([Position]),1,2,3,4),2.5,1.5,null(),null())

Jordy

Climber 

[Anonymous]

Thank you very much! 🙂

[Anonymous]

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. 🙂 

[JordyWegman]

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