Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!