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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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