Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Frequency calculation

Hi all,

I'm trying to figuring out on how to create a column in a pivot table that can calculate the frequency of a product. Please refer to the screen shot below for better understanding:

error loading image

What I'm trying to achieve here is to calculate the number of time that the product was sold for that particular year. For example, the Product A was sold on Jan, Mac and Aug. The frequency column should return 3 (since it appears 3 times in the table) The numbers for each month is a total sales.

Is it possible to do it in a pivot table?

3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi Kim,

Please find the application in the attachment. Hope this application will help you.

Regards

Deepak

Not applicable
Author

Hi Deepak,

Thanks for the solution. But there is a problem. In a month, it can have multiple transactions. Currently the expression that I'm using for the measure is sum(Sales).

deepakk
Partner - Specialist III
Partner - Specialist III

can you send me a sample application. The problem is not clear.