Have one doubt.Is there any way that i can display count of uniq data in a column.I mean out of all the data in that column i want to display only count of one specific data.Is there any expression in Qlik sense that can handle this kind of scenario

[#1]

I know there is some expression in qlikview.But want to know for qlik sense.

[ahmar811]

hi

please refer this link

A Better Show Frequency | Qlikview Cookbook

hope it is helpful for you

Thanks & Regards

Ahmar

[reddy-s]

Hi Ravi,

To display unique entries in a column use this expression:count(distinct <Field>)

Or if you want to count the number of times a particular value occurs use this: count({$< Field = {'A'} >} <Field>)

Assume that 'A' is a value of a Field

[#4]

YEAH ITS WORKING...THANKS ALOT Sangram for the help.

[#5]

Where can i get the what exactly that syntax mean?.I want to know how different ways can expressions be used...From where i can learn that?

[reddy-s]

Please close the thread if you are satisfied with the answer.