Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

siva0606
New Contributor II

Purchase frequency of Items

Hi all,

For Example,

I have many number of items in item table and i have to calculate Which item is purchased more number of times(frequency of item)?

Please help me in the expression part.

Regards,

Sivasu

6 Replies
eruditio
Contributor III

Re: Purchase frequency of Items

Hi,

Maybe post some examples, or your application.

Antoine

ashwanin
Valued Contributor

Re: Purchase frequency of Items

Textcount(Distinct PurchaseItem )

Re: Purchase frequency of Items

COUNT(Distinct ITEMS)

Not applicable

Re: Purchase frequency of Items

See attached.

Not applicable

Re: Purchase frequency of Items

Hi,

You can use count(item).

HTH

-Shruti

neetha_p
Honored Contributor

Re: Purchase frequency of Items

=Max(Count(Itemname))

Community Browser