Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ebahadur
Contributor II
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
Creator II
Creator II

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

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

Qliking since '09
woshua5550
Creator III
Creator III

Hi

Try this

dimension : Month(Date)

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