topic Frequency Question in QlikView

Frequency Question

mphekin12 — Tue, 20 Sep 2016 19:54:16 GMT

I have the following data that is pretty straight forward. It is a Product ID and the number of time that product has been sold:

What I need is to be able to display the frequency of the 'Time Sold' column, so my data should look similar to this:

Any suggestions on how I can accomplish this?

Thank you!

swuehl — Tue, 20 Sep 2016 19:57:27 GMT

Try a calculated dimension like

=Aggr(Count(ProductID), ProductID)

and

=Count(DISTINCT ProductID)

as expression

mphekin12 — Tue, 20 Sep 2016 20:03:24 GMT

Stephan,

That seemed to do the trick.

Thank you so much for your help!