Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Charts with count of Distinct Records

Hi Friends ,

I have a requirement

  

CountryLIST TYPEMAR
AEBICBMCADR1
AECILBMCADR1
AEBICBMCADR3
AECILBMCADR4
AUBICBMCADR5
AUCILBMCADR6
AUAUMBMCADR6
INDAUMBMCADR8
INDBICBMCADR9
INDBIC

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

Tags (1)
2 Replies

Re: Charts with count of Distinct Records

Count(DISTINCT MAR)20-May-15 9-43-25 AM.jpg

satishqlik
Contributor

Re: Charts with count of Distinct Records

Hi Senthil,

Dim--->Country

EXP--->Count(List Type) based on Count(Distinct Mar)

I think with your source data, it doesn't make sense So kindly recheck and revert ASAP.

Community Browser