topic Make the differences between two rows fields in QlikView

Make the differences between two rows fields

gamaplast — Sat, 03 Jan 2015 08:50:52 GMT

Hi guys,

I have a straight table with two rows and I'd like to show the differences between the single fields in the row values (amount and percentage).

I seem I can only make the sum in the TOTAL fields and not the differences between them...is there a way to show what I'd like?

Thanks.

Re: Make the differences between two rows fields

engishfaque — Sat, 03 Jan 2015 09:02:31 GMT

Dear Gamaplast,

Kindly find attached document.

Kind regards,

Ishfaque Ahmed

Re: Make the differences between two rows fields

gamaplast — Sat, 03 Jan 2015 09:50:57 GMT

Dear Ahmed,

maybe I wasn't clear enought...I have only two rows and I'd like to have the differences between them.

My attachment explains it better...

Thanks.

Re: Make the differences between two rows fields

engishfaque — Sat, 03 Jan 2015 10:12:16 GMT

Dear Gamaplast,

Kindly find updated attached document.

Kind regards,

Ishfaque Ahmed

Re: Make the differences between two rows fields

gamaplast — Sat, 03 Jan 2015 10:23:10 GMT

Well, actually I'd like to have two extra-rows for the differences and not two extra-columns, because I have multiple voices in the X-axe, so it should be clearer if I should have the table as I posted.

If you'd have a look at the new attachment, maybe you can understand the problem properly.

Thanks.

Re: Make the differences between two rows fields

priyalshah9779 — Sat, 03 Jan 2015 11:00:49 GMT

I have tried to achieve this, let me know if this is what you are looking for

Thanks

Priyal

Re: Make the differences between two rows fields

gamaplast — Sat, 03 Jan 2015 12:56:08 GMT

Great idea, Priyal 🙂

you're a Genius in qw!! 😉

Thak you so much.