Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
gaddeonline
Contributor III
Contributor III

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
Specialist II
Specialist II

Hi,

maybe

you could check option display allways,

with expression : month selected ?

regards

gaddeonline
Contributor III
Contributor III
Author

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
Specialist II
Specialist II

for june, what reference line do you want ?

reference line in June or in Feb ?

gaddeonline
Contributor III
Contributor III
Author

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