error when adding dimension calculated QlikView

[#1]

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

help me please

[Anonymous]

What is the expression of your calculated dimension?

[v_iyyappan]

Hi,

    I cant understand .Please attached a sample QV file.

Regards

Iyyappan

[jagan]

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.

[#5]

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

[#6]

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