topic Re: Multiple Line Charts - Hiding Multiple Lines in QlikView

Multiple Line Charts - Hiding Multiple Lines

jmonroe918 — Mon, 10 Apr 2017 19:37:46 GMT

My line chart is showing a trend line (Month/Year) of data points for several sites. I only want to see them one at a time, not all at once. Or I at least would like to filter out that view and default the "Global" Site (one of the selections).

How do I do that?

My QVW is attached

Thanks

Re: Multiple Line Charts - Hiding Multiple Lines

sunny_talwar — Mon, 10 Apr 2017 19:41:40 GMT

May be using a calculated dimension

=If(GetSelectedCount(CPM.Site) = 0, If(CPM.Site = 'Global', CPM.Site), CPM.Site)

You can also modify your expression, but you will need two variables to do this or you can directly use your expression to do this...

PFA the dimension based solution

Re: Multiple Line Charts - Hiding Multiple Lines

sunny_talwar — Mon, 10 Apr 2017 19:45:16 GMT

Expression based attached

Re: Multiple Line Charts - Hiding Multiple Lines

jmonroe918 — Mon, 10 Apr 2017 21:47:24 GMT

Sunny:

Thank you so much for again coming to my rescue. I'm hoping you can answer this question. I applied your Dimension method to the chart I sent to you and it worked perfectly. I then pasted the formula into another chart on my dashboard and I'm getting and additional line (in red) and a dash "-" in the list of sites when the default appears. When I select a site, it goes away and works perfectly until I clear the selection.

Can you tell me why and how to get rid of this? (I ended copying and pasting the table you updated into my dashboard and it doesn't do that. Thanks a lot.

Re: Multiple Line Charts - Hiding Multiple Lines

sunny_talwar — Tue, 11 Apr 2017 01:19:37 GMT

You just need to select 'Suppress When Value is Null' on the dimension tab for new calculated CPM.Site dimension.

Re: Multiple Line Charts - Hiding Multiple Lines

jmonroe918 — Tue, 11 Apr 2017 05:41:56 GMT

Shoot! I should have known that. Everything works great.

Thanks again, my friend.

Jeff

Re: Multiple Line Charts - Hiding Multiple Lines

jmonroe918 — Tue, 11 Apr 2017 23:44:34 GMT

Hey Sunny:

I'm trying to add another Expression; a Goal line. It works for the selections but not when nothing is selected. See below.

I've attached my qvw if you don't mind taking a look.

I really appreciate your help.

Jeff

Re: Multiple Line Charts - Hiding Multiple Lines

sunny_talwar — Tue, 11 Apr 2017 23:51:57 GMT

Not sure why the calculated dimension alone isn't working in the line chart, I see that it works in the straight table.... but a change in expression works

=If(GetSelectedCount(CPM.Site) = 0, Sum({<CPM.Site = {'Global'}>}Goal), Sum(Goal))

Re: Multiple Line Charts - Hiding Multiple Lines

jmonroe918 — Wed, 12 Apr 2017 04:19:00 GMT

Perfect! Thanks again Sunny,

Jeff