Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Dimension Help

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
Community Browser