topic Re: Help required to show Rank. in QlikView

Help required to show Rank.

qlikviewforum — Fri, 13 May 2016 14:05:33 GMT

In the below straight table we show top 10 ranks. Now I want to remove the Rank expression but the issue is in the Sales column it is showing all the values since Rank is removed. Is there is any way to show the top 10 Sales without Rank column? Please help!

Country State City Rank Sales

Re: Help required to show Rank.

marcus_sommer — Fri, 13 May 2016 14:07:37 GMT

Have you tried the options within the object properties in tab restrictions?

- Marcus

Re: Help required to show Rank.

sunny_talwar — Fri, 13 May 2016 14:08:16 GMT

I don't see any screenshot or sample attached? Would you be able to attach a sample with expected output?

Re: Help required to show Rank.

trdandamudi — Fri, 13 May 2016 14:09:49 GMT

Look at "Dimension Limit" tab under "Limits" and this should help you...

Re: Help required to show Rank.

Anonymous — Fri, 13 May 2016 14:17:38 GMT

Creating rankings in the load script

Re: Help required to show Rank.

qlikviewforum — Fri, 13 May 2016 14:22:18 GMT

Top 10 rank is dynamic here. It can be anything. It can be 11,12 and 13 also. So I cant set it in the properties. Hope you understood my issue.

Re: Help required to show Rank.

marcus_sommer — Fri, 13 May 2016 14:28:32 GMT

The top number could be an expression or a variable and therefore could be dynamic.

- Marcus

Re: Help required to show Rank.

swuehl — Fri, 13 May 2016 14:30:27 GMT

Maybe just hide the rank column on presentation tab of your straight table properties.

You should be able to also create a set expression that filters your data, but without knowing anything about your data (model), chart context etc., I would go for the hidden column.

Re: Help required to show Rank.

Anonymous — Sat, 14 May 2016 08:22:13 GMT

rank(sum({1}sales))

Re: Help required to show Rank.

qlikviewforum — Sun, 15 May 2016 03:30:19 GMT

Thank you all.

How to sort it in ascending order when we added additional metrics to the straight table and rank that as well.

Let say they want to add a metrics called Sum(Margin) and rank that as well in the same straight table. How both of this metrics will be sorted in the straight table. I know date may be different for Sales and Margin. So when the Dates are different then obviously it will be null in any one of the columns but I would like to know how can I sort it in ascending order. Please help

Country State City Date Rank Sales Margin

Re: Help required to show Rank.

Anonymous — Sun, 15 May 2016 03:48:39 GMT

rank(sum({1}sales)) based on the dimension also get result for example you give the dimension city or state country dependence upon the dimension you got that

Re: Help required to show Rank.

qlikviewforum — Sun, 15 May 2016 11:10:25 GMT

Thank You! Will check this out tomorrow and will get back to you.

Re: Help required to show Rank.

swuehl — Sun, 15 May 2016 11:14:22 GMT

Could you show some sample lines of your chart with the dimension(s) and expression values you get and then show how you would like the chart to be sorted (and add a short description how you've derived the order).

There are several methods how to derive a rank from multiple other ranks.

Re: Help required to show Rank.

qlikviewforum — Mon, 16 May 2016 07:40:57 GMT

Thanks swuehl before I fix the sorting issue I need some important changes in the chart. I need your help on that very urgently. Will get back to you in sometime.

Re: Help required to show Rank.

qlikviewforum — Mon, 16 May 2016 13:48:20 GMT

I want to achieve column H in the attached excel. Please tell me how can i achieve it.

Re: Help required to show Rank.

sunny_talwar — Mon, 16 May 2016 13:51:31 GMT

May be try like this in your expression

Sum(Sales)/Sum(TOTAL <[City ID]> Sales)

Re: Help required to show Rank.

qlikviewforum — Mon, 16 May 2016 14:08:48 GMT

Thank you

Rank 13 that you see the excel it dynamic. I mean Top 10% of selected date range so it was be anything. So when I use TOTAL it is summing all the Sales value instead of summing only the Rank 13. Hope the issue what i am facing is understandable.

Re: Help required to show Rank.

sunny_talwar — Mon, 16 May 2016 14:20:16 GMT

What is the expression you are using for Sales column?

Re: Help required to show Rank.

qlikviewforum — Tue, 17 May 2016 05:49:51 GMT

Please find the attachment for Sales expression

Re: Help required to show Rank.

qlikviewforum — Tue, 17 May 2016 07:08:21 GMT

Hi Sunny & Swuehl

Whenever you have free time could you please check and help me on this?