Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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