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

Set Analysis - percentage variation same month previous year

Hi,

I need help. I tell you what happens to me:

I have a Linktable with data of different months and years with the following fields.

AñoMesVta% Vta (ma)
201601100,950.00%
20160299,250.00%
...
...
201701150,8549,43%
201702160,2561,46%
...
...
201801200,2532,74%
201802150,79-5,90%

I need % Vta c/vat, it is feasible for the variation of the Data 201801 in respect of one of 201701, and thus for all records.

I'm stuck !!

Thank you very much in advance

Regards

1 Solution

Accepted Solutions
sunny_talwar

AFAIK it won't.... you can look into Above/Below function in case you don't want to do it in the script

Missing Manual - Above() and Below()

View solution in original post

5 Replies
sunny_talwar

Best way to handle this would be to use The As-Of Table

Anonymous
Not applicable
Author

Thank you very much for Info.

I´ll try to do it as soon as possible.

Just only 1 more question. It would be posible to resolve in Set Analysis?

Regards

sunny_talwar

AFAIK it won't.... you can look into Above/Below function in case you don't want to do it in the script

Missing Manual - Above() and Below()

Anonymous
Not applicable
Author

Ok thanks I´ll do it

Anonymous
Not applicable
Author

It works perfect!!

Thank you very very very much!!