Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

While Multiplying Variables in Dimension & Measure

Dear Experts,

While multiplying variables in dimension i.e. $(vFGCompPrice) * $(vFGCompCurRate) * FGComponentQty it gives accurate result in Table chart.

Whereas if I i want to use the same expressions in measure of the same Table chart or in KPI (we have to use measure so the result is not correct) i.e. Sum($(vFGCompPrice) * $(vFGCompCurRate) * FGComponentQty) the result is being multiplied by the factor of 9 or something.

what could be the reason for this wrong result, I also tried to Aggr but could not get the desired results.

Thanks & Regards

11 Replies
Not applicable
Author

Thanks, it didn't work either.

markdg
Contributor
Contributor

Is there a resource for this type of syntax?