Distinct Records in Chart - Qlik Community

Report Inappropriate Content · ‎2015-05-12

Hi Friends ,

I have a requirement

Country	LIST TYPE	MAR
AE	BIC	BMCADR1
AE	CIL	BMCADR1
AE	BIC	BMCADR3
AE	CIL	BMCADR4
AU	BIC	BMCADR5
AU	CIL	BMCADR6
AU	AUM	BMCADR6
IND	AUM	BMCADR8
IND	BIC	BMCADR9
IND	BIC	BMCADR10

In the Above data , i have to build a chart based on the Country code as Dimension and Count (List Type) as Expression

Condition : I should Consider the List Type with only DISTINCT MAR (Out of 10 MAR , only 8 are distinct)

Regards,

Senthil

PrashantSangle · ‎2015-05-12

Hi,

User AGGR()

Try like AGGR(Count(Distinct List Type),Country,Mar)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

anbu1984 · ‎2015-05-12

Use this expr

=Count(DISTINCT MAR)