Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel174102
Creator
Creator

Get rid of some data in a bar chart

Hello everyone.

I have the following graph. Which contains date from previous year that I do not need (2015 and 2016).

How could i get ride of them?

the date column ist "Posting Date".

 

Cheers

Labels (1)
1 Solution

Accepted Solutions
Nicole-Smith

You can add set analysis to your count to ignore those year values.  It would looks something like this:
COUNT({<[Year Field]-={2015, 2016}>} [Account No_])

View solution in original post

2 Replies
Nicole-Smith

You can add set analysis to your count to ignore those year values.  It would looks something like this:
COUNT({<[Year Field]-={2015, 2016}>} [Account No_])

Manuel174102
Creator
Creator
Author

thanks, it worked!