topic Re: % calculation in straight table in QlikView

% calculation in straight table

Mon, 22 Sep 2014 07:14:32 GMT

I m using straight table to calculate the total tickets field and resolved ticket field

table ticket resolved ticket

10 5

12 3

11 -
13 4

14 -

the data displayed like this. to use the two fields to calculate the %. the % calculating I am using this condition like column(1)/column(2) but data not getting. because in resolved ticket field some data having '- ' like this. I m using suppress to null value but also not getting. how to calculate the % anyone plz tell me .....urgent

Re: % calculation in straight table

sushil353 — Mon, 22 Sep 2014 07:16:21 GMT

Try this:

alt(column(1)/column(2) ,0)

HTH

Sushil

Re: % calculation in straight table

senpradip007 — Mon, 22 Sep 2014 07:17:05 GMT

Could you upload sample qvw?

Re: % calculation in straight table

jagan — Mon, 22 Sep 2014 07:17:37 GMT

Hi,

Attach some sample file, it helps to give solution quickly.

Regards,

Jagan.

Re: % calculation in straight table

amit_saini — Mon, 22 Sep 2014 07:22:48 GMT

Subbu,

Like this????

Thanks,

Re: % calculation in straight table

Mon, 22 Sep 2014 07:54:45 GMT

in the above example I m using the your expression but total % sum getting 0.0%.

but I need the total( total tickets )/total(resolved tickets) =%of resolved tickets means 12/60=% resolved tickets plz tell me any expression urgent

Re: % calculation in straight table

Anonymous — Mon, 22 Sep 2014 08:15:43 GMT

Hi Subbu,

see the attached file .

hope this would be help you.