topic Why does my Set Analysis respond to selections even though it includes ignore fields specified? in QlikView

Why does my Set Analysis respond to selections even though it includes ignore fields specified?

nicogene — Sun, 30 Jul 2017 21:35:23 GMT

Hello,

I hope this message finds you well.

As you can see from the expression there are clause to ignore selections in field TEST:

=sum({<TEST=, Dates={">=$(=AddYears(min(Dates),0)) <=$(=AddYears(max(Dates),0))"}>} Amount)

But when I make selections the dashboard starts responding.

Please find attached the .qvw

Thank you in advance for your help.

Kind regards,

Nicolas.

sunny_talwar — Sun, 30 Jul 2017 23:28:17 GMT

Your date range changes when you select TEST, ignore selection of TEST in your date range as well

=sum({<TEST=, Dates={">=$(=AddYears(min({<TEST>}Dates),0)) <=$(=AddYears(max({<TEST>}Dates),0))"}>} Amount)

=sum({<TEST=,Année=,Dates={">=$(=AddYears(min({<TEST>}Dates),-1)) <=$(=AddYears(max({<TEST>}Dates),-1))"}>} Amount)

arvind_patil — Mon, 31 Jul 2017 05:45:52 GMT

Nice Work Sunny.

It will definitely help me.

Thanks,

Arvind Patil