Discussion board where members can get started with QlikView.
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
See file attached!
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.
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.
Am so sorry! PFA... Consumption per product in each State. I know its not that good of an example
You could try like:
Assuming you load the data depicted as TempData try the following script:
'Product1' as Product_Cat,
Product1 as Amt
'Product2' as Product_Cat,
Product2 as Amt
and so to consolidate your Dimensions
then drop the temp table.
Hope it works!