Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Nice Work Sunny.
It will definitely help me.
Thanks,
Arvind Patil