Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Set analysis for today is not working

Hi All,

My date field is DocDate.

I want to calculate the total Deliveries for today.

My set expression is

Sum({<DocDate={'=$(=Date(Today()))'}>}Delivered_Quantity)

example: Total Delivered Quantity 7000

Delivered Quantity for today 500

 

It giving me the result as Total Delivered Quantity till today i.e. 7000 but i want result for today i.e. 500 

 

 

Please help.

Regards,

Priyal

 

 

 

1 Solution

Accepted Solutions
Highlighted
Master
Master

Re: Set analysis for today is not working

Hi

Try this.

 

Script:

 

T:
LOAD Date,
Date(floor(Date),'DD/MM/YYYY') as Date_N,
Delivered_Quantity,
Status
FROM
[C:\Users\XYZ\Desktop\Dummy Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

 

Your expression in text box :

=sum({<Date_N = {"$(=Date(Today(),'DD/MM/YYYY'))"}>}Delivered_Quantity)

View solution in original post

8 Replies
Highlighted
Creator
Creator

Re: Set analysis for today is not working

can you please attach the sample data?

 

Highlighted
Luminary
Luminary

Re: Set analysis for today is not working

Make sure that the DocDate format is the same as the one defined in your Main script section, e.g. DD.MM.YYYY. 

You can use the Date function in the set analysis to adjust this, e.g.

Date(Today(), 'DD.MM.YYYY')

Also use double quotes in the set analysis as this is a search string. 

Highlighted
Creator
Creator

Re: Set analysis for today is not working

PFA.

Highlighted
Contributor
Contributor

Re: Set analysis for today is not working

Sum({<DocDate={"$(=Num(Date(Today())))"}>}QTY)

use this set analysis and make sure your  date is in NUM format.

QTY =Delivered_quantity 

Highlighted
Creator
Creator

Re: Set analysis for today is not working

sorry but not working

 

Highlighted
Master
Master

Re: Set analysis for today is not working

Hi

Try this.

 

Script:

 

T:
LOAD Date,
Date(floor(Date),'DD/MM/YYYY') as Date_N,
Delivered_Quantity,
Status
FROM
[C:\Users\XYZ\Desktop\Dummy Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

 

Your expression in text box :

=sum({<Date_N = {"$(=Date(Today(),'DD/MM/YYYY'))"}>}Delivered_Quantity)

View solution in original post

Highlighted
Creator
Creator

Re: Set analysis for today is not working

Thanks,its working....
Highlighted
Master
Master

Re: Set analysis for today is not working

Glad to know it helped