Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
maxronny
Contributor III
Contributor III

contat function

dear all,

i am warried about a problem i can't get a solution. i tried to resolve it with "contact" formula but it doesn't run.

please see the qvw attached.

my goal is to get a result in which, for example, if i select "aaa" i have this issue:

dateamountsupplierselect1select2
01/01/2020100bingaaa 
05/05/2020160bing aaa
30/05/2020172bang aaa
24/06/2020184bung aaa
19/07/2020196bongaaa 
13/08/2020208bengaaa 
16/12/2020268beng aaa
01/03/2021304bungaaa 

 

hoping to find someone who can help me.

thank U.

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

You could create a cross-reference table in the load script:

tmpSelect:
load distinct select1 as tmpSelect,
select1,
'-' as select2
Resident Data where select1 <> Null();
Concatenate
LOAD Distinct select2 as tmpSelect,
'-' as select1,
select2
Resident Data where select2 <> Null();

 

select1.PNG

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

You could create a cross-reference table in the load script:

tmpSelect:
load distinct select1 as tmpSelect,
select1,
'-' as select2
Resident Data where select1 <> Null();
Concatenate
LOAD Distinct select2 as tmpSelect,
'-' as select1,
select2
Resident Data where select2 <> Null();

 

select1.PNG