Dual function - Issue in a graph

[brunov86]

Hello Qlik community,

I have an issue with a dimension in a graph and dual function.

My measure has the following expression:

Count({<[LocalMember] = {'1'}
,[AsofDate_Month]={$(=(Max(AsofDate_Month])))}
,[AsofDate_Day]={$(=(Max([AsofDate_Day])))}
>} Distinct PersonID)

My graph displays the count for every year.

In my source table, I have

• One field which is a numeric value (AsofDate_Year) YYYY
• One field which is a string value (Membership Year YYYY/YYYY+1). This is the year I want to display.

It seems that as I use a max in my measure, it is causing problem to use the string year.

No issue when I use the numeric year.

So I created a dual in my script with these 2 fields.

Dual(Membership_Year, AsofDate_Year) as Membership_YearFull

When I use it as a dimension, I have blank values fin the graph. 

Any ideas what is causing the issue?

Thanks everyone 🙂