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: 
capriconuser
Creator
Creator

max date in qlikview

I have dates 

Dec 2020, Jan 2021, Feb 2021 till Nov 2021

when i select Dec2020.. then in text object date should be displayed as '-' instead of Nov 2020...

when I select date Dec 2020 text object display Nov 2020.. 

i try this 

=MonthName(vMaxMonth-1)

 

and vmaxmonth is

=(MonthName(max((Date_Email))))

 

how I show '-' instead of Nov 2020 ?

 

1 Reply
Anil_Babu_Samineni

Perhaps this?

If(GetSelectedCount(Date_Email)>0, MonthName(vMaxMonth-1), '-')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful