Mode in Bar Charts

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

Hi All

I'm trying to create a bar graph and that shows the most mentioned item for each week by counting its logs.

I cant seem to get the expression correct. I use mode to determine the most occurred item and run the graph by week, but the graph just shows the most occurred item for this week and a graph of its occurrences across the weeks.

MostOccuredItem = mode({$<Item = {*} -{'Unknown'}<} Item)

count({<Item = {'$(MostOccuredItem)'}>} LogNo}

Re: Mode in Bar Charts

Anonymous — Thu, 26 Apr 2018 17:10:05 GMT

Hi Alexander,

I don't quite understand what you're looking to present on your bar chart. Are you looking to present the most mentioned item for each week in a table like this?

Week mode(Item)

1 ItemA

2 ItemB

3 ItemC

4 ItemA

topic Mode in Bar Charts in QlikView

Mode in Bar Charts

Re: Mode in Bar Charts