topic Multiple Reference Lines with single expression in QlikView

Multiple Reference Lines with single expression

gaddeonline — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I am raising this discussion after an enormous search of the same kind, with our success.

I am trying to get the multiple reference lines from the single expression. It is working as long as I am selecting the months where the data is available. If I select the month where the data is not available, it is not displaying anything.

My requirement is, I want all the reference lines irrespective of the month selected.

Could you please help me out in acheiving this? I have attached few screenshots for your understanding.

1 - June month selected where there is no data available for that month.

2&3 - Jan and Feb selected where the data is availble to display and the reference lines are visible now

Expression screenshot is the reference line expression

Thanks in advance.

Kind Regards

Mahesh Gadde

Re: Multiple Reference Lines with single expression

ogautier62 — Thu, 12 Jul 2018 06:37:17 GMT

Hi,

maybe

you could check option display allways,

with expression : month selected ?

regards

Re: Multiple Reference Lines with single expression

gaddeonline — Thu, 12 Jul 2018 23:29:29 GMT

Hi Olivier,

Thank you very much for your quick response.

I have already tried to show the refernce line as 'Always'. but it didn't work out.

As you can see the screenshots, When the month 'Jun' is selected, the reference lines for months of Jan and Feb are disappearing. I want to exclude the month selection in the expression. if I try to exclude the month int he expression like, =Only({<Cal_YearMonth=>}link_Calendar), no reference lines are showing now even the Jan and Feb are seleced.

Thanks and Regards

Mahesh Gadde

Re: Multiple Reference Lines with single expression

ogautier62 — Fri, 13 Jul 2018 06:31:48 GMT

for june, what reference line do you want ?

reference line in June or in Feb ?

Re: Multiple Reference Lines with single expression

gaddeonline — Sun, 15 Jul 2018 23:21:23 GMT

Hi Olivier,

I want all the reference lines irrespective of the month selected. Even I selected month 'June', I want to see my reference lines for Dec, Jan and Feb.

Regards

Mahesh Gadde