'Dual' not working?please help

[#1]

Hi,

I have below script in qvw. when I reload I can able to see in Flag column only START and GONE. Remaining are not loading into Flag column. Please can anyone suggest me is there any wrong in below script?

If (MixMatch(NAME,'XX',

'YY',

'ZZ',

'AA',

'BB',

'CC',

'DD',

'EE',

'FF',

'GG',

'HH',

'II',

'JJ',

'KK',

'LL',

'MM',

'NN',

'OO',

'PP',

'QQ,

'RR',

'SS',

'TT',

'UU',

'VV',

'WW'),Dual('START',1),

     If(MixMatch(NAME,'GONE'),Dual('GONE',2),

If(MixMatch(NAME,'QQ,

'RR',

'SS',

'TT',

'UU'),Dual('APP',3)

     If(MixMatch(NAME,'XX',

'YY',

'ZZ',

'AA',

'BB',

'CC',

'DD',

'EE',

'FF',

'GG',

'HH',

'II',

'JJ',

'KK',

'LL',

'MM',

'NN',

'OO',

'PP',

'VV',

'WW'),Dual('PROCESS',4),

     If(MixMatch(NAME,

'YY',

'ZZ',

'AA',

'BB',

'CC',

'DD',

'EE',

'FF',

'GG',

'HH',

'II',

'JJ',

'KK',

'LL',

'MM',

'NN',

'OO',

'PP',

'QQ),Dual('CON',5))))))                         as Flag

Thanks.

[swuehl]

Did you name your Flag as Flag or NewFlag?

Or even FlagNew

[sunny_talwar]

Or FlagNew

Thanks swuehl‌

[#4]

I have used FlagNew. this is the one I used in the script.

[sunny_talwar]

Then try this expression

=Count({<FlagNew= {'START'}>} FlagNew)/Count{<FlagNew= {'GONE'}>} FlagNew)

[#6]

did try earlier. showing same 0%

[sunny_talwar]

Would you be able to create a list box for FlagNew and see if you see any values getting populated or its all empty?

[#8]

yes. in the list I can able to see below

START

GONE

APP

PROCESS

CON

SUCCESS

[sunny_talwar]

Do you see something when you use this expression alone =Count({<FlagNew= {'START'}>} FlagNew)

[#10]

yes. expression alone is working

[sunny_talwar]

I think you might just need the formatting to show the result. Try this:

=Num(Count({<FlagNew= {'START'}>} FlagNew)/Count{<FlagNew= {'GONE'}>} FlagNew), '#,##0.00%')