topic Re: sum if set analysis in QlikView

sum if set analysis

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

hi there,

I want to write;

sum (sales)

filter1 : addmonths -2 (2 months before today)

filter2 : country=germany

can you help me write tihs with set analysis?

thanks.

Anil_Babu_Samineni — Tue, 14 Nov 2017 14:50:37 GMT

Perhaps this?

Sum({<DateField = {">=$(=AddMonths(Date(Today()), -2)) <=$(=Date(Today()-1))"}, country = {'germany'}>}sales)

sunny_talwar — Tue, 14 Nov 2017 14:51:07 GMT

May be this

Sum({<country = {'germany'}, Date = {"$(=Date(AddMonths(Today(), -2)))"}>}sales)

Anonymous — Tue, 14 Nov 2017 14:52:23 GMT

what is the $ for ?

sunny_talwar — Tue, 14 Nov 2017 14:57:05 GMT

Anonymous — Tue, 14 Nov 2017 16:07:33 GMT

and my date filter is in 'YYYYMM'

so is it :

=Sum({<country = {'Germany'}, Date = {"$(=Date(AddMonths(Today(), -2),'YYYYMM'))"}>}sales)

(error)

MK9885 — Tue, 14 Nov 2017 16:26:16 GMT

=Sum({<country = {'Germany'}, Num_Month = {$(=Max(Num_Month)-2)}>}sales)

This may work if you have months in numeric.

Like 1,2,3,4,....12