topic Aggr formula in QlikView

Aggr formula

Mon, 28 May 2012 07:48:56 GMT

Dear All,

Plz refer to attachment.

I want to find out query % month on month.

e.g. In this example, in 1st column, I want to find Count of "Duplicate" type query. This I got.

In 2nd column, I want total no. of "Duplicate" type query. In 2nd column, against each month, in front of "Duplicate", there should be same no. as 7 (sum of "Duplicate" queries across all months).

I tried with Count and Aggr function as

Textcount(Aggr(Textcount(QueryType),QueryType))

What is wrong here?

Thanks.

Aggr formula

Jason_Michaelides — Mon, 28 May 2012 08:44:19 GMT

If I understand you right (and I'm not sure I do) you don't need Aggr() - try:

TextCount(TOTAL <QueryType> Query)

Hope this helps,

Jason

Aggr formula

lironbaram — Mon, 28 May 2012 08:45:33 GMT

i didnt realy understood what you want to do but first you need to change the expression

Textcount(Aggr(Textcount(QueryType),QueryType)) to

sum(Aggr(Textcount(QueryType),QueryType)) as the inner textcount returns numbers you need to use sum in your expression

Re: Aggr formula

Mon, 28 May 2012 09:00:42 GMT

Dear Liron,

As per your suggestion, I rectified expression.

Still there is problem.

Please refer to attachment (where I applied your expression). I have written in Blue text boxes what output should occur instead of zeroes.

I hope this clarifies my query.

Please help.

Thanks.

Re: Aggr formula

Mon, 28 May 2012 09:02:11 GMT

Dear Jason,

This works perfect.

Thanks a lot.

Aggr formula

Jason_Michaelides — Mon, 28 May 2012 09:03:55 GMT

Cool. Please close the thread by marking a correct answer.

Jason