topic Re: Selection Erreur date in QlikView

Selection Erreur date

MauriceLudo — Thu, 03 Nov 2016 14:57:55 GMT

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

Re: Selection Erreur date

Aurelien_Martinez — Thu, 03 Nov 2016 15:03:16 GMT

Hi,

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

Aurélien

Re: Selection Erreur date

Oleg_Troyansky — Thu, 03 Nov 2016 15:04:00 GMT

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.