Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help

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

3 Replies
Not applicable
Author

A.) count({<[Migration Status] -= {'Complete'}>} [Server Name])
B.) count({<[Migration Status] = {'Build','Analyze','Test'}>} [Server Name])

atafsson
Creator
Creator

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

Not applicable
Author

Many thanks for this! it's much appreciated!