Straight table - above function to show only one value

[#1]

I am showing the data looks like below in the straight table

Document	Order	TextKey	Hours	Total Cost
2301960269	101385973	Electrical	0.00	1,181.25
2301960269	101385973	Electrical	11.25	1,181.25
2301960289	101385973	Repair	2.00	881.25
2301960289	101385973	Repair	7.25	881.25

I am expecting result to show the value like below in the straight table

Document	Order	TextKey	Hours	Total Cost
2301960269	101385973	Electrical	0.00	1,181.25
2301960269	101385973	Electrical	11.25	0.00
2301960289	101385973	Repair	2.00	881.25
2301960289	101385973	Repair	7.25	0.00

If (Document<> above(Document), Sum(Cost)*1,0) - I tried the function.It didn't work.

I have to show one document cost need to show one time only.

Advance thanks for any help.

[erichshiino]

Hi,

I had to include another field to be able to create this straight table. I included an ID, so QlikView would not merge two lines with the same dimension values.

Because there is more than one dimension, I used above(total (... to actually get the value on the previous line.

I guess your cost value comes from a different table, but you get get the above (total) idea to apply in your app.

Hope it helps.

Rgds,

[#3 · Accepted solution]

Thanks Erich Shiino .Great it works now.