topic Re: Row limit through user input variable in striaght table in QlikView

Row limit through user input variable in striaght table

aj0031724 — Tue, 07 Mar 2017 13:00:42 GMT

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

Re: Row limit through user input variable in striaght table

m_woolf — Tue, 07 Mar 2017 14:08:37 GMT

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.

Re: Row limit through user input variable in striaght table

aj0031724 — Wed, 08 Mar 2017 12:38:08 GMT

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.

Re: Row limit through user input variable in striaght table

aj0031724 — Thu, 09 Mar 2017 09:04:42 GMT

Dear Team,

Can you please advise ?

Re: Row limit through user input variable in striaght table

rahulpawarb — Thu, 09 Mar 2017 09:21:52 GMT

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