topic Re: Set Analysis - percentage variation same month previous year in QlikView

Set Analysis - percentage variation same month previous year

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

sunny_talwar — Tue, 13 Mar 2018 17:13:42 GMT

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

Anonymous — Wed, 14 Mar 2018 15:30:38 GMT

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 — Wed, 14 Mar 2018 16:15:40 GMT

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

Anonymous — Wed, 14 Mar 2018 16:17:20 GMT

Ok thanks I´ll do it

Anonymous — Thu, 15 Mar 2018 09:33:29 GMT

It works perfect!!

Thank you very very very much!!