Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart question...

Another chart question I'm afraid (I will master these)

I've used the Straight Table chart option to create a chart which contains two dimensions... IndexDate and CallsReason.  The expressions are =sum(CallCounter) which gives me the number of calls and I'd like to include another which details the % of these calls.  Should I be creating a Calculated Dimension? The table below is similar to the one I've created.

Reason for CallReason 1
Header 1Header 2Header 3Header 4
Call Logged dateNo. of Calls%
01/06/201520%
01/06/2015Reason 2110%
01/06/2015Reason 380%
02/06/2015Reason 1100%
02/06/2015Reason 250%

Thanks in advance

10 Replies
ravindraa
Creator
Creator

use below expression for % values

sum(callcounter)/sum(TOTAL callcounter).

now you can get % wise values.