topic Re: Count with criteria for graph in QlikView

Count with criteria for graph

ebahadur — Wed, 25 Nov 2020 16:16:04 GMT

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.

pedromsouza — Wed, 24 Apr 2019 12:37:45 GMT

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

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

woshua5550 — Thu, 25 Apr 2019 05:54:23 GMT

Try this

dimension : Month(Date)

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