topic Re: Displaying Top N Values in QlikView

Displaying Top N Values

Tue, 01 Nov 2016 11:18:25 GMT

Hello,

I am looking to restrict the rows displayed in a Straight Table based on an expression, please look at the attached sample.

Ascending block should display only the negative variance numbers and the Descending block should display only the Positive Variance numbers, and if there are no negative/Positive numbers then the rows should be omitted.

Thanks.

Re: Displaying Top N Values

its_anandrjs — Tue, 01 Nov 2016 11:33:56 GMT

Hi,

From settings remove Options >> Uncheck ( Show Others Option )

Regards

Anand

Re: Displaying Top N Values

Tue, 01 Nov 2016 11:39:02 GMT

Well, I want to display the Others option as well.is it possible to keep it as it is?

Thanks.

Re: Displaying Top N Values

MK_QSL — Tue, 01 Nov 2016 12:03:48 GMT

like this?

Re: Displaying Top N Values

Tue, 01 Nov 2016 12:17:31 GMT

Thanks Manish, let me test this.

Re: Displaying Top N Values

its_anandrjs — Tue, 01 Nov 2016 12:19:02 GMT

Then try this

1. Largest Value should be 6

2. Others Option will be selected.

Regards

Anand

Re: Displaying Top N Values

Tue, 01 Nov 2016 12:27:29 GMT

But this will not limit the variance to display only the negative/Positive numbers.

Re: Displaying Top N Values

Tue, 01 Nov 2016 12:29:20 GMT

Hello Manish,

I will have to compute the Variance using the Expressions and will not be able use the SUM(Variance) as it is. This is just a sample for simplicity.

Also, there is no restriction to show only the Positive /Negative variances here.

Re: Displaying Top N Values

MK_QSL — Tue, 01 Nov 2016 12:46:09 GMT

Replace SUM(Variance) with

SUM([2016USD])-SUM([2015 USD])

in Calculated DImension,

Expression and Sort expression

File enclosed for your ref.