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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the difference amounts in two different years

Hi

I have two dimensions which one of them is office names and the other one is years. I calculated the sum of sale amount of each office name in each year in expression column . How can I have the differences sale amount between two years ( current and previous year) in one office ?

Note: 92 and 93 are years

QVHelp.png

Labels (1)
11 Replies
Not applicable
Author

Hi

Yes I got the solution, Is there any special way to close the thread? sorry I'm actually new here

Thanks

Farzaneh

jagan
Partner - Champion III
Partner - Champion III

By giving Correct Answer you closed this thread.

Regards,

jagan.