topic How to calculate each group separately in a chart in QlikView

How to calculate each group separately in a chart

QlickySense — Wed, 27 Oct 2021 10:12:12 GMT

Hello. I have chart like down below, in counts total of it, I'd like to calculate each group

My expression is:

=Count({$<status *={'Status1', 'Status2', 'Status3', 'Status4'}>} status)

Any tips?

Re: How to calculate each group separately in a chart

Or — Wed, 27 Oct 2021 10:17:02 GMT

It seems like "Group" should be your graph's dimension? It's hard to understand what exactly you're trying to achieve.

Re: How to calculate each group separately in a chart

QlickySense — Wed, 27 Oct 2021 10:31:15 GMT

Hi,

Yes thats right, however my background colors on categories are totally mess. I guess it's because of that set analysis part? Any tips how to overcome that?

Re: How to calculate each group separately in a chart

Or — Wed, 27 Oct 2021 10:44:38 GMT

You'll need to explain your graph's construction and underlying data structure. You posted a screenshot with no details, so I have no way of knowing what the bars and colors represent or what the actual data is.

Re: How to calculate each group separately in a chart

QlickySense — Wed, 27 Oct 2021 11:52:10 GMT

Yeah you're right

Under the dimension I got 2 variables

brandname from TableA

status from TableA

and my expression is

=Count({$<status *={'Status1', 'Status2', 'Status3', 'Status4'}>} status)

When I want to filter per any status, I lose my background colors

Re: How to calculate each group separately in a chart

Or — Wed, 27 Oct 2021 12:09:28 GMT

OK - and what exactly do you mean by "Calculate by each group"? Group isn't in your dimensions or expression.

If you want to always calculate for all four statuses regardless of filters, just change the *= to a regular =. This will force status to always evaluate all four options while *= means it will only show the selection and from the selection, only values that are in the first four statuses.

Re: How to calculate each group separately in a chart

QlickySense — Wed, 27 Oct 2021 12:47:26 GMT

Hi,

I've already acheieved what I wanted by Properties -> Presentations -> Plot values into segments 🙂

However this background colors bugs me

Look, here I've filtered middle group, colors in that group remained, but colors in the rest have been changed

I've removed *= and didnt work as well