topic Straight table - above function to show only one value in QlikView

Straight table - above function to show only one value

Fri, 15 Apr 2011 18:49:15 GMT

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.

Straight table - above function to show only one value

erichshiino — Fri, 15 Apr 2011 19:26:37 GMT

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,

Straight table - above function to show only one value

Fri, 15 Apr 2011 19:38:53 GMT

Thanks Erich Shiino .Great it works now.