Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Several conditionals on a total count

I have a line chart and I am plotting change in number of actions over several yearsAnalysis.PNG

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)

action.PNG

Could anyone help please?

7 Replies
Specialist
Specialist

Hello, Beatrice!

Try to do the followin:

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

Contributor III
Contributor III

Hi Sergej, thank for your reply.

Unfortunately that doesn't work.

Specialist
Specialist

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

Contributor III
Contributor III

I get  "all expressions disabled"

Specialist
Specialist

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

Contributor III
Contributor III

Hi,

Try

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

Specialist
Specialist

Is this not what you want?