topic Re: Issue with set analysis in QlikView

Issue with set analysis

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

Hi,

I have used the below set analysis.

=Sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={">$(=Date(monthend(max([Calendar Date]),-6)) ,'DD-MMM-YYYY') <=$(=Date(monthend(max([Calendar Date]),-5)) ,'DD-MMM-YYYY'))"}>}[# Open])

Is there anything wrong with the above logic.

Because when i tested in text box I'm getting both the results means with and without set analysis were same.

Thanks..

Re: Issue with set analysis

olivierrobin — Wed, 18 Jul 2018 07:07:43 GMT

hello

if you have the same result with and without set analysis, it means you set analysis filters nothing

Just a question : isn't you formula equals to Calendar date=max(date)-5 ?

Re: Issue with set analysis

nareshthavidishetty — Wed, 18 Jul 2018 08:27:37 GMT

Yes

Re: Issue with set analysis

olivierrobin — Wed, 18 Jul 2018 08:39:34 GMT

so you can simplify you formula

did you verify that :

you have data corresponding to the selection

the format of the date field is correct