Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Set filter value and ignore any other selections...

May be this:

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

Not applicable

Re: Set filter value and ignore any other selections...

Thanks Sunny, that was exactly it!

Cheers and thanks again for the help.