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 🙂
