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: 
hammermill21
Creator III
Creator III

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

building on yours how about

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

View solution in original post

11 Replies
Anonymous
Not applicable

can you do

=GetSelectedCount([Created Date])=1

sunny_talwar

Do we have calculation conditions in Qlik Sense now?

Anonymous
Not applicable

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'))

beck_bakytbek
Master
Master

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

hammermill21
Creator III
Creator III
Author

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.

Condition.JPG

hammermill21
Creator III
Creator III
Author

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

Thanks

hammermill21
Creator III
Creator III
Author

Hey Sunny,

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

Condition.JPG

Anonymous
Not applicable

Did you try just

=GetSelectedCount([Created Date])=1

hammermill21
Creator III
Creator III
Author

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