Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikvw2019
Contributor
Contributor

Bar Chart Group by Month

Hello Friends,

 

I am new to Qlikview and struggling with a graph. I already spend some time in review older posts however  , noluck 

 

I have data as such

ORDER IDOrder DateStatus
1Jan 3 2019Completed
2Dec 26 2018Completed
3Jan 15 2019WIP
4Jan 29 2019COMPLETED

 

I am trying to display the graph as Orders=COMPLETED, grouped by each month

1 Reply
Lisa_P
Employee
Employee

You will need to create a month year dimension if you don't already have one and then
count([ORDER ID]). To limit the count to only completed orders, you can include this in the expression
syntax as a set {<Status={Completed, COMPLETED}>}. (Qlik is case sensitive)
So complete expression is:
count({<Status={Completed, COMPLETED}>}[ORDER ID])