Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

fredericvillemi
Contributor III

Use a variable or a field in a reference line in a treillis ?

Hi,

i have a bar chart with a treillis and i would like to set a reference line different for each of the part of the treillis.

Imagine a first dimension Customer, a second dimension Month and a Sales kpi

I would like to add a reference line with a condition on the Customer : if (Customer = 'xxx', 0,0.5)

It doesn't work .. is it normal and is there a workaround or should i make a ticket to ask for variables or fields in Reference Lines ?

Thanks

Tags (1)
1 Solution

Accepted Solutions
vgutkovsky
Honored Contributor II

Re: Use a variable or a field in a reference line in a treillis ?

Well, in general, you can't check the current dimension in a reference line. So I don't think a ticket to Qlik is going to help you--this is WAD. I suggest you change your chart to a combo chart, and create the line as a regular expression (not a reference line). You can use the same expression you mentioned above.

Regards,

Vlad

2 Replies
vgutkovsky
Honored Contributor II

Re: Use a variable or a field in a reference line in a treillis ?

Well, in general, you can't check the current dimension in a reference line. So I don't think a ticket to Qlik is going to help you--this is WAD. I suggest you change your chart to a combo chart, and create the line as a regular expression (not a reference line). You can use the same expression you mentioned above.

Regards,

Vlad

fredericvillemi
Contributor III

Re: Use a variable or a field in a reference line in a treillis ?

Ok i have tried with a variable and it works .. it's not as bad as i thought

I'll try to add an expression to do what i wanted to do

thanks

Community Browser