Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Column Row relation in QV

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?

3 Replies
dennisnet
Valued Contributor III

Re: Column Row relation in QV

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.

Not applicable

Column Row relation in QV

Dear Dennis,

unfortunatly this didnt help!

regards,

Moreed

dennisnet
Valued Contributor III

Re: Column Row relation in QV

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.