topic Re: if statement in QlikView

if statement

userid128223 — Thu, 14 Dec 2017 13:57:34 GMT

I want to write if statement with time. (hh:mm)

I have a field dimension like below:

Time

00:25

02:44

18:25

00:00

In a pivot or straight table i just want show Time field if it is more then 00:00 otherwise make it null. Please show how.

Ralf_Heukäufer — Thu, 14 Dec 2017 14:04:02 GMT

if(Time='00:00',null(),Time)

Anil_Babu_Samineni — Thu, 14 Dec 2017 14:13:24 GMT

Null means you are going to kill those?

If(Time = Time(MakeTime('00:00'), 'hh:mm'), 'Null', Time)

If(Time = Time(MakeTime('00:00'), 'hh:mm'), ' ', Time)

userid128223 — Thu, 14 Dec 2017 14:18:28 GMT

getting results in -decimals.

userid128223 — Thu, 14 Dec 2017 14:19:24 GMT

null means just keep the field empty. don't show anything.

Ralf_Heukäufer — Thu, 14 Dec 2017 14:22:27 GMT

if(Time='00:00',null(),Time(Time,'hh:mm'))

userid128223 — Thu, 14 Dec 2017 14:26:08 GMT

I am getting results in decimal format.

Anil_Babu_Samineni — Thu, 14 Dec 2017 15:07:26 GMT

Would you mind, Can you please provide sample?

userid128223 — Thu, 14 Dec 2017 22:43:02 GMT

1:00 is showing up as 4239.0416666667

Anil_Babu_Samineni — Fri, 15 Dec 2017 01:54:51 GMT

May be this?

If(Time = Time(MakeTime('00:00'), 'hh:mm'), ' ', Interval(Time/24/60/60, 'hh:mm'))