Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

gaddeonline
New Contributor II

Multiple Reference Lines with single expression

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

4 Replies
ogautier62
Valued Contributor II

Re: Multiple Reference Lines with single expression

Hi,

maybe

you could check option display allways,

with expression : month selected ?

regards

gaddeonline
New Contributor II

Re: Multiple  Reference Lines with single expression

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

ogautier62
Valued Contributor II

Re: Multiple Reference Lines with single expression

for june, what reference line do you want ?

reference line in June or in Feb ?

gaddeonline
New Contributor II

Re: Multiple  Reference Lines with single expression

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

Community Browser