topic SetAnalysis in a Pivot Table in QlikView

SetAnalysis in a Pivot Table

seband_fredes — Wed, 09 Jun 2021 23:21:44 GMT

Hi everyone,

I've this pivot table:

The Pivot Table's expression is a Count, and I need to calculate this result:

Have anyone some solution for this?

Thanks

sunny_talwar — Thu, 10 Jun 2021 13:29:48 GMT

May be this

Count(DISTINCT Letter)/Count(TOTAL DISTINCT Letter)

sergio0592 — Thu, 10 Jun 2021 13:49:19 GMT

I try with dimensionnalty() function for Total in pivot chart (learn from Sunny T!)

if(Dimensionality()=0,Count({<Value-={""}>} Letter) / Count(Letter),sum(Value))

sergio0592 — Thu, 10 Jun 2021 13:52:24 GMT

Sorryn in order to keep the Value1/Value2 representation it's :

if(Dimensionality()=0,Count({<Value-={""}>} Letter)&'/'& Count(Letter),sum(Value))