topic Re: Help with Syntax for COUNT with two dimension requirements in QlikView

Help with Syntax for COUNT with two dimension requirements

data_RN — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am hoping I have an easy one for you 🙂

I am trying to get the count for the number of programs with an advanced business case that is in a stage of either seed, alpha OR beta and I am having a hard time with the syntax. I can get it to count using just one stage, but I cannot figure out how to include the others.

Here is what I have:

Count({<[Program Name] = {"=[Business Case Model] = 'Advanced' and [Current Stage]= 'Seed'"}>} [Program Name])

I would like something like this:

Count({<[Program Name] = {"=[Business Case Model] = 'Advanced' and [Current Stage]= 'Seed' OR [Current Stage]= 'Alpha' OR [Current Stage]= 'Beta'"}>} [Program Name])

I could also use the negative form:

Count({<[Program Name] = {"=[Business Case Model] = 'Advanced' and [Current Stage]<> 'Initial' OR 'Pre-Seed'"}>} [Program Name])

Any help is appreciated...thanks!

Re: Help with Syntax for COUNT with two dimension requirements

Anil_Babu_Samineni — Tue, 23 Apr 2019 12:19:29 GMT

Perhaps this?

Count(If(([Business Case Model]='Advanced' and [Current Stage] = 'Seed') or ([Current Stage]='Alpha' or [Current Stage]='Beta'), [Program Name]))

Re: Help with Syntax for COUNT with two dimension requirements

jonathandienst — Tue, 23 Apr 2019 12:29:33 GMT

You may be over complicating the problem. Try this:

Count({<[Business Case Model] = {'Advanced'}, [Current Stage]= {'Seed', 'Alpha', 'Beta'}>} [Program Name])

Re: Help with Syntax for COUNT with two dimension requirements

Anil_Babu_Samineni — Tue, 23 Apr 2019 12:32:15 GMT

@jonathandienst or I can think this way, As they are performing "Or" operator 🙂

Count({<[Business Case Model] = {'Advanced'}>+<[Current Stage]= {'Seed', 'Alpha', 'Beta'}>} [Program Name])

Re: Help with Syntax for COUNT with two dimension requirements

jonathandienst — Tue, 23 Apr 2019 12:50:47 GMT

[Current Stage]= {'Seed', 'Alpha', 'Beta'}

is equivalent to Seed or Alpha or Beta...

Re: Help with Syntax for COUNT with two dimension requirements

data_RN — Tue, 23 Apr 2019 13:33:12 GMT

This works! I knew I was making it overly complicated.

Thank you for your quick reply!

Cheers!

Re: Help with Syntax for COUNT with two dimension requirements

data_RN — Tue, 23 Apr 2019 13:36:29 GMT

Thank you for this! I needed a sum of meeting both criteria, but I need this very thing in a different section and will definitely add it to my notes.

Thanks again for your speedy response!