Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

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 



and vmaxmonth is



how I show '-' instead of Nov 2020 ?


1 Reply

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)