Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Displaying Top N Values

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.

Tags (1)
8 Replies

Re: Displaying Top N Values

Hi,

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

Regards

Anand

Not applicable

Re: Displaying Top N Values

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

like this?

Not applicable

Re: Displaying Top N Values

Thanks Manish, let me test this.

Re: Displaying Top N Values

Then try this

1. Largest Value should be 6

2. Others Option will be selected.

Regards

Anand

Not applicable

Re: Displaying Top N Values

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

Not applicable

Re: Displaying Top N Values

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

Replace SUM(Variance) with

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

in Calculated DImension,

Expression and Sort expression

File enclosed for your ref.

Community Browser