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: 
Not applicable

Creat a chart showing all orders created after 12pm

Hi,

I need to put a chart showing only orders after 12pm.

Appreciate your help.

1 Solution

Accepted Solutions
Kushal_Chawda

Create the Flag in script like below

if( frac([Time Measure]) > maketime(12,0,0),1,0) as TimeFlag

Now use this Flag in your Expression , one eg. is below

=Sum({<TimeFlag={'1'}>}Values)

Make sure that your [Time Measure] is correctly formatted meaning that not a string value, if it is string then try below

=if(frac(time#([Time Measure],'hh:mm:ss TT')) > maketime(12,0,0),1,0) as TimeFlag

View solution in original post

2 Replies
Kushal_Chawda

Create the Flag in script like below

if( frac([Time Measure]) > maketime(12,0,0),1,0) as TimeFlag

Now use this Flag in your Expression , one eg. is below

=Sum({<TimeFlag={'1'}>}Values)

Make sure that your [Time Measure] is correctly formatted meaning that not a string value, if it is string then try below

=if(frac(time#([Time Measure],'hh:mm:ss TT')) > maketime(12,0,0),1,0) as TimeFlag

ajsjoshua
Specialist
Specialist