Can only see the Totals

[#1]

Hello,

please look att attached app. I would like to have it as in the Picture. Do I need to

create a key or something.. I got stuck on this.

kindly

Håkan

[Oleg_Troyansky]

Håkan,

the problem is hiding in your data - the data rows where ProdH is populated, don't have SP and PT calculated, and vice versa. In order to get the result presented in your picture, you need to create associations between ProdH 21, as an example, and CoKod SP or PT.

Perhaps you load your data from a spreadsheet, which has ProdH only populated in the first row? Then you need to use the Transformation wizard to "Fill" the missing values.

Otherwise, you need to explain the logic of your data, and one of us can suggest a better solution.

best,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

[#3]

Hello,

the data is from a text file and is like the table to the right. Is it possible to use the order number to

create some key?

Håkan

[Oleg_Troyansky]

I don't fully understand the logic of your data, but I think you can load the order lines ending with 5 separately from the order lines ending with 0, and then join the first table into the second table based on the Order Number and the line number (getting rid of the 5 in the process)

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.