topic Re: Sorting in QlikView

Sorting

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

This question may be difficult to ask but i'll try.

My object is in a straight table.

So I have one dimension with is called (Category). This has Beverages, Breads, Milk e.t.c

But I have multiple calculated expressions (Sales, Margin, Margin % e.t.c)

One of the columns is called "Contributor" and this column is in %.

I have sorted it my lowest to highest %.

But I only need to show first 10 categories. The rest I don't want to show.

How can I do this..

Re: Sorting

antoniotiman — Fri, 21 Jul 2017 14:45:34 GMT

Hi Joe,

'first 10 categories' about what ? (sale,margin,margin %, contributor ... ?)

Re: Sorting

vishsaggi — Fri, 21 Jul 2017 14:46:55 GMT

IN the Dimensions Limits tab just show 10 largest like below?

Or use a calculated dimension like

= IF(Aggr(Rank(Sum(yourfieldname), 0), Category) < 11, Category)

Re: Sorting

jadams123 — Fri, 21 Jul 2017 15:37:38 GMT

I need the first 10 in contributor.

I tried "Show Only" and the object gives me an error message.

I just need to show top 10 contributor column (this is a calculation).

Re: Sorting

vishsaggi — Fri, 21 Jul 2017 15:44:45 GMT

Can you share a sample to look into and what is that error you are getting and where exactly you are getting an error?

Re: Sorting

jadams123 — Fri, 21 Jul 2017 15:54:12 GMT

This is my object:

There are about 140 categories (First column).

In the "low margin contributor" (Last column) column I have sorted by lowest to highest. And I just want to show the first 10 numbers.

When I do this:

it shows me this error:

There must be a way to just show the first 10 rows.

Thanks,

Re: Sorting

Anonymous — Fri, 21 Jul 2017 15:54:42 GMT

The "Show Only" option should work if the expression "Contributor" is promoted to the first expression.

Re: Sorting

jadams123 — Fri, 21 Jul 2017 16:01:37 GMT

I promoted it to the first expression. It still shows error msg still.

By the way Contributor is a calculated expression. Example I am let say doing this [Invoice Margin Week %] * (set analysis)/(set analysis)

So I am doing some calculations in this column.

Re: Sorting

vishsaggi — Fri, 21 Jul 2017 16:02:12 GMT

Did you try the rank function? I cant assume the fields and write an expression as it might be right or wrong, a sample qvw file will help to quickly work on it. If possible please upload your sample to have a quick check.

Re: Sorting

jadams123 — Fri, 21 Jul 2017 16:06:17 GMT

I am a front end user of QV. I don't have access to qvw files

Re: Sorting

vishsaggi — Fri, 21 Jul 2017 16:18:19 GMT

Are you opening this dashboard from Access Point or from your local desktop?

Re: Sorting

jadams123 — Fri, 21 Jul 2017 16:21:00 GMT

Desktop

Re: Sorting

vishsaggi — Fri, 21 Jul 2017 16:25:26 GMT

So just save a copy and upload here. You can scramble the data if your data is sensitive and upload.

Preparing examples for Upload - Reduction and Data Scrambling

Re: Sorting

jadams123 — Fri, 21 Jul 2017 16:42:55 GMT

ok I published it on my profile.

Re: Sorting

vishsaggi — Fri, 21 Jul 2017 16:51:14 GMT

Where exactly you copied on your profile i cant find any qvw file there?

You can upload your file like once you click on reply - > Go to top right corner of that reply window where you can see use advance editor, then you can see an attach symbol on bottom right corner.

Re: Sorting

passionate — Fri, 21 Jul 2017 16:57:05 GMT

Hi Adam,

PFA. Solution.

I have used the same method i.e Calculated dimension and it's working as expected.

Regards,
Pankaj

Re: Sorting

jadams123 — Fri, 21 Jul 2017 17:33:26 GMT

oh sor you are saying that Diminsion limits work fine...hmm..interesting ....ok let me try again.

example.xls (J-Adams-123)‌