Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Want to see chart by percentage .

Want to see the value by percentage.

Please find the sample model.

PleCapture.PNG

1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

This should do it.  See Attached.

change your count(CallID) to count(CallID) / (count(CallID) + count(CallCallID) + count(EnquiryCallID))

and do the same for the others then format them as number 2 decimals and as a percentage

View solution in original post

3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Change your expression like below

Product Complaint:

Count(CallCallID)

/ (Count(CallCallID) + Count(CallID) + Count(EnquiryCallID))

Call:

Count(CallID)/ (Count(CallCallID) + Count(CallID) + Count(EnquiryCallID))

Enquiry:

Count(EnquiryCallID)/ (Count(CallCallID) + Count(CallID) + Count(EnquiryCallID))

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

and in Number set as % for this expressions.

Regards,

jagan.

ogster1974
Partner - Master II
Partner - Master II

This should do it.  See Attached.

change your count(CallID) to count(CallID) / (count(CallID) + count(CallCallID) + count(EnquiryCallID))

and do the same for the others then format them as number 2 decimals and as a percentage