topic Re: Conditionally showing reference lines in App Development

Conditionally showing reference lines

soumyadash28 — Wed, 29 Aug 2018 15:21:12 GMT

Hi,

I have a requirement to create a bar chart with multiple reference lines and conditionally show and hide those reference lines. Can anyone suggest how to do this in qlik sense ??

Re: Conditionally showing reference lines

qlikview979 — Thu, 30 Aug 2018 08:33:22 GMT

loveisfail‌theresaa‌

Re: Conditionally showing reference lines

Gysbert_Wassenaar — Thu, 30 Aug 2018 09:23:24 GMT

I'm afraid you'll have to create a custom extension with that functionality. I know of no existing extension that offers reference lines that also have the option to conditionally show and hide them.

Re: Conditionally showing reference lines

soumyadash28 — Thu, 30 Aug 2018 09:55:19 GMT

Yes that is something I would finally be doing. But any help using Qlik Sense default options would be of great help.

Thanks

Re: Conditionally showing reference lines

bwisealiahmad — Thu, 30 Aug 2018 10:04:39 GMT

Hi,

Agree with Gysbert on this one. If you want it to appear or disappear based on a condition you would look into an extension, but maybe you could have the reference line be 0 and conditionally give it a dynamic name whether or not it should be 0 or an actual line?

Best,

Ali A

Re: Conditionally showing reference lines

DavidŠtorek — Thu, 30 Aug 2018 11:06:51 GMT

Hi,

maybe it is not necessary to use extension. If you want to show reference line only in some cases than just simply use if condition in reference line expression.

Like in attached pictures I am using expression

=if(GetSelectedCount(Date)=1,vMonthCapacity+vYearCapacity)

This works that when no date is selected then nothing (no reference line) is displayed. If onde date is selected than reference line is displayed.

Hope this helps

Re: Conditionally showing reference lines

Anil_Babu_Samineni — Thu, 30 Aug 2018 12:44:21 GMT

Is that reference Lines need to show in horizontal / Vertical. And more over, We don't have future to add multiple reference lines in to chart in sense that too there is no feature to show and hide in sense and even View. So, I even afraid why the business needed.

Re: Conditionally showing reference lines

Hannes — Tue, 29 Mar 2022 07:45:44 GMT

Hi David
May I ask, what is your variables?
vMonthCapacity = ?
vYearCapacity = ?

Jut want to wrap my head around this