Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
how can I get straight table by clicking on pie chart or bar chart so that it has to show only Associated date in Table
For Example, if i select the green part of the pie chart(Germany), then the below table should show in straight table, without affecting the color of the pie chart.... and similar for other colors as well(If i Click on USA, then USA datas should appear in the table)
Country | Product | Sales |
---|---|---|
Germany | Mobile | 15248924 |
Germany | Keonics | 11451453 |
Germany | Headset | 5425514 |
Germany | Laptops | 41256 |
Germany | Key Board | 2356145 |
How to achieve it?
Regards,
Shivananda S
Message was edited by: shivananda s
Hi Shivananda,
Please follow below steps to get straight table by clicking on Pie chart segment.
Step 1: Create set analysis in Pie chart like below
Sum({<Country = >} Sales)
Step 2: Create straight table with required columns
Step 3: Create a variable says vShowTable and define like below
=If(getselectedcount(Country) = 1, 1,0)
Step 4: Go to Straight table properties -> Layout -> Conditional show and write below condition using above variable
=vShowTable = 1
Good Luck Shivanada
Best Regards
Shambhu B
Hi Shivanada
Qlikview should do this automatically , are your tables with the different data sets linked?
Maybe if you could post a picture of your table structure?
Hi Shiva,
Based on my understand, when we make a selection in the pie chart the straight table should show the values based on the selection, right?
I think already you know that Qlikview is default association. Just check that relationship between two fields. and also check that any duplicates between the fields just validate the data.
Please provide the sample on this .
Thanks
Kumar KVP
When I click on the green part of the pie, usually whole pie will become green, which I dont want. Rather, I want the data of Germany(Indicated by green) in the straight table. Sorry for the table i added, it was for an example.
The color of pie after clicking on the green part shouldn't be affected.
Similarly we have to do it for all colors .
How do i achieve it now?
Hi shivananda,
As per my understand, when we make a selection in pie chart(i.e a color by country(green,white)).
You able to get that by having the drill down group option.
Create a group which contains dimensions(country,offense) as drill group and use this group dimension as pie dimension.
i.e when we make a selection on any of the quarter(green) of pie the it goes into the appropriate fields(green) of offense .
Thanks
Kumar KVP
Hi Shivananda,
Please find the below sample qvw file.
Thanks
Kumar KVP
Hi
as others have indicated selection made on one object by default caries on on other objects.
In second scenario you will be able to have a non-responsive pie chart/legend with possibility to apply selections ion it
see attached file
Hi Shivandra
I think I understand what you want.
When you click on the Germany in the pie chart, you want the pie to remain as it is?
but you want the straight table to adjust with only Germanys data so that you can see Germanys data relative to the other countries
If this is what you are trying to achieve,
There are a few ways to do this, You can use set analysis in the Pie chart Sum({<Country=>}Sales) This will ignore any country selections you make but the straight table should change
Hi Shivendra,
Here if you want your table according to the country then don't take drill down dimension. Simply take country as dimension and use following expression:
Dimension:- Country
Expression:-sum({1<Country=>} Sales)
Please find attached QVW for your reference.
Thanks,
Hi Shivananda,
Please follow below steps to get straight table by clicking on Pie chart segment.
Step 1: Create set analysis in Pie chart like below
Sum({<Country = >} Sales)
Step 2: Create straight table with required columns
Step 3: Create a variable says vShowTable and define like below
=If(getselectedcount(Country) = 1, 1,0)
Step 4: Go to Straight table properties -> Layout -> Conditional show and write below condition using above variable
=vShowTable = 1
Good Luck Shivanada
Best Regards
Shambhu B