topic Re: Qlikview AGGR expression Chart in QlikView

Qlikview AGGR expression Chart

askarkhan — Thu, 08 Sep 2022 08:02:03 GMT

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.

Re: Qlikview AGGR expression Chart

sergio0592 — Fri, 09 Sep 2022 09:39:44 GMT

Hi,

Try with:

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

Re: Qlikview AGGR expression Chart

askarkhan — Tue, 13 Sep 2022 12:43:15 GMT

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