Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
nicogene
Partner - Contributor III
Partner - Contributor III

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

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.

2 Replies
sunny_talwar

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
Partner - Specialist III
Partner - Specialist III

Nice Work Sunny.

It will definitely help me.

Thanks,

Arvind Patil