Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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") 😉