Script run on one QFV but unable run on another QVF

[paulyeo11]

Hi All

I face a very funny issue. That is I have create a new QVF , and this new QVF is read the same QVW file.

my existing QVF can display all my script from QVW. 

But my new QVF unable display some of the  expression . 

Paul Yeo

[Vegar]

Oh I didn't  see your last post before posting my previous answer.

I'll check out your files and come back to you.

Best regards 

Vegar

[Vegar · Accepted solution]

I've looked at your apps, and it is really strange. I did some investigation and it seems like it is the  sales modifier inside the month modifier that is the issue. 

=num(Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/1/1000, SOURCE)))

There been some back an forth with set modifiers and single and double quotes during the past couple of releases. And as of june 2019 are handeling apps created in earlier releases with their set analysis syntax rules and apps created in june 2019 with june logic. Read more here KPI's are not displaying data after app is imported into a new environment without data and Set Analysis not working as expected using single quotes in Qlik Sense. 

Can you cconfirm that the first application is created in an earlier release than the release you are working on at the moment?

You can try to change the expression to this:

=num(Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {[*]}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/1/1000, SOURCE)))

[paulyeo11]

Hi Sir

Thank you very much , you have spot the key issue. Now is working fine.

You are right , my old QVF is the 2018 ver , and my new QVF 2019 ver. 

 Appreciate very much. 

Paul Yeo

[Vegar]

This is great to hear. I'm glad we could work out this issue.