Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ebahadur
New Contributor II

Count with criteria for graph

Dear Qlik Fellow,

Greeting 🙂

From below sample data I want to create a graph and want to count how many "Apples" are being sold.

My dimension for graph is month and expression will be item sold, which in this case its apple.

Capture.JPG

2 Replies
pedromsouza
Contributor

Re: Count with criteria for graph

Use set analysis (check Qlik help to understand syntax):

Count({$<Item={"Apple"}>} Sale)

Qliking since '09
Highlighted
woshua5550
Contributor III

Re: Count with criteria for graph

Hi

Try this

dimension : Month(Date)

expression : Count({<Item = {'Apple'}>}Item)