Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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