topic Re: Bar chart grouping in QlikView

Bar chart grouping

Thu, 06 Apr 2017 18:17:50 GMT

Hello,

I'm trying to create a bar chart of closed cases by month. I only want to display 3 months of data. My dimension is "Month Year Closed" my expression is "Count(Cases_Closed)"

How do i limit to last 3 months? and how do group the each months into one bar?

Thanks

Re: Bar chart grouping

CarlosAMonroy — Thu, 06 Apr 2017 18:43:00 GMT

Hi Ann,

So if your MonthYear field has MMM YYYY format, you can try the following:

Expression:

=Count({<[Month Year Closed]={">=$(=MonthName(AddMonths(Max([Month Year Closed]),-2))) <=$(=MonthName(Max([Month Year Closed])))"}>}Cases_Closed)

Now If you want to group the months in one bar:

Go to Object Properties -> Style Tab and then under Subtype section, Select Stacked.

Hope that helps,

Carlos M

Re: Bar chart grouping

vinieme12 — Thu, 06 Apr 2017 18:43:48 GMT

see this post

Dates in Set Analysis

Re: Bar chart grouping

Thu, 06 Apr 2017 19:01:45 GMT

subtype is grayed out

Re: Bar chart grouping

CarlosAMonroy — Thu, 06 Apr 2017 20:24:17 GMT

Oh that's right! It is gray out because you only have one expression! So that option works with 2 or more expressions.

Re: Bar chart grouping

CarlosAMonroy — Thu, 06 Apr 2017 20:27:32 GMT

If you need to do Stacked bar, update and add the expressions to be:

1st

=Count({<[Month Year Closed]={"=$(=MonthName(AddMonths(Max([Month Year Closed]),-2)))"}>}Cases_Closed)

2nd

=Count({<[Month Year Closed]={"=$(=MonthName(AddMonths(Max([Month Year Closed]),-1)))"}>}Cases_Closed)

3rd

=Count({<[Month Year Closed]={"=$(=MonthName(Max([Month Year Closed])))"}>}Cases_Closed)

Thanks,

Carlos M