topic Re: Make a bar chart from a straight file. in QlikView

Make a bar chart from a straight file.

Wed, 02 Jul 2014 09:58:27 GMT

Hi everyone,

Can anyone help me with my problem I cannot create a simple BAR Chart graph in QLIKVIEW.

Attached is the file I want to create. Note the each of the column is the actual column from the file.

How can I put in X-AXIS the months against the TYPE?

Thank you.

Re: Make a bar chart from a straight file.

manisha_uit — Wed, 02 Jul 2014 10:20:35 GMT

Hi,

In the script, you can use cross table, something like this:

CrossTable(Month, Data, 3)

LOAD Year,

Country,

Type,

Apr,

May,

Jun,

...

FROM .....

Now, you will have a field 'Month' created with all the month names in it. You can use that field in your chart

Thanks,

Manisha

Re: Make a bar chart from a straight file.

Wed, 02 Jul 2014 10:33:39 GMT

Hi,

While loading the data use cross table option and take qualifier field as 3

like this

or use this script directly

CrossTable(Month, Data, 3)

LOAD Year_,

Country_,

Type_,

APR,

MAY,

JUN,

JUL,

AUG,

SEPT,

OCT,

NOV,

DEC,

JAN,

FEB,

MAR

FROM

D:\Vivek\BAR_CHART.xlsx

(ooxml, embedded labels, table is Sheet1);

Now 'Month' and 'Type_' in Dimension and =Sum(Data) as Expression

Your bar Chart will be like this

Regards

Vivek

Re: Make a bar chart from a straight file.

Thu, 03 Jul 2014 01:13:06 GMT

Thank you so much. It worked. Very well explained for a noob.

Re: Make a bar chart from a straight file.

Thu, 03 Jul 2014 01:13:27 GMT

thank you.