topic Re: Set Analysis Sum B/w two dates in QlikView

Set Analysis Sum B/w two dates

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

Hi,

I am trying to get the sum by set analysis b/w two dates. Following is the table which have the value in CDC1 and CDC7. Total Sum of CDC1 is 2 And CDC7 is 7.

The table I am trying to design as below:

Draw	Description	CDC1	CDC7
EM+	Last 3 Months	2	3

Can you please advise me related to this? The sample qvw file is attached.

Kind regards,

Farrukh

Re: Set Analysis Sum B/w two dates

olivierrobin — Tue, 10 Apr 2018 09:58:05 GMT

hello

try in a set analysis using th syntax

month={'>Inital Month<Last Month'}

Re: Set Analysis Sum B/w two dates

chinnuchinni — Tue, 10 Apr 2018 09:59:00 GMT

can attach the app,then we can try to help you .

Re: Set Analysis Sum B/w two dates

Anonymous — Tue, 10 Apr 2018 10:10:59 GMT

I tried this but did not work.

Currently using the below set analysis as below:

Dimension:

=Aggr(Only({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriodStart)<=$(=vPeriodEnd)"}>} Draw) , Draw)

Expression:

=Sum({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriodStart)<=$(=vPeriodEnd)"}>} CDC1)

Re: Set Analysis Sum B/w two dates

Anonymous — Tue, 10 Apr 2018 10:12:57 GMT

Hi Praveen,

Please see the attached qvw file.

Kind regards,

Farrukh

Re: Set Analysis Sum B/w two dates

Anonymous — Tue, 10 Apr 2018 10:14:33 GMT

Hi Olivier,

Currently using the below set analysis as below:

Dimension:

=Aggr(Only({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriodStart)<=$(=vPeriodEnd)"}>} Draw) , Draw)

Expression:

=Sum({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriodStart)<=$(=vPeriodEnd)"}>} CDC1)

Also I tried with Sum(CDC1) but did not work.

Regards,

Farrukh

Re: Set Analysis Sum B/w two dates

sunny_talwar — Tue, 10 Apr 2018 10:33:55 GMT

May be try this

=Sum({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriodStart)<=$(=vPeriodEnd)"}>}Aggr(Only({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriodStart)<=$(=vPeriodEnd)"}>} CDC1), Draw, Period, Result, Description))

and

Re: Set Analysis Sum B/w two dates

Anonymous — Tue, 10 Apr 2018 11:12:23 GMT

Thanks a mil Sunny.

Its sorted.

Kind regards,

Farrukh