topic Re: Add a summary column in QlikView

Add a summary column

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I created a PivotChart that gives me the numbers of purchase order and products ordered, in column months and under each month the quantities ordered and quantities delivered, how I can add a column that calculates the remainder (sum quan ordered - sum quantity delivered ) But this column of remaining should not be repeated every month but rather a single column at the end of the table

thank you

Month		janv-16		févr-16		remaining
N° PO	Product	quantity ordered	quantity delivered	Quantity ordered	quantity delivered	remaining
1	A	200	100	200	0	300
2	B	200	50	0	50	100
3	A	200	50	200	50	300
3	B	200	0	0	50	150

Ce message a été modifié par : Zoubir Bouchenafa

Re: Add a summary column

bgerchikov — Thu, 08 Dec 2016 17:15:49 GMT

Try Calculated Dimension:

It will give one single coulmn.

=Aggr(rangesum(sum (Amount ordered) , - sum(quantity delivered),Produit,MonthYear)

Re: Add a summary column

Thu, 08 Dec 2016 20:18:11 GMT

‌=Aggr(rangesum(Sum(quantits ordered)-Sum(quantity delivered),Producit,Month)). It always gives me Error in expression

tthank you for your help

Re: Add a summary column

bgerchikov — Thu, 08 Dec 2016 20:45:22 GMT

Check syntaxis:

=Aggr(rangesum(

(quantits ordered)

-1*(quantity delivered)

)

,Producit,Month)

Re: Add a summary column

Thu, 08 Dec 2016 20:53:49 GMT

‌it calculates but for each month

Re: Add a summary column

bgerchikov — Thu, 08 Dec 2016 21:04:28 GMT

Try to add if condition and / or disregard nulls in the chart

Re: Add a summary column

Thu, 08 Dec 2016 21:14:26 GMT

‌I'm still beginner on Qlikview , can you explain more plz

Re: Add a summary column

bgerchikov — Thu, 08 Dec 2016 21:25:33 GMT

Check this box in Dimension Tab

Re: Add a summary column

Thu, 08 Dec 2016 22:55:21 GMT

‌but value is not null so it will not be supressed

Re: Add a summary column

volakakis — Fri, 09 Dec 2016 00:02:11 GMT

Maybe try another approach since your data is in columns not in rows . Try a cross table? (sorry myself am a newbie but my instructor said that the best way is to keep data in rows not columns)

Re: Add a summary column

bgerchikov — Fri, 09 Dec 2016 20:44:10 GMT

Try to put Aggr expression in IF statement

Re: Add a summary column

Fri, 09 Dec 2016 21:09:41 GMT

‌resolved, by creating a calculated demension =aggr(sum ordered - sum delivered ),n po, product) and place the demension after product culom

thank you