topic Add Calculated Dimension... in QlikView

Add Calculated Dimension...

danialier — Mon, 16 Mar 2015 16:34:00 GMT

Hello,

I have a Grid Chart displaying countries (x axis) and I want to show in the y axis the revenues.

For that reason I tried to add a new dimension by clicking the "Add Calculated Dimension..." in the 'Dimensions" tab. Then, in the edit expression I entered "=sum(Revenues)".

However in the Grid Chart an error message says"//Error in calculated dimension"

I don't know what I'm doing wrong...

Please help.

BR,

dani

Re: Add Calculated Dimension...

Gysbert_Wassenaar — Mon, 16 Mar 2015 16:38:03 GMT

sum(revenues) will only return one value, not a list of values. You'll have to use the aggr function to aggregate the sum over one or more dimensions. Something like =agg(sum(revenues),CountryName). Or perhaps you want to create buckets of revenue. In that case you can use the Class function: =class(sum(revenues),1000)

Re: Add Calculated Dimension...

richard_chilvers — Mon, 16 Mar 2015 16:47:13 GMT

Perhaps you don't need a grid chart ? If you simply want to show total revenue for each country, try starting with a bar chart. A grid chart usually has 2 dimensions and an expression.