topic error when adding dimension calculated QlikView in QlikView

error when adding dimension calculated QlikView

Sat, 11 Feb 2012 00:40:07 GMT

error when adding dimension calculated QlikView
how to do to add a dimension calculated

help me please

error when adding dimension calculated QlikView

Anonymous — Sat, 11 Feb 2012 02:21:37 GMT

What is the expression of your calculated dimension?

error when adding dimension calculated QlikView

v_iyyappan — Sat, 11 Feb 2012 05:42:39 GMT

Hi,

I cant understand .Please attached a sample QV file.

Regards

Iyyappan

error when adding dimension calculated QlikView

jagan — Sat, 11 Feb 2012 07:17:54 GMT

Hi,

Go to Chart Properties -> Dimensions -> Click "Add Calculation Dimension" dimension -> Enter your expression

Example : You have Fields FirstName and LastName and you want to add a dimension by Concatenating both FirstName and LastName as Name then you can create the expression like below

=FirstName & ', ' & LastName

Now the Dimension displays the concatenated name with First and Last name.

Note : The above is just for an example, you can also do this in script also.

Regards,

Jagan.

error when adding dimension calculated QlikView

Sat, 11 Feb 2012 15:49:15 GMT

for example: Sum({< Calendardate = {'>=$(=Date(Vstartdate))<=$(=Date(venddate))'} >} CantidadS)

error when adding dimension calculated QlikView

Sat, 11 Feb 2012 18:41:47 GMT

Hi, you can not use group functions direclty in calculated dimension.

Why don't you add it as an expression?

Calculated dimensions are more resource heavy. (But sometimes may be better also!)

And if you have a need to use sum in your dimension then you will need to use advanced aggregation function aggr.

So, something like,

aggr(Sum({< Calendardate = {'>=$(=Date(Vstartdate))<=$(=Date(venddate))'} >} CantidadS),[Field_based_on_which_you_want_sum])

Hope it helps.

Ashutosh