27 Limiting values in Qlik Sense Bar Chart | Showing Top and Bottom n Values in Bar Chart

preview_player
Показать описание
In this #qliksense tutorial video I have talked about how you can limit the values in the bar chart. Also it is helpful in identifying top or bottom n values.

#QlikSenseTutorial

Top and bottom N values is a common request sometimes in bar chart or simple table.

Display limitations
Displaying large numbers of dimension values
When the number of dimension values exceeds the width of the visualization, a mini chart with a scroll bar is displayed. You can scroll by using the scroll bar in the mini chart, or, depending on your device, by using the scroll wheel or by swiping with two fingers. When a large number of values are used, the mini chart no longer displays all the values. Instead, a condensed version of the mini chart (with the items in gray) displays an overview of the values, but the very low and the very high values are still visible.
Рекомендации по теме
Комментарии
Автор

I want to limit my charts to the last 12months. How do I do that as month year is not a measure but a dimension.

kobbdab
Автор

at 4:17 you are wrong. its not compared to rest of the other products. its compared against the TOTAL of the measure. So if its sum total limitation would apply to dimensions that fall under n% of sum total, if its avg of total, it would apply to dimensions that fall under n% of avg of total.

pyush