Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Row limit through user input variable in striaght table

Dear Team,

I have one straight table chart showing detailed CALLFAULT information of various dimension  .Because of huge number of rows we would like to limit no od rows in straight table chart by using an inout box variable .

We would like to achieve that limitation but unable to get the idea of how to resolve.Can you please guide me .

See below this is what :

Can you please advise how can I limit rows based on user input directly on GUI ?

I have used DIMENSION LIMIT BUT IT DOES NOT WORK WITH SO MANY DIMENSION?

PLEASE HELP

4 Replies
Master II
Master II

Re: Row limit through user input variable in striaght table

One way to limit the number of rows is to hide the chart unless the row count is less than some preset value.
A text box can be used to tell the user that the chart will be visible when they make selections that result in less than the preset row limit.

Highlighted
Partner
Partner

Re: Row limit through user input variable in striaght table

Dear ,

There is already one limitation in charts display to select at least one RNC FOR charts to display.

What we need is to control the row limit  on straight table through user input Variable .

Please advise.

Highlighted
Partner
Partner

Re: Row limit through user input variable in striaght table

Dear Team,

Can you please advise ?

Highlighted
Specialist III
Specialist III

Re: Row limit through user input variable in striaght table

Hello Avinash,

Trust that you are doing great!

Please follow below steps to restrict the no. of records present in straight table based on value of input box variable:

1. Select the Chart Properties of straight table for which we have to apply this restriction

2. Locate the presentation tab

3. Tick the Max Number (1-100) check box and mention variable name in next text box (in my case I have written =vStep ). This setting will denotes the maximum number of rows to be displayed.

4. Click OK.

Hope this will be helpful.

P.S.: Please specify the correct sort order to get desired results.

Regards!

Rahul