Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make my LY sTOCK display -1,534,101 ?

Hi All

I have below expression from Ruben , it return -1,534,101 when i click on Blue Button is correct :-

Sum({$<year, month, date={'<=$(=AddMonths(Max(date), -12))'}>}TOTAL Aggr(Sum({<year, month, date={'<=$(=AddMonths(Max(date), -12))'},sTOCK = {'sTOCK'}>}[Amount]), YearMonth))

But when i not select sTOCK field = sTOCK , it return -1,306,777 which is wrong , How to make it display -1,534,101 ? ( when user click organ color button )

Reason in QS my app does not allow me activated  field = sTOCK.

Paul

1 Reply
paulyeo11
Master
Master
Author

my qvw