Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimension Help

I want to group some dates in a dimension using the below expression:

if([New/Existing]>MaxString({<Date=,Month=,Year=,MonthYear=,PeriodNum={"$(=Max(PeriodNum))"}>}[MonthYear])-12,'Yes','No')

the dates I am using are :

I want to attach values to the yes or no grouping based on the formula above, so when I change date the formula is dynamically changing.

The expression above returns an invalid dimension, can anyone help me

1 Reply
Gysbert_Wassenaar

Try using Max instead of MaxString. MaxString works on text values. Subtracting 12 from a text string won't give a result.


talk is cheap, supply exceeds demand