Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

I want to show in KPI window the day after tomorrow

Hello,

I want to use a kpi window and always showing me the day after tomorrow .But only that day which also exist in the auto.calendar. Because I don't want to count the weekends. 

Like this:

=[deliverydate.autoCalendar.Date]=("$(=Date(Today()+2))")

It doesn't work out though.No returns.  but even when it work out would I guess it would count the weekends, which I dont want. 

Thanks in advance. 

 

1 Solution

Accepted Solutions
Taoufiq_Zarra

@Applicable88 

Do you want to show only the day after tomorrow or do you want to use it in another indicator .

if you want to show only the day look at this example :

assume that I have this sample :

Data:
load * inline [
Date,P
17/06/2020,1
18/06/2020,2
19/06/2020,3
20/06/2020,4
];

 

If I use this Indicators :

=Only({<Date={"$(=Date(Today()+2))"}>} Date)

 

the output :

Capture.PNG

you must check date format

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

@Applicable88 

Do you want to show only the day after tomorrow or do you want to use it in another indicator .

if you want to show only the day look at this example :

assume that I have this sample :

Data:
load * inline [
Date,P
17/06/2020,1
18/06/2020,2
19/06/2020,3
20/06/2020,4
];

 

If I use this Indicators :

=Only({<Date={"$(=Date(Today()+2))"}>} Date)

 

the output :

Capture.PNG

you must check date format

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉