Creat a chart showing all orders created after 12pm

[#1]

Hi,

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

Appreciate your help.

[Kushal_Chawda · Accepted solution]

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]

Hi,

check this

Analyzing time in QlikView | Qlik Community