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

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

fredericvillemi — Wed, 02 Jul 2014 12:08:42 GMT

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

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

vgutkovsky — Wed, 02 Jul 2014 18:13:31 GMT

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

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

fredericvillemi — Thu, 03 Jul 2014 12:50:01 GMT

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