topic Re: Converting value into Yes or No in QlikView

Converting value into Yes or No

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

Hi all,

I have a column "Promotion code" in my table , I am creating pivot table, in that I want to see if the customer used a promo code or not ,for that I want to convert my feild value for example under if it is null or - it must say No and if there is promode like New20 then it is Yes. I am not doing this at script level , I am doing this at chart or expression level.

I have used if([Promo Code]=0,'No','Yes') but it seems to give me all Yes for some reason.

Thanks in advance.

Re: Converting value into Yes or No

tresB — Thu, 21 Sep 2017 06:31:05 GMT

May be this?

if( Len(trim([Promo Code]))=0,'No','Yes')

Re: Converting value into Yes or No

Anil_Babu_Samineni — Thu, 21 Sep 2017 06:31:28 GMT

May be you have Nulls instead of 0. Can you check handle the nulls. May be this?

if([Promo Code]=0 or [Promo Code] = 'Null' or [Promo Code] = '-' or IsNull([Promo Code]),'No','Yes')

Re: Converting value into Yes or No

mostwanted123 — Thu, 21 Sep 2017 06:32:31 GMT

Try this,

if(isnull([Promo Code]),'No','Yes')

Regards,

Pratik

Re: Converting value into Yes or No

madhuqliklondon — Thu, 21 Sep 2017 06:46:04 GMT

Thank you all.