topic Re: Top N records in straight and pivot Table in QlikView

Top N records in straight and pivot Table

Mon, 19 Jan 2015 11:57:20 GMT

Hi,

I impemented, to control Top N records in straight and pivot table with input box along with that if i want to display all the records.

How can i implement.

Thanks,

MLNR

Re: Top N records in straight and pivot Table

francoiscave — Mon, 19 Jan 2015 12:26:56 GMT

Hi Narayanareddy,

Can you post a sample app please and the expected result.

It wil be easier for us to help you.

Thanks,

François

Re: Top N records in straight and pivot Table

maleksafa — Mon, 19 Jan 2015 12:55:09 GMT

you need to use the rank function, suppose your expression is sum(Sales). so your new expression will be if(rank(sum(Sales)) <=5,sum(Sales)) this will return the top 5, in your case you need to store the value of the input box in a variable and use it in the rank function.

Re: Top N records in straight and pivot Table

Anonymous — Mon, 19 Jan 2015 13:16:57 GMT

Hi,

Set variable in script:

SET vTopX = 10;

Create Slider Object in UI - select Variable vTopX in variables drop down.

Assign 0 in MinValue textbox

Assign 50 in MaxValue textbox

Assign 10 in Static Step textbox

Next create InputBox object - select Variable vTopX

in straight table add expression :

=If(aggr(rank(sum(Sales)),Product)<= $(=vTopX),Product)

Regards

Neetha