topic Re: Several conditionals on a total count in QlikView

Several conditionals on a total count

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

I have a line chart and I am plotting change in number of actions over several years

Now I want to exclude all actions that do not happen in that year. I did the following but that's not working (please note that Actions isn't the correct field name, I can't put the correct one here, hence the colour being wrong)

Could anyone help please?

Re: Several conditionals on a total count

Sergey_Shuklin — Wed, 24 May 2017 10:58:06 GMT

Hello, Beatrice!

Try to do the followin:

=Count({<Jahr={">2010 <2017"}, Action={">0"}>}Action)

Re: Several conditionals on a total count

shuck1985 — Wed, 24 May 2017 11:13:47 GMT

Hi Sergej, thank for your reply.

Unfortunately that doesn't work.

Re: Several conditionals on a total count

Sergey_Shuklin — Wed, 24 May 2017 11:18:57 GMT

Hm, the expression isn't correct or result is not what you want?

Re: Several conditionals on a total count

shuck1985 — Wed, 24 May 2017 11:46:01 GMT

I get "all expressions disabled"

Re: Several conditionals on a total count

Sergey_Shuklin — Wed, 24 May 2017 11:49:42 GMT

So, if you have a line chart try to use Jahr as Dimension and my offered expression as expression. Should work.

Re: Several conditionals on a total count

hcabrera — Wed, 24 May 2017 14:41:54 GMT

Hi,

Try

count({<Jahr - = {2011,2012,2013,2014,2015,2016}>}Action)

Re: Several conditionals on a total count

Sergey_Shuklin — Wed, 24 May 2017 17:25:07 GMT

Is this not what you want?