topic Re: How to get Count in Pivot table in QlikView

How to get Count in Pivot table

Anonymous — Wed, 06 Dec 2017 11:56:17 GMT

Hi ,

I hve a MeetinId, Clint name ,Event Date is there,I neeed want to Count of meetingId based on Client name .

How it will you get in Dimension level.

Thanks,

Anil_Babu_Samineni — Wed, 06 Dec 2017 11:58:27 GMT

Does it mean this as Calc. Dimension?

Aggr(Count(MeetingId), [Client Name])

Anonymous — Wed, 06 Dec 2017 11:59:41 GMT

could you please elaborate more on this..

darrell_tobin — Wed, 06 Dec 2017 12:06:40 GMT

Just count will count meetingid by the two dimensions Client name ,Event Date

EXAMPLE

count(meetingId )

Using aggr function you can count the total meetingids for the Client name field

EXAMPLE

=aggr(count(meetingId), [Clint name])

Please set as correct if this is useful

Anonymous — Wed, 06 Dec 2017 12:57:39 GMT

Thank you Anil .It's working Good

Anil_Babu_Samineni — Wed, 06 Dec 2017 13:00:04 GMT

Please close this thread by flag "Correct Answer"