Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Creat a chart showing all orders created after 12pm

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

2 Replies

Re: Creat a chart showing all orders created after 12pm

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

Highlighted
ajsjoshua
Contributor III

Re: Creat a chart showing all orders created after 12pm