topic Re: Need partial sum data in other table to be displayed in QlikView

Need partial sum data in other table to be displayed

Mon, 19 May 2014 15:48:29 GMT

Hi,

I need to display the partial sum data in different table. How do I do this?

Re: Need partial sum data in other table to be displayed

hic — Mon, 19 May 2014 15:54:09 GMT

You cannot easily fetch a partial sum from a chart and use that somewhere else. Instead you should write the proper expression where you need the partial sum.

To make it partial, use Set Analysis. For example, if you want the partial sum of Sales for United Kingdom, then write

Sum( {$<Country={'United Kingdom'}>} Sales )

HIC

Re: Need partial sum data in other table to be displayed

preminqlik — Mon, 19 May 2014 15:55:16 GMT

in which table....u can use aggr function and store in variable ...use in other table

Re: Need partial sum data in other table to be displayed

Tue, 20 May 2014 18:34:58 GMT

Thank you everyone. I edited the script and it worked