Getting min and max date from Date which is in string format

[loganathan]

Hi all,

Attached the sample data. I wanted to get max period = 2019-06 and min period=2019-01 in KPI. but unable to do this as the period fields is in string format anybody can advise on this.

thanks in advance

[Vegar · Accepted solution]

You can tell Qlik Sense to intepret your period as a date using date#() like this.

Date(Min(date#([period],'YYYY-MM')),'YYYY-MM')

Date(Max(date#([period],'YYYY-MM')),'YYYY-MM')