Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

Selection Erreur date

Hello,
I come to you because I have a concern, qd I browse the application via the portal Accespoint, I have a difference in the date and selects date show (see Exhibit attached) by cons if I have another selection months I have that mistake, an explanation please.
Here are the expressions to display the years n and n-1

MonthName(AddYears(Max([Mois année fichier]),-1))

MonthName( Max([Mois année fichier]))

cordially

Maurice

2 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

In the screenshot the selection it's on "Mois année" not "Mois année fichier"

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

It looks like the association between the date field [Mois année fichier] and its Month/Year field may be incorrect... I'd start from creating a table object with all related calendar fields, and validate the association of dates and the corresponding months.

As always, it would be easier for us to troubleshoot if you could post a small sample with the problem.

Cheers,

Oleg Troyansky

Learn advanced Qlik techniques in my book QlikView Your Business.