topic is it possibile to use aggregate function in text object? in QlikView

is it possibile to use aggregate function in text object?

Fri, 22 May 2015 09:05:25 GMT

Hi ,

I created charts i want to use aggregate funtion in text object is it possible aggregate function use in text object?

pls tell me out this is interview question.help me.

thankyou,

regards

madhu

Re: is it possibile to use aggregate function in text object?

tresB — Fri, 22 May 2015 09:14:41 GMT

Yes.

Re: is it possibile to use aggregate function in text object?

Fri, 22 May 2015 09:16:29 GMT

For use sake or testing , aggregate function can be used on any object.

Aggr() function as making a temporary table.

aggr(expression, dimensions) but we use it mostly in chart to calculated value of an expression over a dimension.

Re: is it possibile to use aggregate function in text object?

sunny_talwar — Fri, 22 May 2015 09:25:22 GMT

Yes it is definitely possible to use the Aggr function, but it needs to be prefixed with another function such as Sum/Max/Min/Only/Concat/Avg.... So something like this would give you a result in a text box:

Sum(Aggr(Sum(Sales), Vendor, Region))

where as this won't work in a text box:

Aggr(Sum(Sales, Vendor, Region)

I hope this will help.

Best,

Sunny

Re: is it possibile to use aggregate function in text object?

Fri, 22 May 2015 09:44:48 GMT

thankyou tresesco. the question actually asked interview person to me .I give answer to that person yes aggr() use in text box

Re: is it possibile to use aggregate function in text object?

tresB — Fri, 22 May 2015 09:51:04 GMT

That's good. Better would be, if you try some practicals on the same and try to grab the concept rather than just being happy with - 'I gave the right answer', because in future you might not just be asked that simple straight forward question in the interview or in the real life projects. So my piece of advice would be to learn it.