topic doubt about expression! in QlikView

doubt about expression!

Mon, 03 Aug 2015 15:55:32 GMT

Hi, modeling the data i did this

I'd like to see in bonificaciones% only one expresion. this will be gross_sales + bonificaciones_nc + otras_bonificaciones / bonificaciones_prov

do you think i can do this?

regards

Mon, 03 Aug 2015 16:45:09 GMT

I do not see why you would not be able to do this

Suggestion - do in the load script and so you do not have to claculate each time the user selects anything.

Make sure each item in the calcualtion is a dimension, which it sounds like it is, and I do not see it as an issue

Mon, 03 Aug 2015 17:18:42 GMT

Hi thank you for your answer.

Because of the model, i'd like to sum this in the expression.

What expression do you suggest?

Regards,

Kushal_Chawda — Mon, 03 Aug 2015 17:40:32 GMT

try below expression

(sum(gross_sales) + sum(bonificaciones_nc) + sum(otras_bonificaciones)) /sum( bonificaciones_prov)

Mon, 03 Aug 2015 17:42:07 GMT

These aren't expressions. They're dimmensions. The only expression is SUM(VALOR)

Greetings.

Mon, 03 Aug 2015 18:19:32 GMT

I agree with Kush141087, not sure I understand your comment 'These aren't expressions. They're dimmensions. The only expression is SUM(VALOR)'