topic Variable using aggr in QlikView

Variable using aggr

Mon, 23 Jan 2012 16:14:55 GMT

Dear all,

I'm looking for a substitute for an aggregation I'm using alot in my graphs: sum(aggr(column_to_be_summed,aggregation1,aggregation1,aggregation2,aggregation3)). Due to the design of my link table I cannot go arround aggregating before I do the sum.

Is there a way I can replace this with for example a variable?

I want to make it my users as easy as possible to create their own graphs.

Thanks!

Variable using aggr

forte — Mon, 23 Jan 2012 16:26:14 GMT

Hi bluemtms :

Just create a variable named , in example, vMyExp and give it this value :

sum(aggr(column_to_be_summed,aggregation1,aggregation1,aggregation2,aggregation3))

, be sure to not use equal at the begining. Each time you need to use it write $(vMyExp) instead of that sum.

Hope it helps

Regards

Variable using aggr

Mon, 23 Jan 2012 18:31:17 GMT

Thanks, I tried this already but failed because I didn't use the sum of the aggr(). I thought I could just store the aggr() in a variable.

This is so easy

Variable using aggr

Mon, 23 Jan 2012 22:38:18 GMT

Is there somewhere a good reference for working with variables? I don't really understand the difference between LET and SET and the myvar='=expression'...

The reference guide is not really helpful in that aspect