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: 
sarfaraz_sheikh
Contributor III
Contributor III

Regarding Total

Dear All,

I want to calculate Lead% like below ...

              Total_Leads_Considered               Insurer Reject              Follow_UP                        Lead_Lost

count               882                                         2                              89                                     34

Lead %            100%                             2/882*100= 0.22%          89/882*100= 10.09%                34/882*100= 3.85%

Snapshot is also attached here for more clarity of understanding....

In 1st snapshot there is no expression added called LEAD%

LMS3.png

In Second snapshot the LEAD % expression showing wrong percentage. i want LEAD % to be shown in Total Mode only not with Dimension's ..is it possible ,if yes then suggest me how i can achive the same with above calculation.

LMS4.png

Sarfaraz

4 Replies
PrashantSangle

Hi,

What is your expression for ATotal Lead Considered of COunt()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable

Can you share sample app or Expressions ?

sarfaraz_sheikh
Contributor III
Contributor III
Author

My file is 13.5 MB ....and i am trying to attach bu unable however once i say add reply then it get process further and stop ......finally nothing will be getting attach ....

Any tricks to attch the large file ..

Sarfaraz

Anonymous
Not applicable

load the data to minimal may be one day or one city

or reduce the app , and upload without data app