Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

See file attached!

Regards

Rahul

Not applicable
Author

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
Author

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
Author

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

Not applicable
Author

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