topic Re: Row Break in Straight table in QlikView

Row Break in Straight table

Thu, 12 May 2016 20:15:19 GMT

I have a straight table with 4000 rows,i want to make partition into ranges(it has to show only 1000 at a time in the table) within the front end.As per user requirement,if they click on range2(1001 to 2000 rows) ,if they click on range3(2001 to 3000 rows)should display etc..

There is no unique key in the straight table so i created a 2 new exp to generate row number as RowNo(TOTAL) and Ranges (Range1-1 to 1000,range2-1001 to 2000 rows etc) as 'Range' & ceil(RowNo(TOTAL)/1000,1,1),now both expressions are showing correct result in the table but i failed to break the data within the straight table.when i click on Range(Range1) colume it displays only one row instead of 1000 rows.

I cant create a RowNo() in backend because when i tried this in scripting showing wrong row number, In the raw data we have more 30,000 rows i dont want to make partition on this 30,000 rows data. I need to do break the data which is in straight table in frond end

Thanks

Re: Row Break in Straight table

sunny_talwar — Thu, 12 May 2016 20:50:34 GMT

Check here:

Paging Implementation for Straight table

Re: Row Break in Straight table

Thu, 12 May 2016 21:04:12 GMT

Hi Sunny,

Thanks for quick reply.

This is what i want exactly output as presentation.But my problem is to create a group in backend because we have 30,000 rows in data model if i do same thing it will create more number of groups which i dont require.

Is there any other procedure to create groups in straigth itself???

Because in table i have 4000 rows, so now i want only 4 groups.

Re: Row Break in Straight table

marcus_sommer — Fri, 13 May 2016 05:42:09 GMT

With rowno() as expression in the chart you could display such things but because it's an expression you couldn't select them with this way. I think the easiest way would be to add such a rowno-logic within the script as an extra field which you then could use for this, maybe:

Load *, ceil(rowno() / 1000) as RowNoCluster From YourSource;

Possible would be also to create such cluster as a listbox-expression, maybe something in this way:

aggr(ceil(rank(YourExpression) / 1000)), YourDimensions)

but most are script-solutions more suitable.

- Marcus

Re: Row Break in Straight table

Anonymous — Fri, 13 May 2016 06:24:28 GMT

Re: Adding Table in PPT

Re: Row Break in Straight table

Anonymous — Fri, 13 May 2016 06:24:58 GMT

Paging function in PPT Template

Re: Row Break in Straight table

Anonymous — Fri, 13 May 2016 06:25:44 GMT

Paging function in PPT Template

Re: Row Break in Straight table

anagharao — Thu, 19 May 2016 05:13:03 GMT

Hi,

hope the attached helps.