topic Re: Chart Properties: Ranking Columns in QlikView

Chart Properties: Ranking Columns

knightwriter — Thu, 21 May 2015 11:16:03 GMT

Hi All,

Easy one I reckon but I actually cant find the answer!

I have a chart pivot table and I have used 2 Dimensions but I want to rank the chart by the highest expression Ive used (YTD Total).

How do I do this?

Im in Chart Properties -> Sort -> ??

Many thanks

Re: Chart Properties: Ranking Columns

buzzy996 — Thu, 21 May 2015 11:21:08 GMT

try, from sort tab by selecting ur expression & expression check box.

else

else use dimensions limit.

Re: Chart Properties: Ranking Columns

Thu, 21 May 2015 11:24:27 GMT

You don't need the Sort Tab. You need to look at the Dimension limits TAB and check the restrict which values are displayed and then you can set your desired output.

Remember to uncheck Show others if you do not wish to show the values that do not belong to your setup.

quick view by default groups all the values that are out of your setup as one chunk and calls them others.

hope this helps.

Re: Chart Properties: Ranking Columns

avinashelite — Thu, 21 May 2015 11:24:57 GMT

try with the dimension limit or sort by DESC order on the expression..