topic Re: Nested If condition in QlikView

Nested If condition

ashis — Wed, 25 Nov 2020 16:16:04 GMT

Hello ,

I have two fields and I am calculating GMT with the following command

Table1:

StartTimeReportUserTimeZone,,

StartTimeReport,

time#(interval(time(StartTimeReportUserTimeZone, 'hh:mm') - time(StartTimeReport, 'hh:mm'), 'h:mm'),'h:mm') as GMTID

from table1;

LOAD *,

if(GMTID='1:00','London',if(GMTID='2:00', 'Europe',if(GMTID='5:30','India', if(GMTID='8:00', 'Hongkong' ,if(GMTID='-4:00', 'Canada','NA'))))) as Location

resident table1;

drop table table1;

problem is when the value is -4:00 the location Cananda is not showing .

is something problematic where I am calculating GMTID. for all other values it is working fine.

Please advise.

Re: Nested If condition

tomasz_tru — Thu, 03 Aug 2017 10:09:16 GMT

Maybe try Pick(Wildmatch()) combination?

Re: Nested If condition

Anil_Babu_Samineni — Thu, 03 Aug 2017 10:09:45 GMT

May be try with this?

LOAD *,

if(GMTID='1:00','London',if(GMTID='2:00', 'Europe',if(GMTID='5:30','India', if(GMTID='8:00', 'Hongkong' ,if(Fabs(GMTID)='4:00', 'Canada','NA'))))) as Location

resident table1;

This should work, But not exactly rule of the scenario. Will you provide sample ?

Re: Nested If condition

Chanty4u — Thu, 03 Aug 2017 10:10:52 GMT

try here fabs

,if(fabs(GMTID='-4:00',

Re: Nested If condition

Chanty4u — Thu, 03 Aug 2017 10:11:06 GMT

Re: Nested If condition

Chanty4u — Thu, 03 Aug 2017 10:12:27 GMT

if it is not time you can try below way

=IF(Column(1)<0 and Column(2)<0,(Column(1)/Column(2))*-1,(Column(1)/Column(2)))

Re: Nested If condition

ashis — Thu, 03 Aug 2017 11:52:14 GMT

Nope , it did not work

Re: Nested If condition

ashis — Thu, 03 Aug 2017 11:52:38 GMT

It is time.

Re: Nested If condition

ashis — Thu, 03 Aug 2017 11:58:57 GMT

Thank you, it worked, is it a good idea to do wildmatch here since I am matching GMT value? please advise