Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

$(Columndim89) is affect 2020 result

Hi All

Table 1 expression using below expression working fine :-

money(
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}$(ColumnDim51)/1/1000)
, $(vMoneyFormatK))


Table 2 expression using below expression not working fine :-

money(
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}$(ColumnDim51)/$(Columndim89)/1000)
, $(vMoneyFormatK))

The different between above is :-

$(Columndim89)

When expression with $(Columndim89) , it return wrong for year 2020.

I try but cannot fine where go wrong ? Hope some one can help me.


Paul

2 Replies
paulyeo11
Master
Master
Author

Hi All

Enclosed my QVW.

 

paulyeo11
Master
Master
Author

Hi All

I found the issue , it is due to other table that cause the issue.

Thank 

Paul