Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make 2017 (YTD Exp) display amount = $324 ?

Hi All

When i add below script , for reduce the data :-

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4;

DROP TABLES sales;

Below expression display null value :-

money(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}Exp/$(Columndim89)/1000)

, $(vMoneyFormatK))

Hope some one can advise me how to make it work.

Paul Yeo

3 Replies
paulyeo11
Master
Master
Author

My QVW

devarasu07
Master II
Master II

Hi

The expression seems correct but there no value available Measure field as "Exp" check below screen those fields shows as blank. check your BRD and update your measure accordingly. tks


Capture.JPG

Regards,

Deva

paulyeo11
Master
Master
Author

Hi Deva

Enclosed is the working copy , which i does not run the below script :-

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4;

DROP TABLES sales;

Notice that it return correct value.

So it is the Year_n field create the issue.

Paul Yeo