topic Re: can chart pulls only 500 random records? in QlikView

can chart pulls only 500 random records?

Wed, 21 Mar 2012 21:08:36 GMT

Hi All,

I have a sheet object (chart with dimension and expression).Depending upon the user selection,it brings back records.Few months before user specified they only want to see any 100 random records in that object.To achieve this, added a slider with max range 100.As per user selection in the slider,chart shows that many records and user exports those many records to xls easily.

Now user wants to export 500 random records.With slider can not do that as in the chart presention tab Max number is set 1-100.Even though changed the slider settings to 500,chart could not show more than 100 records.

Does anyone know whether there is a way that doc can pull all the records but chart only show any 500 random records.

Thanks-Pooja

can chart pulls only 500 random records?

qliksus — Thu, 22 Mar 2012 06:53:23 GMT

Currently u will be using the varibale of the slider in the Max Number now in

the expression use the Rank function to limit the records i.e say ur varibale is Limit

this varibale will be given in the Max Number and in the expression give a condition like

if ( $(Limit) <=100 , sum(amount) ,

if ( $(Limit) >=100 or ( Rank( sum(amount) >100 and Rank( sum(amount)) <=500 ) , sum(amount) , 0))

if i have understood ur example wrongly let me know

Re: can chart pulls only 500 random records?

Thu, 22 Mar 2012 14:31:20 GMT

Thanks for your response.I am little confused ...here I have attached a sample chart which has 4355 records.Can you please modify this sample with your code.Just need to export random 500 records to xls.

Thanks again!

Re: can chart pulls only 500 random records?

qliksus — Fri, 23 Mar 2012 06:36:33 GMT

Hi ,

Sorry for the late reply

Please find the attached file for the solution

Re: can chart pulls only 500 random records?

Fri, 23 Mar 2012 14:45:52 GMT

Thank you so much!