Can't divide two calculations in chart

[#1]

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 · Accepted solution]

Hi Aaron,

Try below expression -

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

/

Count(Total Distinct Header_Uid)

[sonkumamon]

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]

How about this

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

[#5]

Thanks!

[#6]

I didn't think of that, thanks

[#7]

Thanks!