topic Re: Help with pivot table & range sum/avg in QlikView

Help with pivot table & range sum/avg

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have data like shown below

Want to show result in Pivot table like shown image below:

Remaining column shows Oqty-Rqty

Received shows Recdate-Orderdate (its total is avg)

I have attached sample qvw for your suggestions.

Could you please help me to achieve this in qlikview?

Thanks you in advance.

Re: Help with pivot table & range sum/avg

devarasu07 — Mon, 16 Oct 2017 07:41:10 GMT

Hi,

Refer to the attachment,

Re: Help with pivot table & range sum/avg

Anonymous — Mon, 16 Oct 2017 07:55:00 GMT

Hi Devarasu,

Thank you for your reply, however i think your attachment is for diff question.

Also, in image remaining qty is not showing desired output its showing total 230 qty is remaining for 42 ordered qty.

Again thanks for trying to help.

Re: Help with pivot table & range sum/avg

qliksus — Mon, 16 Oct 2017 09:16:43 GMT

How did you get the total as 17.22 for the remaining column ?

Re: Help with pivot table & range sum/avg

Anonymous — Mon, 16 Oct 2017 09:35:28 GMT

thanks for your reply,

That i have calculated in excel , its just order qty-sum(received qty).

Is their any way by which we can achieve this in qlikview ?

kindly provide suggestions.

Thanks,

Re: Help with pivot table & range sum/avg

Frank_Hartmann — Mon, 16 Oct 2017 09:37:48 GMT

see attached file

hope this helps

Re: Help with pivot table & range sum/avg

PrashantSangle — Mon, 16 Oct 2017 09:40:23 GMT

Hi,

Please find attachement.

Regards,

Re: Help with pivot table & range sum/avg

Frank_Hartmann — Mon, 16 Oct 2017 09:58:23 GMT

or maybe like attached, including total values:

hope this helps

Re: Help with pivot table & range sum/avg

Anonymous — Mon, 16 Oct 2017 10:20:22 GMT

Hi Prashant & Frank,

Thank you so much for your help!! Both of yours solution are correct & suffice to my requirement.

However I can mark only one correct Ans, what to do

Re: Help with pivot table & range sum/avg

Frank_Hartmann — Mon, 16 Oct 2017 10:23:12 GMT

your choice 🙂

Re: Help with pivot table & range sum/avg

pradosh_thakur — Mon, 16 Oct 2017 10:24:12 GMT

hopefully this is what you are looking for.

regards

Pradosh

Re: Help with pivot table & range sum/avg

Anonymous — Mon, 16 Oct 2017 10:41:03 GMT

Thank you Pradosh, Prashant & Frank.