topic Re: Show random rows in a table every time in App Development

Show random rows in a table every time

qlikwiz123 — Tue, 04 Feb 2025 23:36:11 GMT

I created a data table. How do I show 50 random rows from a field in the table? Every time user refreshes the data, the table should show only 50 randomly selected values from that field.

Re: Show random rows in a table every time

Bhushan_Mahajan — Wed, 05 Feb 2025 03:30:13 GMT

@qlikwiz123 You can debug it with 50 as a row limit

Re: Show random rows in a table every time

rwunderlich — Wed, 05 Feb 2025 07:23:04 GMT

Do you want to do this in script or a chart?

-Rob

Re: Show random rows in a table every time

qlikwiz123 — Wed, 05 Feb 2025 19:56:53 GMT

Hi, either way works for me. Doing at chart level might slow down the chart load but I would like to try both and see which one performs better 🙂

Re: Show random rows in a table every time

rwunderlich — Thu, 06 Feb 2025 00:30:37 GMT

For script, you can do something like:

Sample:
LOAD
Value as Sample
Resident Data
Where Rand() > 0.8
and RowNo() <= 50;

You can play with the Rand() limit but the RowNo() will limit you to 50 rows.

For chart, I'm not sure how you can limit to 50, but you could get a set of random values as:

Aggr(if (Rand() > 0.8, Value), Value)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com