topic Re: Help in expression in QlikView

Help in expression

carlos13 — Thu, 20 Feb 2014 15:33:38 GMT

If I can help calculate an operation, the result is having the pivot table is incorrect in an expression.

I want to make the operation A / (A + B) of expressions

Thanks,

Carlos

Re: Help in expression

datanibbler — Thu, 20 Feb 2014 15:41:30 GMT

Hi Carlos,

that looks correct - but for the fact that it's all calculated at the same time, not sequentially, so you cannot refer to the expression in column "A" just by typing "A" - you have to actually type the expression there.

Re: Help in expression

carlos13 — Thu, 20 Feb 2014 15:50:37 GMT

Hi DataNibbler,

What I want is to get the final result as shown in the text objects to be 45.96%

Re: Help in expression

datanibbler — Thu, 20 Feb 2014 16:04:40 GMT

Hi Carlos,

I don't know what that is - the average? How is it calculated?

Anyway, you just play around a bit with the properties_dialog - "formula" tab - that box "total value" (on the right-hand side) - you have a dropdown_box there to select "xx of y_axis_values"

HTH

Best regards,

DataNibbler