topic Re: Help in QlikView

Help

Tue, 14 Jan 2014 15:41:17 GMT

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

Tue, 14 Jan 2014 15:44:22 GMT

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

atafsson — Tue, 14 Jan 2014 15:48:31 GMT

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])

Count({$<[Migration Status]-={'Complete'}>} [Server Name])

Best Regards

Axel

Tue, 14 Jan 2014 16:03:31 GMT

Many thanks for this! it's much appreciated!