topic Stacked Bar chart showing top 10 Categories over time in QlikView

Stacked Bar chart showing top 10 Categories over time

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

Guys,

I have a support group that wants a chart that shows the top 10 support categories in a bar chart by week. In other words for each week there would be a bar with 10 segments with a count of the top 10 categories for that week. On the on-site I thought this would be pretty straight forward, but as I get into it, I'm not sure how to produce a chart like that.

They are looking for some to replace this excel file.

Thoughts?

Re: Stacked Bar chart showing top 10 Categories over time

MarcoWedel — Mon, 18 Jun 2018 21:29:29 GMT

Please share some sample data to work with.

Re: Stacked Bar chart showing top 10 Categories over time

brf10043 — Mon, 18 Jun 2018 21:51:19 GMT

Thanks Marco. I managed to work out the chart. However, I'm now struggling with a table.

I am trying to replicate this Excel table. In my chart the Date and Category is the dimension and the count is the expression.

Here is what I have so far in the table work. Any Ideas how to format a table like the one above from Excel?

Re: Stacked Bar chart showing top 10 Categories over time

MarcoWedel — Mon, 18 Jun 2018 22:02:34 GMT

Glad it worked out for you.

Please close this thread and open a new one for your new question (so it matches the thread title).

thanks

regards

Marco