Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Dear Dennis,
unfortunatly this didnt help!
regards,
Moreed
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.