Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
antoniodneto
Contributor

LOCK A FILTER VALUE KPI

Hi Guys I have one KPI with this expression

=sum({1<DATA_BASE={"$(=Date(AddMonths(Max(Date#(DATA_BASE,'YYYYMM')),-3),'YYYYMM'))" }>}OVER_NOTA_AUX)

I'm using "1" to ignore my filters, but when I select anything from DATA_BASE field my KPI changes, any ideas?

Tks a lot!

1 Solution

Accepted Solutions
Partner
Partner

Re: LOCK A FILTER VALUE KPI

=sum({1<DATA_BASE={"$(=Date(AddMonths(Max({1}Date#(DATA_BASE,'YYYYMM')),-3),'YYYYMM'))" }>}OVER_NOTA_AUX)

View solution in original post

4 Replies
Partner
Partner

Re: LOCK A FILTER VALUE KPI

Put a 1 on your inner max expression as well
Partner
Partner

Re: LOCK A FILTER VALUE KPI

=sum({1<DATA_BASE={"$(=Date(AddMonths(Max({1}Date#(DATA_BASE,'YYYYMM')),-3),'YYYYMM'))" }>}OVER_NOTA_AUX)

View solution in original post

Highlighted
antoniodneto
Contributor

Re: LOCK A FILTER VALUE KPI

Tks so much!! It worked pretty fine!!!

Partner
Partner

Re: LOCK A FILTER VALUE KPI

happy to help