Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

How to show minimum month without showing minimum value of that month

Hello

I have 2 toggle buttons 1) I want to show ALL values for the minimum month and

                                  2) I want to show all values for the next month

However, my code at the moment is only showing the minimum date in that first month, I.e. If April 2013 is the minimum month, then my code is returning all data for 02/04/2013 however, I want my code to bring back all values for 02/04/2013 - 04/2013

Here is my current code

Current Month = Min(breach_test)

Next Month = =AddMonths(Min(breach_test)+1,+1)

I have 3 months in this format 04-2013, 05-2013, 06-2013 and the information behind this format is an actual date

(hence why I am probably only returning the miinimum date, not the minimum month)

Can anyone help me return all the dates in the minimum month?

Thanks

Helen

0 Replies