Create a table from an existing

Tue, 20 Sep 2011 12:45:41 GMT

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

Create a table from an existing

Tue, 20 Sep 2011 14:07:47 GMT

Hello all,

this is ment as an question, not an discussion.

Håkan

topic Create a table from an existing in QlikView

Create a table from an existing

Create a table from an existing