can chart pulls only 500 random records?

[#1]

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

[qliksus]

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

[#3]

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!

[qliksus · Accepted solution]

Hi ,

Sorry for the late reply

Please find the attached file for the solution

[#5]

Thank you so much!