if condition

Mon, 03 Jul 2017 09:27:44 GMT

Hi all,

I have a if statement

if(NO ='P10'and value >2,'Yes','No')

and then I need to take this variable and use further. if i'm counting yes values its showing right count but when i'm counting both yes no values it is showing wrong value , could you please suggest something

Re: if condition

Anil_Babu_Samineni — Mon, 03 Jul 2017 15:59:55 GMT

Because, This condition filled with either Yes nor No. You must clear about that where and what you are doing. I am assuming you created one flag for Yes and No field.

For Yes and No below one, This will deserve with accuracy count

Count({<YesNoFlag = {Yes}>}Sales)

Count({<YesNoFlag = {No}>}Sales)

For Yes and No count you can do something like below

Count({<YesNoFlag = {'Yes', 'No'}>}Sales)

topic if condition in QlikView

if condition

Re: if condition