Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set filter value and ignore any other selections...

Hi,

Need help in figuring this out.

I have a normal KPI showing the a Sum(value), and what I am trying to do, is set the Sum(Value) to show only for the previous month / current year, but at the same time, ignore if the user changes the Month or Year filter.

How do I enter the setin the expression to simultaneously "force" month and year, and then tell it to ignore the filters? Is this possible even?

Any suggestions or work around?

Cheers.

Adriano.

2 Replies
sunny_talwar

May be this:

Sum({<Date = {"$(='>=' & Date(MonthStart(Today(), -1), 'DateFieldFormatHere') & '<=' & Date(MonthEnd(Today(), -1), 'DateFieldFormatHere'))"}, Month, Year, MonthYear>}value)

Not applicable
Author

Thanks Sunny, that was exactly it!

Cheers and thanks again for the help.