Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Data model assistance

Hi all, I have a data model where i have following conditions; - Sales Data File     - Customer # Level 1     - Customer # Level 2     - Net Sales     - Sales Channel - Customer Classification File     - Customer #     - Class of Trade So two columns in sales data file that im trying to reference same column in an index file - because the data is mixed in the index file. In addition i need to look up class of trade dependent on the sales channel. I need to select following sequence: 1) If Class of trade = "Other" it needs to look up "Class of Trade" from "Customer # Level 2" column and 2) If Sales Channel = "Direct" it needs to look up "Class of trade" dependent on "Customer Level 1", 3) Otherwise look up "Class of trade" from "Customer Level 2" I've tried to solve it by duplicating the index file in the load editor and named Customer # differently - it works but it selects too many rows, so you need to delete those afterwards. Does anyone have a good (more pretty) solution for this? Best, Simon

1 Reply
Contributor II
Contributor II

Attached are samples of the files im trying to connect