Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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.

Labels (1)
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