topic Re: Charts display based on different dimension value in qliksnese in App Development

Charts display based on different dimension value in qliksnese

NVerma — Tue, 02 Feb 2021 11:32:23 GMT

Want to repeat chart for different dimension value.

Lets take an example if i have bar chart based on time dimension and one KPI.

I want to show all bar chart and KPI for different state dimension .

I have tried Trellis but in dimension i am using on condition's to limit dimension value like in State i am using condition if ( Country = 'USA',State) but this giving me problem. This condition in dimension resulting in showing same aggregated value for all state in USA which should be aggregation specific to particular state , and it should be different for different state.

If you have solution let me know.

Re: Charts display based on different dimension value in qliksnese

GaryGiles — Tue, 02 Feb 2021 12:14:11 GMT

Have you tried using the Multi-KPI chart object that comes with the Qlik Visualization Bundle? You will need to save your bar chart as a Master Item. Add State as your dimension and add a measure of 'Drag and Drop Here'. Then, drag the Master item to the chart object and drop onto 'Drag and Drop Here'. Search for Qlik Sense Multi-KPI chart. Lots of good videos if you have any problems.

Re: Charts display based on different dimension value in qliksnese

NVerma — Tue, 02 Feb 2021 12:30:09 GMT

Thanks For reply Gary ,

Actually i have more than two visualization like bar char, pie chart and KPI . I need to use same visualization but these visualization should display for different state like for California bar chart , pie chart and KPI again for Alaska and so on.

In summary page these three chart will so aggregated data for country and when user will drill down these three visualization will display multiple time based on number of state.

Take an eg : in Bar Chart is amount based on time , pie chart concern raise , KPI total count of employee so in summary page these three chart will have aggregated data but once drill down these three chart will repeat and display state wise data , like in bar chart will have California based amount with respect to time and pie chart will have California based concern raise so like for KPI and it will repeat for all state.

Re: Charts display based on different dimension value in qliksnese

GaryGiles — Tue, 02 Feb 2021 12:40:41 GMT

Again, I think you need to look at the Multi-KPI object. You can add multiple Master Item charts to the Multi-KPI, just as you described. If you want to create a drill-effect, use a field that includes all States. Create a Master Item drilldown dimension that starts with the higher level field and has State as your second. Use that Master Item drilldown dimension as dimension in the Multi-KPI object.

Re: Charts display based on different dimension value in qliksnese

NVerma — Tue, 02 Feb 2021 15:46:07 GMT

Thanks for solution by i found Chart created using Multi KPI extension flickers continuously. Do we have any solution for it

Re: Charts display based on different dimension value in qliksnese

GaryGiles — Tue, 02 Feb 2021 19:49:13 GMT

What release of Qlik Sense are you running? The September 2020 release resolves some blinking issues in the Multi-KPI.

Re: Charts display based on different dimension value in qliksnese

NVerma — Wed, 03 Feb 2021 07:59:07 GMT

I have June 2020 version