topic Set analysis in QlikView

Set analysis

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

Hi,

I have used the below logic to get the results as rollback months.But I'm getting same results for all as below.

Logic1 :

=num(Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-2)),'DD-MMM-YYYY'))"},[Age Days 90 Flag]={'Y'},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open])

/Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-2)),'DD-MMM-YYYY'))"},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open]),'#0.0%') = 17.1%

Logic2:

=num(Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-4)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY'))"},[Age Days 90 Flag]={'Y'},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open])

/Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-4)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY'))"},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open]),'#0.0%') = 17.1%

even though the logic is restrict to months it is giving same results.

Thanks..

Re: Set analysis

sunny_talwar — Tue, 17 Jul 2018 12:32:06 GMT

Would do you mean 'same results'? Would you be able to share a sample?

Re: Set analysis

nareshthavidishetty — Tue, 17 Jul 2018 13:02:35 GMT

HI,

Kindly find the attached document.

Thanks..

Re: Set analysis

sunny_talwar — Tue, 17 Jul 2018 13:08:00 GMT

Would you be able to tell us what is not right in the attached sample and what should it be?

Re: Set analysis

nareshthavidishetty — Tue, 17 Jul 2018 16:48:01 GMT

I'm getting same results for the months feb to nov.

It should suppose to be different.

The calendar is not picking up right while calculating the logic.

Thanks..

Re: Set analysis

nareshthavidishetty — Wed, 18 Jul 2018 05:36:38 GMT

Hi,

Any idea! Let me know why my set analysis is behaving like this.

Thanks..