Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Changed Dimension and expressions.

Regards,

Jagan.

View solution in original post

11 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

No need to calculate for office separately.

Just add office to your dimension.

Can you post sample app with expected output to help you out further.

Regards

ASHFAQ

Not applicable
Author

I have already office names as one of my dimensions . yes sure I  have a sample app to post but I dont know how to do this here

Thanks in advance

Anonymous
Not applicable
Author

When replying click Use Advanced Editor and the Attach will appear.

Not applicable
Author

Thank you

Not applicable
Author

This is my sample app

ashfaq_haseeb
Champion III
Champion III

Hi,

may be like this.

You can modify formula as required.

Regards

ASHFAQ

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Changed Dimension and expressions.

Regards,

Jagan.

Not applicable
Author

This is exactly what I want Thank you so much !

jagan
Luminary Alumni
Luminary Alumni

Hi,

If you got the solution please close this thread.

Regards,

Jagan.