Qlikview AGGR expression Chart

[askarkhan]

Hey.

I am facing a trouble . I want a table to show percentage of answered,busy and Ringing calls with respect to total calls in each month. I tried using combo of Aggr and set analysis. below result i got. Here i am getting total number of calls per month but it is showing in just one row. i can calculate the percentage of answered but not able to do for others like busy and Ringing no response. please help.

[sergio0592 · Accepted solution]

Hi,

Try with:

sum(#Count) / sum( TOTAL <Month> #Count)

[askarkhan]

Thanks. i was using AGGR function. it was giving Zero every time. This works with little change.

One thing here. If we taking expression lebel then we don't have to use sum. in that case expression will be like

• #Count / Count(TOTAL <Month>(customers)

Above don't get confuse with count.. the one "#Count" is lebel and "Count/(Total" is expression