topic Re: Can't divide two calculations in chart in QlikView

Can't divide two calculations in chart

Wed, 25 Nov 2020 16:16:04 GMT

This is extremely weird, or maybe I'm just doing something really simple, really wrong.

Here are two charts. One is total orders, one is total orders with a source of PV.

Here are the two expressions.

count(distinct(header_uid))

Count({<[orig-source]={'PV'}>}DISTINCT(header_uid))

I want a chart that shows % of PV Orders from Total orders.

Naturally, I use this.

=Count({<[orig-source]={'PV'}>}DISTINCT(header_uid))

count({<[orig-source]= >}distinct(header_uid))

But this is my chart...

Why?

md_qlikview — Mon, 31 Jul 2017 19:10:38 GMT

Hi Aaron,

Try below expression -

Count({<[Oring-source]={'PV'}>}Distinct Header_Uid)

Count(Total Distinct Header_Uid)

sonkumamon — Mon, 31 Jul 2017 19:34:03 GMT

As Milind wrote, the set analysis in the denominator is useless, because you need to divide in the total count and not the selected count.

sunny_talwar — Mon, 31 Jul 2017 19:42:59 GMT

How about this

=Count({<[orig-source]={'PV'}>} DISTINCT header_uid) / Sum(Aggr(Count({<[orig-source]>} DISTINCT header_uid), MonthYearField, [orig-source]))

Mon, 31 Jul 2017 19:47:02 GMT

Thanks!

Mon, 31 Jul 2017 19:47:12 GMT

I didn't think of that, thanks

Mon, 31 Jul 2017 19:47:21 GMT

Thanks!