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.
What do you get with the suggested expression from my last post?
with below expression I am getting percentages a bit high
=Count(FlagNew) / Count({<FlagNew= {'GONE'}>} TOTAL<Month> FlagNew)
for eg: APP percentage is showing 33% instead of 22%. all GONE percentage is showing 100% (which is not expected).
EDIT : I have modified your expression just to give a try
=Count(FlagNew) / Count({<FlagNew= {'GONE','START'}>} TOTAL<Month> FlagNew)
Amelia D wrote:
I am using the below expression
=Count({<FlagNew= {'START'}>} TOTAL<Month> FlagNew)
/
Count({<FlagNew= {'GONE'}>} TOTAL<Month> FlagNew)
for START %
I am getting expected result when I used above expression. All I need is percentages are showing multiple times for all rows. Instead of the I need START percentage next to START value. GONE percentage next to GONE value, APP percentage next to APP value and so on.
is it possible please let me know.
Using this logic, we can assume GONE % is
=Count({<FlagNew= {'GONE'}>} TOTAL<Month> FlagNew)
/
Count({<FlagNew= {'GONE'}>} TOTAL<Month> FlagNew)
right?
So why do you get 67% then in Oct 2013? You said using
=Count(FlagNew) / Count({<FlagNew= {'GONE'}>} TOTAL<Month> FlagNew)
you get 100% for dimension GONE, but this is what I would expect.
Again, it's very, very annoying that we need to speculate about your setting, please post a sample QVW or at least your current script and a sample of input data.
Hi,
I was out of office. That is data changed in the source. As we have a job set up to run every 4 hours. that makes the difference of showing 67 %. I will make sample data and will post the sample QVW.
Really Sorry! for bothering.