Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Range of value /Interval syn key issue

I have table data

Docu:
LOAD
DocumentNo as Docu_LOW,
DocumentType,
Amount,
DocumentDate
resident test1;

Temp:
LOAD num#(Docu_LOW) as Docu_LOW, num#(DocuHIGH) as DocuHIGH, Cat INLINE [
Docu_LOW, DocuHIGH, DocumentCat
0022108080, 0022108080, 1
0022102080, 0022102080, 1
0022106080, 0022106080, 1
0028300000, 0028309999, 1
0080910100, 0080911600, 2
0080912100, 0080913000, 3
0080990100, 0080990199, 3
0022108021, 0022108022, 4

];

I tired with Interval -it is multiplying records and Sync key is generating. Is their any way to avoid Syn Key.

The problem is if I have documents

0080910100 and 0080911600 - it has to update the Cat 2.

currently it is ignoring the value 0080911600 because of the join of the field Docu_LOW.

Is their any better way to join Range of values Docu_LOW , DocuHIGH into one field in the DocumentNo
field in the Docu table.

Advance Thanks for your help.

0 Replies