Hide Lines in a graph chart

[psk180590]

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!!

[kamal_sanguri]

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

[psk180590]

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!!

[Anonymous]

Hi

For this you have to create Drill down Group.

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

Hope it helps!!

[kamal_sanguri]

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.

[Anonymous]

Please attach sample data

[Anonymous]

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

[psk180590]

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!!

[psk180590]

Hi Anil,

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

[kamal_sanguri]

pls check this-