topic Re: COUNT with multiple conditions in QlikView

COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 11:22:42 GMT

Hello,

I have the following expression:

COUNT ({$<[Progress]={'Started','On hold','Completed'} , [Current Phase]={'Plan','Execute','Close'}, [Global]={'On Track'} > } [Project NAME])

The COUNT returns 0 instead of 25.

Actually on my table I have multiple rows with:

- only the value 'Started' for 'Progress'

- only the value 'Execute' for 'Current phase'

I think this is the reason.

The first Expression is :

COUNT ({$< [Global]={'On Track'} > } [Project NAME])

Its returning 11.

Thanks in advance for your help.

Re: COUNT with multiple conditions

sunny_talwar — Wed, 04 Apr 2018 11:29:14 GMT

Would you be able to share a sample or sample data to see what you have?

Re: COUNT with multiple conditions

stabben23 — Wed, 04 Apr 2018 11:37:37 GMT

Hi,

why not do a count(Project NAME) and add 3 listbox, Progress, Current Phase, Global, then Select in this listboxs 'Started','On hold','Completed' and 'Plan','Execute','Close' and 'On Track', what will Your Count value be?

Note that Your set analysis is AND not OR, this means that all values must match to Count Your Project NAME.

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 11:41:39 GMT

Your code is ok, can be something in your database.

Have you checked that everything is okay?

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 12:32:04 GMT

Hello Sunny,

Here is a sample:

Thanks

Re: COUNT with multiple conditions

sunny_talwar — Wed, 04 Apr 2018 12:34:59 GMT

So, based on these 5 rows, you should be getting 5 as a count using this

Count({$<[Progress]={'Started','On hold','Completed'} , [Current Phase]={'Plan','Execute','Close'}, [Global]={'On Track'} > } [Project NAME])

Is that not what you are getting? You get 0?

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 12:35:36 GMT

Yes, I need on 'OR' expression. How can I Do it?

I don't want to use listbox because I have many expressions that needs to be calculated automatically.

Re: COUNT with multiple conditions

stabben23 — Wed, 04 Apr 2018 12:45:14 GMT

Of cource you want it automatically, its just a way to troubleshoot. As you show in Your pic above, Your Expression should gives you 5 rows. Do you have any other Expressions in the chart?

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 12:47:04 GMT

yes I get 0. I want to get 5.

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 12:48:06 GMT

Yes, I have other expression that showing 0 also .

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 12:49:30 GMT

Maybe your Current Phase is not a text field, u can try this test?

Count({$<[Progress]={'Started','On hold','Completed'} , [Global]={'On Track'} > }[Project NAME])

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 12:49:44 GMT

Yes no problem in Database and data is well loaded in Qlikview

Re: COUNT with multiple conditions

stabben23 — Wed, 04 Apr 2018 12:58:01 GMT

Ok, then Uncheck "Enable" checkbox and try With only this Expression.

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 13:00:29 GMT

Re: COUNT with multiple conditions

sunny_talwar — Wed, 04 Apr 2018 13:01:48 GMT

I am seeing 5

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 13:14:24 GMT

Now It is working.

I deleted Current Phase column in my Excel file, and created it from scratch!

Re: COUNT with multiple conditions

Anonymous — Wed, 04 Apr 2018 13:14:51 GMT

Now It is working.

I deleted Current Phase column in my Excel file, and created it from scratch!