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: 
Anonymous
Not applicable

Addition and subtraction of expressions

Regards, I have a drawback when making the sums and subtraction of the columns name gives the results that should come out ie I want to add the 4 that is the header in colors and subtract that result with the column that says valid in the other column,qlik.jpg

I thank you in advance for your help in this regard.

Mensaje editado por: Pedro Calderon Flores

3 Replies
vishsaggi
Champion III
Champion III

Something like

Sumof4

= Rangesum(Before(Sum(yourdimension), 1,4))

Vigente-Sumof4

= Vigente - Sumof4

Can you share a sample data if possible to work on?

Anonymous
Not applicable
Author

Thanks Nagaraju for your help I used to get what I wanted to use this formula RangeSum ([1-30], [31-60], [61-90], [> 90]) in the end it happens that I used the numsum and not The RangeSum. Thank you very much.

sunny_talwar

Is your question resolved? If it is, I would suggest closing this thread down by marking the correct response, else please explain what is still the issue.

Best,

Sunny