Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
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