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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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