topic Re: Exporting aggr table? in QlikView

Exporting aggr table?

Wed, 14 Jan 2015 01:53:52 GMT

I am attempting to trouble shoot a problem and would like to see the temporary table that my aggr is creating. Is it possible to display or export this?

Re: Exporting aggr table?

morganaaron — Wed, 14 Jan 2015 08:37:06 GMT

Not as far as I know, but it should be achievable by correlating your output from the aggr() statement with a normal table chart containing the same dimensions/expression that you've got in your statement, if that's a possibility?

If you wrap your aggr() statement with a concat() function (and add a delimiter) it should show you what it's output is - then recreate your statement as a table containing your expression and whatever fields you're aggregating over as dimensions?

Re: Exporting aggr table?

giakoum — Wed, 14 Jan 2015 08:42:16 GMT

try putting the expression as an expression in a listbox

Re: Exporting aggr table?

isorinrusu — Wed, 14 Jan 2015 08:48:45 GMT

Following what Aaron says, the following expression,

aggr(sum(Sales),Vendor)

can be viewed in a normal table with dimension Vendor and sum(Sales) as its expression.

You can do more complex things based on this.

Hope it's helpful,

Sorin.