Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Aggr formula

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.

1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Aggr formula

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

5 Replies
jason_michaelid
Honored Contributor II

Aggr formula

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

lironbaram
Honored Contributor II

Aggr formula

hi

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

Not applicable

Re: Aggr formula

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.

Not applicable

Re: Aggr formula

Dear Jason,

This works perfect.

Thanks a lot.

jason_michaelid
Honored Contributor II

Aggr formula

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

Jason

Community Browser