Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
carlos13
Creator
Creator

Help in expression

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

3 Replies
datanibbler
Champion
Champion

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.

carlos13
Creator
Creator
Author

Hi DataNibbler,

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

datanibbler
Champion
Champion

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