topic Re: Count of Frequency in App Development

Count of Frequency

Prabhu1204 — Wed, 23 Sep 2020 05:14:29 GMT

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.

Re: Count of Frequency

Prabhu1204 — Tue, 22 Sep 2020 13:16:48 GMT

@Kushal_Chawda Could you please help me on this

Re: Count of Frequency

Kushal_Chawda — Tue, 22 Sep 2020 13:21:30 GMT

@Prabhu1204 for which column do you need frequency

Re: Count of Frequency

Kushal_Chawda — Tue, 22 Sep 2020 14:03:38 GMT

@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

Re: Count of Frequency

Prabhu1204 — Tue, 22 Sep 2020 15:00:42 GMT

Thanks Kush, Will try and get back

Re: Count of Frequency

Prabhu1204 — Tue, 22 Sep 2020 15:29:21 GMT

@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

Re: Count of Frequency

Kushal_Chawda — Tue, 22 Sep 2020 15:31:22 GMT

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

Re: Count of Frequency

Prabhu1204 — Tue, 22 Sep 2020 15:42:30 GMT

@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.

Re: Count of Frequency

Kushal_Chawda — Tue, 22 Sep 2020 15:56:54 GMT

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

Re: Count of Frequency

Prabhu1204 — Tue, 22 Sep 2020 15:59:28 GMT

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

Re: Count of Frequency

Prabhu1204 — Tue, 22 Sep 2020 16:04:47 GMT

@Kushal_Chawda , In front end. if it is not possible than in script

Re: Count of Frequency

Kushal_Chawda — Tue, 22 Sep 2020 16:46:44 GMT

@Prabhu1204 try below expressions

// for numbering duplicate =mod(RowNo(TOTAL), Count(total <Supplier>Supplier))+1 // for counting duplicate Count(total <Supplier>Supplier)

Re: Count of Frequency

Prabhu1204 — Wed, 23 Sep 2020 05:12:58 GMT

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