Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Create a table from an existing

This is a problem I have struggled with the last time, I belive

that you guys have a clever solution.

table1:

Load Ordernumber
resident Orders
where Pos='300';


the table Orders looks like this

Name  Ordernumber      Pos      Pcs
Item1  100                      100       1
Item4  100                      105       1
Item5  100                      106       1
Item1  100                      200       1
Item4  100                      205       1
Item5  100                      206       1
Item2  100                      300       1
Item1  200                      100       1
Item4  200                      105       1
Item5  200                      106       1
Item1  200                      200       1
Item4  200                      205       1
Item5  200                      206       1
Item2  200                      300       1

Item1  300                      100       1

Item1  300                      200       1

Then I will search in table Orders with Ordernumber from table1 to
get this result


Name  Ordernumber      Pos      Pcs


Item 1         100            100       1
Item 1         100            200       1
Item 2         100            300       1
Item 1         200            100       1
Item 1         200            200       1
Item 2         200            300       1
Item 1         300            100       1
Item 1         300            200       1
Item 2         300            300       1


  To be able to create this Diagram

Diagram

Ordernumber      Item       Item       Pcs Item2      Pcs Item1
100                   Item2      Item1           1                2
200                   Item2      Item1           1                2
300                   Item2       Item1          1                2

kindly

Håkan

1 Reply
Not applicable

Create a table from an existing

Hello all,

this is ment as an question, not an discussion.

Håkan

Community Browser