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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
pavansonu99
Creator
Creator

how to compare to values in same field

Capture.PNG

in the above picture u can see the first column  is year and 3rd column is sales i want difference of 1st 2 sales and next i want difference of next 2 sales for 2004 and for 2005 again i want differences of sales  for that year

can you please provide the expression.

thanks in advance

3 Replies
rupamjyotidas
Specialist
Specialist

Didn't understand the whole question:-). Probably this might work in script

Sales-Peek(Sales)

Anonymous
Not applicable

may be try this in pivot or straight table

SALES-RANGESUM(ABOVE(SUM({1}(SALES)),0,2)) 

pavansonu99
Creator
Creator
Author

i want for year 2004 the differences of sales.

then i want it for next year like that