Month of June data missing for all the items , May be is cause by date recode issue ?

[paulyeo11]

Hi All

I am using Qlik View for few year. I have a old QVW file alway return correct result for table report.
which is no issue it can display June amount data.

Recently i create a new QVW. i notice that the June amount is missing.
I mean it just unable to display June amount. When i compute the dimension with YearMonth , the june 2018 and June 2019 missing.

I am using same version of Qlik View Software , and load the same data , also using very similar expression.

Hope some one can share with me where i go wroong ?

Paul Yeo

[ecolomer]

I think the problem is in the model

[paulyeo11 · Accepted solution]

Hi Sir

Thank you very much for your sharing, Now I already found out the problem is cause by the below script :-

autonumber( @1:9T & '_' & 'TDS' ) as ARKey,

This script is the link Key betw Sales Table and AR Table.

Paul