topic Re: Bar Chart dimensions & expressions in QlikView

Bar Chart dimensions & expressions

Mon, 13 Aug 2012 10:17:41 GMT

This is very basic question for you all but I need some help.

I have this data in excel sheet showing consumption in sectors A to D from Year 2001-2020. Please help me create a bar chart. What can be the dimensions and expressions for this

Thanks,

Mandy

Re: Bar Chart dimensions & expressions

Mon, 13 Aug 2012 10:41:18 GMT

See file attached!

Regards

Rahul

Re: Bar Chart dimensions & expressions

Mon, 13 Aug 2012 10:52:39 GMT

Thanks so much Rahul. Appreciate that!

If I have around 200 rows of data or more, then I cannot write each and every value in my script. So how would I show this data? Please see attached file.

Re: Bar Chart dimensions & expressions

Mon, 13 Aug 2012 11:04:30 GMT

Dear Mandy,

In the image you posted there is only one dimension (looks like state), plus the headers are missing. I had taken your test data set literally. However I am sure your dimension is clubbed under one head.

If possible please post an example.

Regards

Rahul

Re: Bar Chart dimensions & expressions

Mon, 13 Aug 2012 11:13:48 GMT

Am so sorry! PFA... Consumption per product in each State. I know its not that good of an example

Re: Bar Chart dimensions & expressions

Mon, 13 Aug 2012 14:01:00 GMT

Dear Mandy:

You could try like:

Assuming you load the data depicted as TempData try the following script:

FinalDate:

Load

'Product1' as Product_Cat,

State,

Product1 as Amt

Resident TempData;

Outer Join

Load

'Product2' as Product_Cat,

State,

Product2 as Amt

Resident TempData;

and so to consolidate your Dimensions

then drop the temp table.

Hope it works!

Regards

Rahul