This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
by using of autonumber function i map two fields, original record is near to 320000 when i store in to qvd it duplicated (it has 4.5GB)
I added row no for the show the duplication
i attached sample PFA
Try with DISTINCT
Load DISTINCT FromDate,
View solution in original post
You are probably missing an additional key field with IntervalMatch(), maybe constructed using JobNo and DateFinalStatus:
IntervalMatch (Extended Syntax) ‒ QlikView
Your Tempfact Join is not necessary.in line 20. This creates a table within a table. Like a forced join. and an Interval ID which you mentioned in the TempFact table in the beginning already.