topic Re: Pivot Total Issue in QlikView

Pivot Total Issue

Wed, 03 Jul 2013 12:30:59 GMT

I have below expression in pivot table and Date as dimension

=if(TAT>=0 and TAT<=3, TextCount(DocNo))

Total at the bottom not showing any value

Seleted show partial sum for Date

Thanks in advance

kaushiknsolanki — Wed, 03 Jul 2013 12:40:46 GMT

Hi,

Try this.

Sum(Aggr(if(TAT>=0 and TAT<=3, TextCount(DocNo)),DATE))

Regards,

Kaushik Solanki

Anonymous — Wed, 03 Jul 2013 12:56:04 GMT

A little explanation.

Total make sense only for aggregation. For example, if your expression is

Amount

there can be no total. To get total, you have to use

sum(Amount)

KS recommends to use sum() as your expression, so the total is clearly defined.

Regards,

Michael

Thu, 04 Jul 2013 06:38:25 GMT

In this case if not executing correctly.

Count is not coming correct for some date

TAT is based on DocNo

kaushiknsolanki — Thu, 04 Jul 2013 06:41:51 GMT

Hi,

Yes.

To get the total's, your expression should have aggregation functions like Sum,Avg,.. and so on.

Regards,

Kaushik Solanki

Sokkorn — Thu, 04 Jul 2013 06:46:07 GMT

Hi,

Not sure you try this yet

TextCount(if(TAT>=0 and TAT<=3, DocNo))

Regards,

Sokkorn

Thu, 04 Jul 2013 06:48:12 GMT

Worked

Thanks alot