Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
psk180590
Creator III
Creator 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
Specialist
Specialist

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

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
Creator III
Creator III
Author

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
Specialist II
Specialist II

Hi

For this you have to create Drill down Group.

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

Hope it helps!!

kamal_sanguri
Specialist
Specialist

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
Specialist II
Specialist II

Please attach sample data

qlikviewnovice
Specialist II
Specialist II

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

psk180590
Creator III
Creator III
Author

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
Creator III
Creator III
Author

Hi Anil,

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

kamal_sanguri
Specialist
Specialist

pls check this-