Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

5 Replies
ahmar811
Contributor III

Re: 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

hi

please refer this link

A Better Show Frequency | Qlikview Cookbook

hope it is helpful for you



Thanks & Regards

Ahmar

reddys310
Honored Contributor II

Re: 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

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

Not applicable

Re: 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

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

Not applicable

Re: 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

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?

reddys310
Honored Contributor II

Re: 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

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