topic Pivot Table Expression with Count and Total Count in QlikView

Pivot Table Expression with Count and Total Count

Wed, 08 Jul 2015 05:56:15 GMT

Hi,

Good day All!

I am trying to achieve the count(value) / count (total value). but i need to add some conditions on that.

I am attaching a sample file here.

Please help me to resolve this..

Thanks and Regards

lironbaram — Wed, 08 Jul 2015 06:11:39 GMT

have a look at the attach example

i changed the calculated dimension to regular dimension

and added the if clause to the expressions

krishna20 — Wed, 08 Jul 2015 06:22:17 GMT

Hi,

Your First Expression : Count(REPORING_AIRLINE)

Your Second Expression : =([Reports Count])/ Count (TOTAL REPORING_AIRLINE)

Here Reports Count is the Label Name of first expression.

Please try this and let me know.