topic Re: How to fetch data in a chart from different fields in QlikView

How to fetch data in a chart from different fields

Wed, 19 Jun 2013 06:38:56 GMT

Hi all,

I need to create a bar chart with month as the dimension, for that i hav values in diffrent fields lik jan month data,feb mnth data,etc.. based on different customers.in my chart i want to display for a particular mnth the 'value' for specific dealers.

Re: How to fetch data in a chart from different fields

Wed, 19 Jun 2013 07:29:23 GMT

Pls Load the script.Hope it will work.

RawData:LOAD customer,
     customer_id,
     Zone,
     jan_value,     Feb_value,      Mar_value,      April_value,
     May_value

FROM[dummy data.xlsx](ooxml, embedded labels, table is Sheet1);

DataTemp:CrossTable(MonthID,Value,3)LOAD *
     Resident RawData;
     DROP Table RawData;

Data:
LOAD customer,      customer_id,      Zone,
     Left(MonthID,3) As Month,
     Value
      Resident DataTemp;     DROP Table DataTemp;

Regards-Bika

Re: How to fetch data in a chart from different fields

narender123 — Wed, 19 Jun 2013 07:57:44 GMT

Hi Reena,

You need to make cross table.

example:

load //your original table

customer ,

customer_id,

zone,

jan,

feb,

march

from abc;

new1:

crosstable(month,value,3)

customer ,

customer_id,

zone,

jan,

feb,

march

resident abc;

drop table abc;

now in new1 table

month field heaning (jan,feb,march) and value field heaving (that are in month field)

in your expression ,now you can take the dimention as month and calculation expression via value field.

Thanks

Narender

Re: How to fetch data in a chart from different fields

Thu, 20 Jun 2013 06:35:37 GMT

Thanks..it works...