topic Re: Regarding Total in QlikView

Regarding Total

sarfaraz_sheikh — Wed, 01 Apr 2015 11:10:44 GMT

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%

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.

Sarfaraz

Re: Regarding Total

PrashantSangle — Wed, 01 Apr 2015 11:15:31 GMT

Hi,

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

Regards

Re: Regarding Total

Anonymous — Wed, 01 Apr 2015 11:17:06 GMT

Can you share sample app or Expressions ?

Re: Regarding Total

sarfaraz_sheikh — Wed, 01 Apr 2015 11:25:30 GMT

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

Re: Regarding Total

Anonymous — Wed, 01 Apr 2015 11:34:55 GMT

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

or reduce the app , and upload without data app