Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rmp001es
New Contributor II

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

Re: Set Analysis - percentage variation same month previous year

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()

5 Replies

Re: Set Analysis - percentage variation same month previous year

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

rmp001es
New Contributor II

Re: Set Analysis - percentage variation same month previous year

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

Re: Set Analysis - percentage variation same month previous year

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()

rmp001es
New Contributor II

Re: Set Analysis - percentage variation same month previous year

Ok thanks I´ll do it

rmp001es
New Contributor II

Re: Set Analysis - percentage variation same month previous year

It works perfect!!

Thank you very very very much!!

Community Browser