topic Re: Nested if with And issue in App Development

Nested if with And issue

avermalla — Wed, 27 Dec 2017 15:14:04 GMT

I am creating a Calculated Field when uploading data through Data Manager in Qlik Sense

the formula for the calculated field is as follows:

if(FlgtHour<=10,'1st Wave',

If(FlgtHour>10 and FlgtHour<=16,'2nd Wave', 'Final Wave'))

If I don't have the 'and' keyword in the second expression it works - as soon as I incorporate the 'and' it fails.

Does the 'and' not work when creating a calculated filed in Data Manager?

Its driving me ....

Thanks

Re: Nested if with And issue

sunny_talwar — Wed, 27 Dec 2017 16:39:11 GMT

I would think it should... but you can just do this

If(FlgtHour<=10,'1st Wave',

If(FlgtHour<=16,'2nd Wave', 'Final Wave'))

Because if FlgtHour is less than 10, it will just get picked in 1st Wave, you don't really need to add the first part of the condition

Re: Nested if with And issue

avermalla — Wed, 27 Dec 2017 16:54:15 GMT

Hi Sunny

Thanks it did work - however in this case the options were quiet simple - but why is the add not working in Data Upload. It works in all other expressions in the front end its only an issue in 'Data Upload - Calculated field'

Re: Nested if with And issue

sunny_talwar — Wed, 27 Dec 2017 16:56:05 GMT

In the if statement you posted above, I don't see any problem... would you be able to show us the error message?

Re: Nested if with And issue

luismadriz — Thu, 28 Dec 2017 00:17:07 GMT

Hi, I just tried this myself and Arvind is correct, the expression editor when creating a calculated field via Data Manager is limited and very controlled. The interface is a bit different to the expression editors we have in Qlik Sense. I tested it on the Cloud so it's the latest version

Whenever I tried to do something simple like IF(C>10 OR C<5,'Yes','No') the expression just didn't work and the ANDs or ORs weren't recognised.

Strange...

Luis

Re: Nested if with And issue

sunny_talwar — Thu, 28 Dec 2017 00:28:17 GMT

I was not aware of this new place where you can add this if statement

Re: Nested if with And issue

Bisanta — Mon, 04 May 2020 15:41:47 GMT

Hey, Just wondering if there has been any fix for this. It will be nice to have the AND/OR enabled with conditional IF when creating a calculated field. Sometimes, conditions to derive a new field could be tricky.