Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Links in Qlikview - Hash Key??

I have to use 2011 and 2012 data. The fields in the file are BUYER, SMIC, DIVISION, but I ONLY want to use SMIC,DIVISION.

So, for example in my file:

Year,Buyer,Smic,Division,Amt$

2011,08,4,24,1000

2011,08,4,27,200

2011,12,4,27,300

2012,08,4,27,300

If I select Buyer 08 today (it is 2012), I will get 200(#2) and 300(#3) for 2011 values, and not 1000 (#1). And, 300 (#4) for 2012 data.

The Buyer Code (08 or 12) is irrelevant.  Is this solved by a HASH(SMIC,DIVISION) key?

If I select Buyer=08 on my Dashboard, how can I get the correct records of 200,300,and 1000?

Thank you.

0 Replies