Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Chart Pivot Table - Help with Expression

I'm new to Qlikview and really new to Set Analysis and I'm struggling getting this working.  Below is a screen shot of my Chart Pivot Table I'm trying to create.

angmarceau1971_0-1603804243414.png

I'm having difficulties with two columns.

% of Total Day - I need to have the % be a percentage of the day and not the entire Total Calls.

So 2020/10/21 should have the following:

DateMenu OptionTotal Calls% of Total Day
2020/10/21Option 1 - Concierge89034.50%
2020/10/21Option 1 - Concierge - After Hours250.97%
2020/10/21Option 2 - Solutions114044.19%
2020/10/21Option 2 - Solutions - After Hours301.16%
2020/10/21Option 8 - Extension Dialing48518.80%
2020/10/21Option 8 - Extension Dialing - After Hours100.39%

 

% Match - This one works fine when I have the Pivot Date expanded, but when I collapse the date, it goes to 0%.

Here is what I have in the Chart Pivot.

Dimensions -
1) Date
2) MenuOption

Expressions-
1) Total Calls = Sum(Calls)
2) % of Total Day  = Sum(Calls)/Sum(TOTAL Calls)
3) ANI Match  = Sum(CCMatch)
4) % ANI Match = If(Match([MenuOption],'Option 1') OR Match([MenuOption],'Option 1 - After Hours'), sum(CCCMatch)/sum(Calls), 0)
5) Request Next Agent =  =sum("sum(if([CCMatch]=1,CCRoutedToS))")

any help would be appreciated.

 

 

1 Solution

Accepted Solutions
Specialist II
Specialist II

try this for total%

=sum([Total Calls])/aggr(nodistinct sum([Total Calls]), Date)

View solution in original post

3 Replies
Specialist II
Specialist II

try this for total%

=sum([Total Calls])/aggr(nodistinct sum([Total Calls]), Date)

View solution in original post

Contributor II
Contributor II

That worked perfectly when the pivot table is expanded to see the menu options.  But when not expanded, i'm seeing 1e+002%

angmarceau1971_0-1603831887021.png

 

Contributor II
Contributor II

Figured it out.  Just needed to format as Integer instead of Number and Show in Percent. 

Thanks for all your help!