topic Re: Percentage issue, in QlikView

Percentage issue,

everest226 — Fri, 15 Mar 2019 15:59:21 GMT

So i have a table bellow are the column and expression . Some how percentages total label is incorrect where as by category is correct

Column 1 Total

if(Sum({< Is={'T'}, [ CAT Name] = {'T I'} >} [ Sold] )>0,
Sum({< Is={'T'}>} [Sold] ))

Column 2 GRE

if(Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [ Sold] )>0,
Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [ Sold] ))

total percentages

if(Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [ Sold] )>0,
Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [Sold] ) / Sum({< Is={'T'} >} [Sold] ))

Re: Percentage issue,

sunny_talwar — Fri, 15 Mar 2019 15:38:47 GMT

What is wrong? If 18.1% is not right then what is right?

Re: Percentage issue,

everest226 — Fri, 15 Mar 2019 15:50:59 GMT

664518 of 2650572 is 24.95

Re: Percentage issue,

everest226 — Fri, 15 Mar 2019 15:52:06 GMT

Opps i attached wrong File . editing soon

Re: Percentage issue,

everest226 — Fri, 15 Mar 2019 16:00:10 GMT

Please see the attachment now thanks

Re: Percentage issue,

sunny_talwar — Fri, 15 Mar 2019 16:06:07 GMT

Try this

Sum({<Is={'T'}, [CAT Name] = {'T I'}>} [ Sold])
/
Sum(Aggr(
  If(Sum({< Is={'T'}, [ CAT Name] = {'T I'} >} [ Sold]) > 0, Sum({<Is={'T'}>} [Sold]))
, Dimension))

Re: Percentage issue,

everest226 — Fri, 15 Mar 2019 16:16:19 GMT

Thanks Sunny, it worked perfectly , however it has Cycle group dimension , so it only works for one dimension . is there a way to works in all dimension

Re: Percentage issue,

sunny_talwar — Fri, 15 Mar 2019 16:22:04 GMT

May be this

Sum({<Is={'T'}, [CAT Name] = {'T I'}>} [ Sold])
/
Sum(Aggr(
  If(Sum({< Is={'T'}, [ CAT Name] = {'T I'} >} [ Sold]) > 0, Sum({<Is={'T'}>} [Sold]))
, $(='[' & GetCurrentField([Group Name]) & ']'))))

Re: Percentage issue,

everest226 — Fri, 15 Mar 2019 17:06:38 GMT

Thanks it worked out perfectly .