Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to QV writing and have the below expression which works fine:
Count(if([Migration Status]='Engaged',[Server Name]))
The options I have to chose from in the 'Migration Status' column include:
Analyze |
Engaged |
Test |
Scheduled |
Build |
Complete |
a) How would I write a statement to count everything which IS NOT 'Complete'?
b) How would I write a statement for the total count of 3 of the 6 (e.g. Build + Analyze + Test)?
Thanks for any help!
Rob
A.) count({<[Migration Status] -= {'Complete'}>} [Server Name])
B.) count({<[Migration Status] = {'Build','Analyze','Test'}>} [Server Name])
Hi Rob,
For this calculation you can use SET-analysis.
I would write the expression like this:
Count( {$<[Migration Status]={'Engaged'}>} [Server Name])
From this it's simple to add more statements (Answer on question b). It would look like this:
Count({$<[Migration Status]={'Build', 'Analyze', 'Test'}>} [Server Name])
Question A:
Count({$<[Migration Status]={'*'}-{'Complete'}>} [Server Name])
OR
Count({$<[Migration Status]-={'Complete'}>} [Server Name])
Best Regards
Axel
Many thanks for this! it's much appreciated!