Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted
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

5 Replies
Highlighted
Partner
Partner

Re: LOCK A FILTER VALUE KPI

Put a 1 on your inner max expression as well
Highlighted
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
Contributor

Re: LOCK A FILTER VALUE KPI

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

Highlighted
Partner
Partner

Re: LOCK A FILTER VALUE KPI

happy to help
Highlighted
Partner
Partner

Re: LOCK A FILTER VALUE KPI

But it's not working for me on this condition..

count({<[VIEW_NBOREPORT.ISSUANCE_YEAR]={'$(vMaxYear)'},
[VIEW_NBOREPORT.ISSUANCE_DATE]={'$(vMaxDate)'},
[VIEW_NBOREPORT.ISSUANCE_MONTH]=,[VIEW_NBOREPORT.ISSUANCE_DAY]=,[VIEW_NBOREPORT.ISSUANCE_Month_Year]=
>}
[VIEW_NBOREPORT.POLICY_NO]
)