Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
paulyeo11
Master
Master
Author

Enclosed my QV Doc

paulyeo11
Master
Master
Author

Any one can help me ?