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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.