Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

time bracket

Hiya

I have a time bracket working for 12 hours, but I need to get it to work for weeks

if(([CustomerOrderDateTime] - [CustomerOrderDateTimeComplete]) >= (1/2), 1,0) as [12 Hour Bracket]

how do I change this section  (1/2), to get e.g. 1 week?

Kind Regards

Joeybird

1 Solution

Accepted Solutions

Re: time bracket

If I understand this correctly:

IF 1/2=12 hours

then 7 days*24=168 hours

2 Replies

Re: time bracket

If I understand this correctly:

IF 1/2=12 hours

then 7 days*24=168 hours

joeybird
Contributor II

Re: time bracket

Hiya

brill!

thanx

kind regards

joeybird