topic Bar Chart Group by Month in QlikView

Bar Chart Group by Month

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

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 ID	Order Date	Status
1	Jan 3 2019	Completed
2	Dec 26 2018	Completed
3	Jan 15 2019	WIP
4	Jan 29 2019	COMPLETED

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

Re: Bar Chart Group by Month

Lisa_P — Wed, 29 May 2019 01:21:37 GMT

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])