topic Re: Column Row relation in QV in QlikView

Column Row relation in QV

Thu, 13 Oct 2011 09:43:46 GMT

Dear All,

We have 2 sheets "Input1" and "Input2" what is needed here is to create a dashboard that represents the "Output" Sheet.

The "output" sheet is a combination of some values from "Input1" and "Input2" sheets.

In the "Output" sheet - in the first row there are codes that represent codes in the "column Code" in "Input1" sheet.

For example:

Val4, Val5 and Val6 in "Output" sheet are connected with the codes in the "Input1" sheet that match with the same numbers in row 1 in "output" Sheet.

Please note that the "output" sheet wont be loaded into QlikView!

How can we connect the "input1" and "input2" sheets to create the "Output" sheet?

Re: Column Row relation in QV

Anonymous — Thu, 13 Oct 2011 10:12:11 GMT

Does this help:

Input:
LOAD 
   RecNo() as Key, 
          Dim1, 
     Code, 
     Val1
FROM
Example1.xlsx
(ooxml, embedded labels, table is Input1);
Input2:
Load 
          RecNo() as Key, 
          Dim2, 
     Val2
FROM
Example1.xlsx
(ooxml, embedded labels, table is Input2);

This way the information in the different sheets are connected based on the row number.

Column Row relation in QV

Thu, 13 Oct 2011 12:58:18 GMT

Dear Dennis,

unfortunatly this didnt help!

regards,

Moreed

Re: Column Row relation in QV

Anonymous — Fri, 14 Oct 2011 10:11:16 GMT

Hi Moreed,

It doesn't make sence to me because the values (the calculations are different for the codes.

But maybe you can start with this:

Input:
LOAD 
          Dim1, 
     Code, 
     Val1
FROM
Example1.xlsx
(ooxml, embedded labels, table is Input1);
//Input2:
Join (Input)
Load 
          Dim2, 
     Val2
FROM
Example1.xlsx
(ooxml, embedded labels, table is Input2);
Input2:
Load * ,
((Val1) * (Val2)) as Val4
Resident Input;
Drop table Input;

Like I said it doesn't make sence to me.

Maybe I can help you better is you can explain what it is you are trying to do. What your data is.