Count of ID which got 'OS' rating for two consecutive years ...

[shekhar_analyti]

Hi All ,

How to show Count of ID which got 'OS' rating for two consecutive years in a Text Box ?

How to show Count of ID which never got 'OS' rating in a Text Box ?

Thanks

Shekar

[antoniotiman]

Yes You are correct. (QV Version >= 12 or QlikSense)

[shekhar_analyti]

How to get its ID and Name in two different text box

[antoniotiman]

=Concat(DISTINCT Aggr((If(Above(TOTAL Rating,1,1) = 'OS' and Rating='OS',ID)),ID,First_Name,Year,Rating),' - ')

=Concat(DISTINCT Aggr((If(Above(TOTAL Rating,1,1) = 'OS' and Rating='OS',First_Name)),ID,First_Name,Year,Rating),' - ')

Regards,

Antonio

[shekhar_analyti]

Many Thanks ...

[shekhar_analyti]

Antonio , Please let me know if I can add you for one of my problem , which is still unanswered