topic Need Help on Bar Charts in QlikView

Need Help on Bar Charts

Anonymous — Wed, 30 Dec 2015 08:48:42 GMT

Hi Experts,

I do have data table for aging like Customer code, customer name, outstanding, voucher date, AG01, AG02, AG03, AG04, AG05+. These

AG series are Monthly aging buckets.

Now i need to present numbers in bar chart with out using cross table functionality. Since this all in columns i am facing difficulties to bring them in bar chart.

I would really thankful if some one could help on this.

Thanks,

Raju K

Data Table:

Customer Code	Customer	Outstanding	AG01	AG03	AG04+
0001	Al Raya Center	1000	1000
444	Fine Hyper market				9000
875	Maya Super market			1200

Re: Need Help on Bar Charts

marcus_sommer — Wed, 30 Dec 2015 10:28:06 GMT

You need to transform your data into a "normal" data-structure with The Crosstable Load

- Marcus

Re: Need Help on Bar Charts

Anonymous — Wed, 30 Dec 2015 10:38:22 GMT

Agreed with Marcus Sommer‌.

Did you try with the same data in creating a Bar chart, what issue you faced?

If it is just to plot a Bar,

Take Customer as a Dim

& Write these expression like:

Outstanding= sum(Outstanding)

AG01 = sum(AG01)

and so on till AG04+

Re: Need Help on Bar Charts

Anonymous — Wed, 30 Dec 2015 10:42:23 GMT

No Balraj, I need these column names should come as demension.

Re: Need Help on Bar Charts

Anonymous — Wed, 30 Dec 2015 10:44:25 GMT

thanks marcus, would you suggest any other way other than using cross table functionality.

Thanks & Regards,

Raju .K

Re: Need Help on Bar Charts

HirisH_V7 — Wed, 30 Dec 2015 10:55:50 GMT

Hi,

Please elaborate and tell your requirement on Bar chart what to be displayed.?!

-Hirish

Re: Need Help on Bar Charts

marcus_sommer — Wed, 30 Dec 2015 13:31:25 GMT

No, I wouldn't. The advantages of a "normal" structured table are huge against a crosstable and if you used a pivot-table you could easily create such a crosstable-view within the gui again. And if you really have a situation by which you need them somehow separatly you could use set analysis like:

sum({< [Monthly aging buckets] = {'AG01', 'AG02' /* .... */ }>} AnyValues)

whereby I would transform the AGxx into Month and associate them with a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus