Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Bar Chart dimensions & expressions

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

5 Replies
Not applicable

Re: Bar Chart dimensions & expressions

See file attached!

Regards

Rahul

Not applicable

Re: Bar Chart dimensions & expressions

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. test.png

Not applicable

Re: Bar Chart dimensions & expressions

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

Not applicable

Re: Bar Chart dimensions & expressions

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

Not applicable

Re: Bar Chart dimensions & expressions

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

Community Browser