topic Re: Re: Display Total Sum(Column) value in all rows in QlikView

Display Total Sum(Column) value in all rows

Thu, 09 Jan 2014 13:34:26 GMT

Hi all,

Please find the attached sample app. And let me know how can i get TOTAL SUM(Column) in all rows in straight table.

Thanks in advance.

Regards,

Venkat

Re: Display Total Sum(Column) value in all rows

maxgro — Thu, 09 Jan 2014 16:45:24 GMT

perhaps this?

sum(total aggr(sum(C1) - Above(Sum(C1)), C1))

Re: Re: Display Total Sum(Column) value in all rows

Fri, 10 Jan 2014 09:03:10 GMT

Hi Grossi,

Thanks your solution helps me.

I had one more question how can we get sum value based on aggr. Please find the attached sample app.

Thanks in advance.

Regards,

Venkat

Re: Re: Re: Display Total Sum(Column) value in all rows

maxgro — Fri, 10 Jan 2014 11:28:57 GMT

I added a dimension to your script,

see attachment

Regards

Re: Re: Re: Re: Display Total Sum(Column) value in all rows

Fri, 10 Jan 2014 12:27:07 GMT

Hi Grossi,

I had done small change to your expression in test app that also worked fine without having of COUNTER column as below :

YOURS : sum(TOTAL <L> aggr((C1) - above((C1)), L,COUNTER))

CHANGED : sum(TOTAL <L> aggr((C1) - above((C1)), L,C1))

I tried changed expression in real data but it is getting different values.

Can you please find the attached sample app of real data and mentioned in text object which values should get for each LOT column.

Thanks in advance.

Regards,

Venkat

Re: Re: Re: Re: Re: Display Total Sum(Column) value in all rows

maxgro — Sun, 12 Jan 2014 12:03:28 GMT

Hi Venkat

starting from your doc, "Sample.qvw I did 2 other docs

"Sample - qvd gen.qvw": reads your Sample.qvw and makes 2 qvd, MainData.qvd and DimLot.qvd

"Sample - final.qvw": reads the 2 previuos qvd; here you can see the result you want

Why?

because it seems to me the ABOVE function in AGGR by LOT and BC_DEV works as expected only if the BC_DEV field is ordered (you can check the load order in listbox); I added the COLCHECK column in "Sample.qvw" and "Sample - final.qvw" to verify this.

To get the expected result you need to be sure the BC_DEV field is ordered (asc) in your qvw.

See this post for order in aggr

http://community.qlik.com/message/287297#287297

Massimo