topic Re: Need Help in QlikView

Need Help

paulwalker — Thu, 26 Feb 2015 02:50:31 GMT

HI All,

i have one expression.. like

sum(countid) / sum(total NoAmount)

Percentage wise it should be 100 % right ??

but i am getting above 100 % value..

Please can anyone help me out....

Re: Need Help

jagan — Thu, 26 Feb 2015 04:11:57 GMT

Hi,

If sum(countid) is greater then sum(total NoAmount) then you will get more then 100%, can you attach sample file and your expected output.

Regards,

Jagan.

Re: Need Help

avinashelite — Thu, 26 Feb 2015 04:44:52 GMT

Hi Paul,

Please attach the sample file so that we can check in detail

Re: Need Help

timanshu — Thu, 26 Feb 2015 04:46:40 GMT

Hi Paul,

Percentage can be displayed more than 100 %.

For example if sum(countid) gives 4500 and sum(total NoAmount) gives 800, then percentage becomes 562.5% ((4500/800)*100).

Re: Need Help

tresB — Thu, 26 Feb 2015 04:48:20 GMT

Paul Walker wrote:

.....

sum(countid) / sum(total NoAmount)

Percentage wise it should be 100 % right ??

Not really necessary. Had the expression been like: =sum(FieldA) / sum(total FieldA) (i.e - aggregations against same field), your expectaion would hold good.

Re: Need Help

MK_QSL — Thu, 26 Feb 2015 07:23:51 GMT

try

sum(countid) / sum(total <countid> NoAmount)