topic Row minus Row is it possible if is a calculated value???? in QlikView

Row minus Row is it possible if is a calculated value????

Mon, 05 Mar 2012 19:17:39 GMT

Hi guys, is it possible to get a row minus a row if is a calculated value in a pivote table??? I mean there is a value already but I need to substract the value of other row, any idea??

I attached the app and a power point to explain better myself.

Thank you!!

Row minus Row is it possible if is a calculated value????

Tue, 06 Mar 2012 16:52:35 GMT

Does any body know if this is possible???

Row minus Row is it possible if is a calculated value????

Tue, 06 Mar 2012 17:10:00 GMT

It is possible, but what is the relationship of these rows, it is possible to have these rows (or/and a difference row) in solution.

Currently your requirement is bit unclear...

Regards

Kulbir

Row minus Row is it possible if is a calculated value????

Tue, 06 Mar 2012 17:26:14 GMT

Hi Kulbir, thank you for your response, my customer asked for this request, I know is kind of weird, its just a substraction but i can´t figure it out jet.

what I need is the that the value in Row "CUOTA NOMINA" minus value Row "NOMINA_HRAS" , the value resultant will replace the value in Row "CUOTA NOMINA".

I know is kind of weird but its a customer request.

I hope I explained myself.

Thank you for your time!!