Count of Frequency

[Prabhu1204]

Hello

I am using two or more input files and consolidating the file as in the attached excel,  I want to bring the Count of frequency as  like Column L and M. How to achieve this in Qliksense Chart.

[Prabhu1204]

@Kushal_Chawda  Could you please help me on this

[Kushal_Chawda]

@Prabhu1204  for which column do you need frequency

[Kushal_Chawda]

@Prabhu1204  create a table with Dimension Supplier and below expressions

//Count of Duplicates
=sum(total aggr(if(Count(Supplier)>1,1,0),Supplier))

// No of Dulicates
=count(Supplier)

You can adjust the expression labels based on your definition of duplicates

[Prabhu1204]

Thanks Kush, Will try and get back

[Prabhu1204]

@Kushal_Chawda  Kush,

I tried in Qlikview and the no duplicate is showing 1 and not a consecutive number 1,2,3,4 etc.. I am making anything wrong

[Kushal_Chawda]

@Prabhu1204  How would you want the output when you have multiple duplicate supplier? like ABB ,ACC

[Prabhu1204]

@Kushal_Chawda  one code will have one supplier, for example acc supplier will have separate code and for that code number of duplicate values starts from 1,2,3,vice versa for all other code and supplier.

[Kushal_Chawda]

@Prabhu1204  Do you want it in script or front end?

[Prabhu1204]

if it is possible in front end na okay in front end..