set analysis to get each month sum(amount)

aj0031724 — Tue, 15 Sep 2015 11:53:11 GMT

Team,

In the rolling3months.qvw , how can I compare the sum(amount) for rolling 3 months at each month with set analysis and do some classification logic accordingly .

example>Month 3 is selected than last 3 months including selected month is to be compared for sum(amount) and create a new colmumn named"classification"" which will from below logic.

High-->if last 2 months sum(amount) greater than 4

Low--> if last 3 months sum(amount) less than 4

Standard-- if last 3 months sum(amount) equals 4.

In this case Month 3 will be marked accordingly (either High or Low or Standard).

Re: set analysis to get each month sum(amount)

aj0031724 — Wed, 16 Sep 2015 12:31:50 GMT

Dear team,

Can you please suggest?

topic set analysis to get each month sum(amount) in QlikView

set analysis to get each month sum(amount)

Re: set analysis to get each month sum(amount)