Discussion Board for collaboration related to Creating Analytics for QlikView.
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
What is wrong here?
Go to Solution.
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,
i didnt realy understood what you want to do but first you need to change the expression
sum(Aggr(Textcount(QueryType),QueryType)) as the inner textcount returns numbers you need to use sum in your expression
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.
This works perfect.
Thanks a lot.
Cool. Please close the thread by marking a correct answer.