Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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_Michaelides
Luminary Alumni
Luminary Alumni

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

View solution in original post

5 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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
Partner - Master III
Partner - Master III

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
Author

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
Author

Dear Jason,

This works perfect.

Thanks a lot.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

Jason