Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
psk180590
Contributor III

Hide Lines in a graph chart

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

1 Solution

Accepted Solutions
kamal_sanguri
Valued Contributor

Re: Hide Lines in a graph chart

No selection-

Capture.PNG

with state selection -

Capture.PNG

with city selection-

Capture.PNG

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;

Capture.PNG

View solution in original post

10 Replies
kamal_sanguri
Valued Contributor

Re: Hide Lines in a graph chart

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
Contributor III

Re: Hide Lines in a graph chart

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

qlikviewnovice
Valued Contributor II

Re: Hide Lines in a graph chart

Hi

For this you have to create Drill down Group.

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

Hope it helps!!

kamal_sanguri
Valued Contributor

Re: Hide Lines in a graph chart

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.

qlikviewnovice
Valued Contributor II

Re: Hide Lines in a graph chart

Please attach sample data

qlikviewnovice
Valued Contributor II

Re: Hide Lines in a graph chart

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

psk180590
Contributor III

Re: Hide Lines in a graph chart

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.

State.JPG

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.Original.JPG

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
Contributor III

Re: Hide Lines in a graph chart

Hi Anil,

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

kamal_sanguri
Valued Contributor

Re: Hide Lines in a graph chart

pls check this-