Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arusanah
Contributor

help setting default date for qliksense app

I have a field as MonthYear which have values as " JAN-2016 , Feb-2016 , and so on."

i am trying to show my trend line chart for last 12mths only.

i am creating a variable as

but its not working

if(gertselectedcount(MonthYear)=0, MonthYear= addmonths(date(MonthYear),'MM-DD-YYYY')-12),max(MonthYear)), but its not working .

ANy suggestions or help is highly appreciated.

The said filed was created in script by concatenating Month & Year