Make a bar chart from a straight file.

[#1]

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.

[manisha_uit]

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

[#3]

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

[#4]

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

[#5]

thank you.