topic Using DUAL function to link between sheets do not display correct text in XLS in QlikView

Using DUAL function to link between sheets do not display correct text in XLS

Fri, 21 May 2010 00:13:56 GMT

I have an application where I need to link between sheets using a unique ID but linking to a sheet using a non-unique column.

See sample script below.

Using the Dual function, I'm able to link to another sheet when clicking on a non-unique column. My problem lies when I try to export

the data in Sheet1 to XLS, the column 'Type' is displaying the EmpID instead of the EmpType. Is there a way to have both functionality available - linking from one sheet to another using a unique ID but clicking on a non-unique column and have the XLS download displayed correctly ?

Thanks !

Employee:
LOAD
DUAL(EmpType, EmpID) as Type
, *;

LOAD * INLINE [
EmpID,EmpName,EmpType
10, Andy, Regular
11, Anthony, Regular
12, Bruce, Contractor
13, John, Contractor
];

Salary:
LOAD * INLINE [
EmpID,Salary
10,1000
11,2000
12,3000
13,4000
] ;

Using DUAL function to link between sheets do not display correct text in XLS

Mon, 24 May 2010 06:50:49 GMT

anyone ?

Using DUAL function to link between sheets do not display correct text in XLS

Mon, 24 May 2010 07:15:25 GMT

Hi,

What is the use of dual function in this scenario. This will work without dual function. Your code should be as follows.


Employee:
LOAD
EmpType as Type
, *;
LOAD * INLINE [
EmpID,EmpName,EmpType
10, Andy, Regular
11, Anthony, Regular
12, Bruce, Contractor
13, John, Contractor
];
Salary:
LOAD * INLINE [
EmpID,Salary
10,1000
11,2000
12,3000
13,4000
] ;

-Peterson

Using DUAL function to link between sheets do not display correct text in XLS

Mon, 24 May 2010 07:47:24 GMT

The use of dual is to pass a unique ID to the other sheet. By default, if you select EmpType='Regular' on row 1 (Andy), the result will display 2 rows -- Andy and Anthony. I need to only display Andy and not both. Similarly, if I click on EmpType='Contractor' on row 4 (John), the result should only display John and not both Bruce and John. I hope I explained it clearly now.

Using DUAL function to link between sheets do not display correct text in XLS

Mon, 24 May 2010 09:00:32 GMT

I`m not sure would this help you or not.

Can you create a dummy column like EmpType as Type_Display and use this for exporting and DUAL(EmpType, EmpID) as Type for selection.

-Peterson

Using DUAL function to link between sheets do not display correct text in XLS

Mon, 24 May 2010 14:39:28 GMT

Thanks Peterson. You gave me an idea here which leads me to my next question. Is there a way to display the EmpType in xls only, hiding it from the straight table while the Type need to be displayed in the straight table and hiding it from xls download ?

Using DUAL function to link between sheets do not display correct text in XLS

Tue, 25 May 2010 06:33:37 GMT

Again me to distrub you with one more idea for your question.

You can show the column in qlikview staright table and delete / hide same coulmn in xls using writting macros.

-Peterson