Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
paulyeo11
Valued Contributor III

My monthly stock chart how to make it start from Jan 2013 ?

Hi All

I have a below expression which will plot every month of the stock status.

money(

fabs(rangesum(above(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

     , month = ,year=>}[Amount]/1000/$(ColumnDim98))

,0,rowno()))

)

, $(vMoneyFormatK_GL))

Now i only want it to plot only starting from 2013 Jan.

May i know what should i modify the above script ?

2 Replies
Highlighted
paulyeo11
Valued Contributor III

Re: My monthly stock chart how to make it start from Jan 2013 ?

Enclosed my QV Doc

Highlighted
paulyeo11
Valued Contributor III

Re: My monthly stock chart how to make it start from Jan 2013 ?

Any one can help me ?