topic Re: Straight Table Dimension Limit in QlikView

Straight Table Dimension Limit

Fri, 16 Aug 2013 06:27:46 GMT

Dear All,

I have a straight table with 40 rows.

The dimension limit allowed me to display 'FIRST' N number of row. but i would like to find out is there a method to specify to display row 30-40?

Re: Straight Table Dimension Limit

tresB — Fri, 16 Aug 2013 07:06:10 GMT

Hello,

Row number changes with sort order and selection, so my idea would be to use rank() function as in the attached file.

PFA

Re: Straight Table Dimension Limit

Fri, 16 Aug 2013 07:23:10 GMT

now i have the row number in the table. 'NOT THE ROWNO AT RUNTIME'

already given in table

row number should put under dimension or expression??

For example i want the straight table to show only the row number from 20-30

Please refer attached

thank you

Re: Straight Table Dimension Limit

Fri, 16 Aug 2013 07:31:55 GMT

Hi,

Use the calculated dimention for the field rowno1 as below.

if(rowno1 >= 20 and rowno1 <= 30, rowno1

)

Re: Straight Table Dimension Limit

tresB — Fri, 16 Aug 2013 07:40:18 GMT

PFA

Update: you can simply write the calculated dimension as

If(rowno1>9 and rowno1<31,rowno1)

with the 'Supress When Value is Null' checked

Re: Straight Table Dimension Limit

Fri, 16 Aug 2013 07:40:52 GMT

Hi. Dont mind can you use my product.qvw to show me? Cause i don't really understand

One i added in the things.

the result shown in the table below

Re: Straight Table Dimension Limit

Fri, 16 Aug 2013 08:23:43 GMT

Hi Tres,

Just a quick one. If the rowno1 row is not exist in the table.

Any way for us to specify display the first 30 records based on alphabetical order or the employee name?

Re: Straight Table Dimension Limit

tresB — Fri, 16 Aug 2013 08:27:53 GMT

Set the sort order based on Alph order/Employee (Sort tab), then limit the rows in the dimension limit tab. right?

Re: Straight Table Dimension Limit

Fri, 16 Aug 2013 08:30:35 GMT

ok.. but the dimension limit can set range. Am i right? It can either first, largest, smalles. or specify the value.

Is it allowed specify the range like record 30-40?

Re: Straight Table Dimension Limit

tresB — Fri, 16 Aug 2013 09:05:36 GMT

If rank() function can't be used as i showed in my first post here, i guess you have to create a field in the script and use that for the same. Script would look like:

Load

rowno() as Row,

Employee

From <> Order By Employee;