topic Re: select best chart in QlikView

select best chart

Mon, 18 Nov 2013 13:14:37 GMT

I am not able to select best chart to show data wih 3 levels country, state, city. I can't use drill down approach, I need to show all the data in a single chart but even stacked bar graph or mecko chart is not working as dataset is huge. Can anyone help?

Re: select best chart

Gysbert_Wassenaar — Mon, 18 Nov 2013 13:49:56 GMT

Perhaps you can use a calculated dimension. Something like =Country & '-' & State & '-' & City.

If you need more help please post a sample document: Preparing examples for Upload - Reduction and Data Scrambling

Re: select best chart

Mon, 18 Nov 2013 14:09:59 GMT

Thanks for the response.

As Country > State > City all need to be shown and compared at respective level. Is there a way I can show the data and compare them too in a single chart?

Re: select best chart

Anonymous — Mon, 18 Nov 2013 14:37:00 GMT

Maybe pivot table works for you(?)

Re: select best chart

MayilVahanan — Mon, 18 Nov 2013 14:47:28 GMT

Try with straight table or pivot table..

Hope tat helps

Re: select best chart

Wed, 04 Dec 2013 11:31:35 GMT

Thanks all, Pivot table works fine.

Re: select best chart

brijesh1991 — Wed, 04 Dec 2013 11:46:26 GMT

Since Pivot is providing Expand/Collapse functionality; It will be best choice!

Re: select best chart

MK_QSL — Wed, 04 Dec 2013 11:59:46 GMT

This is how I have showing values in my application.

Re: select best chart

brijesh1991 — Wed, 04 Dec 2013 12:13:40 GMT

Is it Stacked Bar Chart or Mekko Chart you used?

When Data value will be long, then may be data values will be overlapped, so personal suggestion, just use fast change functionality(Your chart+Pivot Table) along with your created chart.

So if someone wants only data values, then they can have it. . .

Re: select best chart

Thu, 05 Dec 2013 04:15:56 GMT

True Brijesh, I have used pivot with my chart and it is working fine.

Thanks for your inputs.