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

How to get Difference of a two Records of Same Colums Sum

I am Having Data Like Following..

DataBaseSTORE CCODEGROSSDISCOUNT
CO12250122855120600215
ReSA12250122855120600215
CO13521234821232552310
ReSA13521234821232552310

I want to Show the Difference of GROSS between two DataBases for particular Store, as well as for DISCOUNT also.

Please help me to get this.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

How about: max(GROSS)-min(GROSS)


talk is cheap, supply exceeds demand