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 , In front end. if it is not possible than in script

[Kushal_Chawda · Accepted solution]

@Prabhu1204  try below expressions

// for numbering duplicate

=mod(RowNo(TOTAL), Count(total <Supplier>Supplier))+1

// for counting duplicate
Count(total <Supplier>Supplier)

[Prabhu1204]

@Kushal_Chawda  Thanks a lot .. It works Great... You always rock