11 Replies Latest reply: Jul 12, 2017 12:38 PM by Elizabeth Viso

# Calculation Condition for KPI

Hi,

Today is my day of questions!

I have a KPI that I want it to show only when a date is selected.

The Inspection Date expression is: =Date(Floor([CREATED DATE]), 'MMM DD, YYYY')

The condition I am trying is: =Count(Date(Floor([CREATED DATE]), 'MMM DD, YYYY')) <= 1

But it's not working.

Thanks

• ###### Re: Calculation Condition for KPI

can you do

=GetSelectedCount([Created Date])=1

• ###### Re: Calculation Condition for KPI

Do we have calculation conditions in Qlik Sense now?

• ###### Re: Calculation Condition for KPI

Probably not.  I didn't notice this was the Sense forum.

But I would guess she's trying to put in an IF statement.

IF(GetSelectedCount([Created Date])=1,Date(Floor([CREATED DATE]), 'MMM DD, YYYY'))

• ###### Re: Calculation Condition for KPI

No he if statement isn't what I need, I've already tried that.

Thanks

• ###### Re: Calculation Condition for KPI

Did you try just

=GetSelectedCount([Created Date])=1

• ###### Re: Calculation Condition for KPI

I did that one also and nothing. Today is not my day with Qlik lol

• ###### Re: Calculation Condition for KPI

=Count(DISTINCT Date(Floor([CREATED DATE]), 'MMM DD, YYYY')) <= 1

• ###### Re: Calculation Condition for KPI

YES!! That worked!

Thank you so very much Wallo

• ###### Re: Calculation Condition for KPI

Hey Sunny,

Yes, I can do it when setting up for a Building but not with the date.

• ###### Re: Calculation Condition for KPI

Hi Elizabeth,

what do you mean with calculated condition for KPI, do you mean an appearance if you select any values, if yes, in qlik sense it is not possible to hide any objects by selecting of data

i hope this info helps you

Beck

• ###### Re: Calculation Condition for KPI

Hey Beck,

I am able to hide an object until a building is selected. But when I try with the date it doesn't work.