Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
vipingarg23
Creator
Creator

Expression total is giving wrong value

Hi All,

When I am calculating the percentage of red marked column by expression total, it is giving me the wrong data. Can anybody help me ?

11 Replies
vinieme12
Champion III
Champion III

Also i don't think you can use Aggregation functions with column references!!

as you said A and B are expressions which means they have aggregations functions like sum,min or max

so Sum(A) or Sum(B) will never work!

To have Expression totals you need an aggregation function so i suggest you rewrite the expression for A and B

C = Full expression for B / Full expression for A  * 100


Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vipingarg23
Creator
Creator
Author

Yes...It is working for me..Thanks for your help.