topic Trying to use IF in calculated dimension in QlikView

Trying to use IF in calculated dimension

Thu, 17 Sep 2015 12:51:13 GMT

I am trying to use the below IF statement in a calculated dimension and it does not seem to be working.

=if(A = '', (if(B= '',time(C,'hh:mm:ss'),time(B,'hh:mm:ss'))),time(A,'hh:mm:ss'))

Basically the logic is, if A is null, then check if B is null - if that's the case return C (in the time format specified), else return B (if B is not null). If A is not null, then return A.

Any help would be appreciated.

Thank you,

Amit

Re: Trying to use IF in calculated dimension

pokassov — Thu, 17 Sep 2015 12:54:04 GMT

Hi!

Try this

if(isnull(A), ...

time(alt(A,B,C),'hh:mm:ss')

Re: Trying to use IF in calculated dimension

dclark0699 — Thu, 17 Sep 2015 12:56:16 GMT

If all three field are dual fields, meaning they have both a number format and a datetime format, you should be able to do

time(ALT(a,b,c),'hh:mm:ss')

Re: Trying to use IF in calculated dimension

sunny_talwar — Thu, 17 Sep 2015 13:55:39 GMT

When you say it's not working, what exactly is going wrong?

Try this may be:

=if(Len(Trim(A)) = 0,

if(Len(Trim(B)) = 0, Time(C,'hh:mm:ss'), Time(B,'hh:mm:ss')), Time(A,'hh:mm:ss'))