Discussion Board for collaboration related to Creating Analytics for QlikView.
In my straight table 30 records are there like 1,2 3......30
If i select any record from 1 to 10 it should show bar chart
If i select any record from 11 to 20 it should show pie chart
If i select any record from 21 to 30 it should show line chart
Can Anyone tell me how can i acheive this.
Do you have a sample where we can play around with it? Solution may require some trial and error, it would be best if you can provide with a sample.
Above one is the sample data from that based on the customerid i want show and hide charts
That sad but as far as I know you can't change chart type by any expression.
So you need to create3 charts: bar, pie, line which will have same dimentions and expressions
and then on the layout tab write an expression (right there or have a variable with this) like
=if(getselectedcount(CustomerID) = 1 and CustomerID <= 10, 1, 0) -- any choosed from 1 to 10 included will show on first (let say bar) chart.
If you'd like, I can provide a sample app little bit later.