Skip to main content Resources | Qlik Greenway
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Qlik Community

Ask a Question

Connectivity & Data Prep

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator
‎2021-01-21 06:06 AM

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 ?

 

82 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2021-01-21 01:48 PM

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)
56 Views
0 Likes