topic Re: Flag use in different field in QlikView

Flag use in different field

everest226 — Tue, 31 Jul 2018 14:29:16 GMT

LOAD

[Affiliate Number],

[White Flag], ----- this has only "Yes" and "NO" Value

Counter,

if([White Flag] = 'Yes' and [Res Status] = 'Live', 'Live',

if([White Flag] = 'No' and [Res Status] = 'Live', 'O', 'Cancelled')) as mattla,

From,,,,,,,

the logic is

IF the res status is live and white flag is yes then the res status value should be conformed, if the res status is live and white flag is no than its a 0 ELSE CANCELLED .

------WHEN I VALIDATE THE DATA Cancelled' MATCHES BUT 'O" AND LIVE DOSENT MATCH , I DONT SEE ANY PROBLEM WITH MY LOGIC .

if([White Flag] = 'Yes' and [Res Status] = 'Live', 'Live',

if([White Flag] = 'No' and [Res Status] = 'Live', 'O', 'Cancelled')) as mattla,

Re: Flag use in different field

sunny_talwar — Tue, 31 Jul 2018 14:33:59 GMT

QlikView and Qlik Sense differentiate between YES and Yes and yes.... I say this because you mentioned Yes and NO... NO was all upper case, but Yes was not... make sure you use the correct casing.

Also, make sure that you don't have extra spaces before and after your values... if you do... then may be check using If(Trim([White Flag]) = 'Yes'.... and so on

Re: Flag use in different field

everest226 — Tue, 31 Jul 2018 14:37:52 GMT

My bad

Yes and No both lower case , where should i implement trim statement , would be helpful

if([White Flag] = 'Yes' and [Res Status] = 'Live', 'Live',

if([White Flag] = 'No' and [Res Status] = 'Live', 'O', 'Cancelled')) as mattla,

Re: Flag use in different field

sunny_talwar — Tue, 31 Jul 2018 14:39:45 GMT

Around your field names

Re: Flag use in different field

everest226 — Tue, 31 Jul 2018 14:46:18 GMT

dont think its value issue , getting same result after Trim also . but thank you.

Re: Flag use in different field

sunny_talwar — Tue, 31 Jul 2018 14:54:56 GMT

Don't see anything wrong with your script... but may be if you can share a sample... we might be able to help better

Re: Flag use in different field

vishsaggi — Tue, 31 Jul 2018 15:06:13 GMT

Can you show the values in your [White Flag]?

Re: Flag use in different field

everest226 — Tue, 31 Jul 2018 15:10:38 GMT

Re: Flag use in different field

everest226 — Tue, 31 Jul 2018 20:56:26 GMT

Thanks Sunny , it worked - you always been helpful.

Re: Flag use in different field

sunny_talwar — Tue, 31 Jul 2018 21:22:16 GMT

What exactly worked? What was the issue? Can you provide the details for future visitors