Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi All
Enclosed my QVW.
Hi All
I have try to create a brand new QVW , and copy GL Table load script and Sales order load script . And notice that now June 2019 data is able to appear on the table. I am not sure where go wrong ? Does any one can give me some idea how to find out where is the issue ? As I know this issue will happen again.
Paul
Add +0.01 in your expressions and see result
Hi Sir
i think the formula can not have any issue .
Yes I agree that the model have issue , that why I started new QVW , the June sales appear. But not sure where it go wrong. As now not happen yet.
Paul
To analyze the problem, I suggest that you first make a table with a dimension (Year-Month) and an expression (calculation of ...) to see if what you get is expected value