topic Re: Hide Lines in a graph chart in QlikView

Hide Lines in a graph chart

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

Hello All,

I have a requirement where i would like display the graph indicating sales of the whole country by default, and upon selection of a particular state the graph of that state should be displayed along with country graph. And at last the city graph should also be on the same lines as state graph.

Could you please provide me any pointers on doing this.

Thanks much. Wish you all a nice weekend!!

Re: Hide Lines in a graph chart

kamal_sanguri — Fri, 09 Jun 2017 10:09:15 GMT

Hi,

Please be more specific, your title does not talk to your problem statement. Please provide some more/clear details. It will help others to understand the problem and provide you the solution.

Thanks,

-kamal

Re: Hide Lines in a graph chart

psk180590 — Fri, 09 Jun 2017 10:14:15 GMT

Hello Kamal,

Let me try to explain a bit more. I'm trying to have graph chart which has sales of Country/State/City.

1. The line(graph) indicating the country sales should be displayed all the time.

2. The line indicating sales per state should be displayed only when one states is selected from the list box(i will be having one in the same page).

3. Same with per city sales, this should be displayed only when a city is selected.

So, basically i would like to hide two lines(State and City) and display based on condition.

Please do let me know if this is still unclear.

Thanks!!

Re: Hide Lines in a graph chart

Anonymous — Fri, 09 Jun 2017 10:20:24 GMT

For this you have to create Drill down Group.

https://intellipaat.com/tutorial/qlikview-tutorial/advanced-features/

Hope it helps!!

Re: Hide Lines in a graph chart

kamal_sanguri — Fri, 09 Jun 2017 10:22:24 GMT

I think like this, when nothing is selected chart will show the sales for all states and when any state is selected chart will show the sales of the city of the selected states.

Re: Hide Lines in a graph chart

Anonymous — Fri, 09 Jun 2017 10:25:37 GMT

Please attach sample data

Re: Hide Lines in a graph chart

Anonymous — Fri, 09 Jun 2017 10:30:34 GMT

or Else you can create 3 buttons and give actions to that Charts Show/Hide

Re: Hide Lines in a graph chart

psk180590 — Tue, 13 Jun 2017 10:18:27 GMT

Hello Kamal,

Thanks much for the example.

In your application if i select a particular State/City the overall sales graph disappears and only the selected option is displayed.

Instead i would like to have the overall graph by default and when there is a State/City selection, the chart should be Overall vs State/City.

To explain better, i would like to have the above graph always and when a state/city is selected the first attached graph(with selection) should be projected against the whole graph(no selection).

TIA!!

Re: Hide Lines in a graph chart

psk180590 — Tue, 13 Jun 2017 10:19:10 GMT

Hi Anil,

You can consider the data from the app that Kamal attached.

Re: Hide Lines in a graph chart

kamal_sanguri — Tue, 13 Jun 2017 10:42:21 GMT

pls check this-

Re: Hide Lines in a graph chart

kamal_sanguri — Tue, 13 Jun 2017 11:00:03 GMT

No selection-

with state selection -

with city selection-

I have change it a way that when you select a state the dimensions changes to City.. if we keep it state the selected sate would be visible as a point in overall line ( which might not be so informative)

something like this;