topic Displaying a Random set of rows in QlikView

Displaying a Random set of rows

Wed, 09 May 2012 03:02:25 GMT

I need to dipslay 95% of the possible total rows in a table. Has anyone done this in QlikView - Do I start with GetSelectedCount? What formula did you use?

Displaying a Random set of rows

Wed, 09 May 2012 06:03:53 GMT

Hi,

You can use dimension limit tab to restrict the number of rows. The no of rows should be restricted based on first expression.

use Show only option and use Largest and in the values expression calculate using expression (This expression should give you the exact count of rows using the first expression).

Hope this help,

Anosh

Displaying a Random set of rows

Wed, 09 May 2012 12:26:10 GMT

Thank you. I have had training and done support but not a lot of development. Is the limit selection on the dimensions tab? So if I want to return 95% of the customer id's I would set up an expression that takes the GetSelectedCount(Customer_ID) * .95 and the number of rows will be based on this expression?

Re: Displaying a Random set of rows

Thu, 10 May 2012 06:52:47 GMT

Hi Randimaas,

Showing 95% of customer ids should be based on first expression. So you need to create a serial no column which contain unique no of each customer and then use serial no in dimension limit.

Please see the attached QVW file in which I have done the same. I am showing 60% of 5 customers. So only 3 customers are getting displayed in chart.

Hope this help,

Anosh