Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Did you name your Flag as Flag or NewFlag?
Or even FlagNew
Or FlagNew
Thanks swuehl
I have used FlagNew. this is the one I used in the script.
Then try this expression
=Count({<FlagNew= {'START'}>} FlagNew)/Count{<FlagNew= {'GONE'}>} FlagNew)
did try earlier. showing same 0%
Would you be able to create a list box for FlagNew and see if you see any values getting populated or its all empty?
yes. in the list I can able to see below
START
GONE
APP
PROCESS
CON
SUCCESS
Do you see something when you use this expression alone =Count({<FlagNew= {'START'}>} FlagNew)
yes. expression alone is working
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%')