topic Bottom 5 values using dimension limits in QlikView

Bottom 5 values using dimension limits

Thu, 15 Dec 2016 06:09:49 GMT

Hi Members,

Can we show bottom 5 values using dimension limits ?

I don not want to use aggr function in dimensions and metrics.

Thanks

Khushboo

lironbaram — Thu, 15 Dec 2016 06:17:03 GMT

yes you just need to use the dimension limit , and make sure the first expression is the one you want to filter by

then just select to display the smallest 5 values

as displayed in the picture

Thu, 15 Dec 2016 06:19:43 GMT

When i try to do that i get no data to display error in my chart.

Is the reason because my lowest values is 1 and I have more than 5 products with volume 1?

lironbaram — Thu, 15 Dec 2016 06:35:24 GMT

no this shouldn't be the reason it will randomly select 5 values from the list

Thu, 15 Dec 2016 06:46:28 GMT

Hi ,

My dimension is a cyclic group , for other dimension it is coming, but for product it is coming as no data to display.

Is it because few products have 0 value in fact table?

Thu, 15 Dec 2016 06:54:53 GMT

Hi Liron,

Checked this is the reason. Presence of 0 values in fact tables .

Hence bottom 5 values are 0.

If i remove suppress 0 values from the presentation tab, we get the results.

lironbaram — Thu, 15 Dec 2016 06:58:52 GMT

hi ok

so no problem

go to the presentation tab in the chart properties , and un-check the "suppress zero values"