topic Re: How to apply row restriction in straight table in QlikView

How to apply row restriction in straight table

vipingarg23 — Wed, 22 Nov 2017 14:02:57 GMT

Hi Team,

How to limit number of rows in Straight table?

I am using Dimension limit and Max rows (In Presentation tab) but both are not working.

Re: How to apply row restriction in straight table

sunny_talwar — Wed, 22 Nov 2017 14:05:35 GMT

May be you can try with RowNo(). For example if you want to only see first 10 rows, you can do this If(RowNo(TOTAL) < 11, your expression)... Notice that this will show top 10 in the order you already have in your chart

Re: How to apply row restriction in straight table

avkeep01 — Wed, 22 Nov 2017 14:10:27 GMT

Is the object attached? Does the caption text shows "<Name> (Detached)"?

Re: How to apply row restriction in straight table

vipingarg23 — Wed, 22 Nov 2017 14:11:30 GMT

Thanks Sunny,

I knew this but I have lot of expressions So I have to apply the same in each expression. Don't we have any direct method in Qlikview So that I can apply the same for all.?

Re: How to apply row restriction in straight table

sunny_talwar — Wed, 22 Nov 2017 14:12:25 GMT

Direct method is Dimension limits or calculated dimension, but without more details, I won't know what to do

Re: How to apply row restriction in straight table

vipingarg23 — Wed, 22 Nov 2017 14:12:41 GMT

Yes..It is attached.

Re: How to apply row restriction in straight table

vipingarg23 — Wed, 22 Nov 2017 14:14:26 GMT

I am creating Adhoc report. In which, I want that user can see only 40000 rows, not more than that.

Re: How to apply row restriction in straight table

avkeep01 — Wed, 22 Nov 2017 14:17:22 GMT

It is not the perfect solution but I sometimes forces the users making more selections to reduce the amount of rows by using the calculation condition on the General sheet in the straight table. If the amount of rows is higher then 400.000 then the message: "Make more selections to reduce the amount of rows " is shown.

Re: How to apply row restriction in straight table

sunny_talwar — Wed, 22 Nov 2017 14:17:40 GMT

How many expressions do you have?

Re: How to apply row restriction in straight table

vipingarg23 — Wed, 22 Nov 2017 14:19:59 GMT

Around 45 expressions

Re: How to apply row restriction in straight table

vipingarg23 — Wed, 22 Nov 2017 15:08:20 GMT

Somehow you are correct.

Re: How to apply row restriction in straight table

vipingarg23 — Wed, 22 Nov 2017 15:17:14 GMT

But to do the same, I have to aggr function with Rowno(TOTAL) in calculated condition, Right? Direct rowno(TOTAL) won't work?

Re: How to apply row restriction in straight table

avkeep01 — Wed, 22 Nov 2017 15:27:16 GMT

I think you'll need to count the dimension fields. I mean the number of values in the dimension field should be less then 400.000.

Let say that the dimension is Item Number, then I would use COUNT([Item Number} <= 400.000 in the calculated condition.

I don't have enough information to figure out what ROWNO(TOTAL) does. Probably it just shows 1 as a value when you just paste it in a text box.

Re: How to apply row restriction in straight table

sunny_talwar — Wed, 22 Nov 2017 15:37:16 GMT

I would say that adding If(RowNo(TOTAL) < 400000, Your expression), should not be a humongous task to get the functionality you are looking for... because I can't think of another way to do this.

Best,

Sunny

Re: How to apply row restriction in straight table

vipingarg23 — Thu, 23 Nov 2017 08:50:08 GMT

Hi,

Is it possible to count total number of rows in straight table? If I simply put rowno() In Expresssion, It is giving me right data But I want Count of Total rows as a whole in Text box or In Caption? I tried Rowno(TOTAL) but it is not working..

Re: How to apply row restriction in straight table

sunny_talwar — Thu, 23 Nov 2017 23:15:36 GMT

It can be done, it would help to see an example of what exactly you have.... Also, it seems that you have closed this thread... are you still looking for help or are you good to go now...

Re: How to apply row restriction in straight table

vipingarg23 — Fri, 24 Nov 2017 07:12:04 GMT

Yes..I am still looking for help. Please find the attached sample.

In this sample I want total number of rows in text box Means Here, I have 3 rows, So I want 3 as a result in text box or in Caption?

Re: How to apply row restriction in straight table

avkeep01 — Fri, 24 Nov 2017 10:39:07 GMT

Hi Vipin,

ROWNO(TOTAL) is working because it is in the table. and basically it just counts de distincts of field and where a value exists and shows the highest of them. So to reproduce ROWNO(TOTAL) in a seperate textbox you could use:

IF( COUNT(DISTINCT ) > COUNT(DISTINCT ) , COUNT(DISTINCT ), COUNT(DISTINCT ))

That is of course a bit overdone in this case so COUNT(DISTINCT ) should be sufficient.

If field is already distinctive then you better should use COUNT(), because the distinct calculation is done over 1 processor and is therefore slower.

Re: How to apply row restriction in straight table

sunny_talwar — Fri, 24 Nov 2017 12:54:36 GMT

You can use this

=Max(Aggr(NoOfRows(TOTAL), A, B))

Re: How to apply row restriction in straight table

sunny_talwar — Fri, 24 Nov 2017 12:58:48 GMT

For the sample Count(DISTINCT A) might work, but since there are two dimensions, you might have a scenario like this

A B

1 2

1 6

2 6

3 7

Count(DISTINCT A) = 3, where the actual count needed is 4. So, in this case, it might make sense to count distinct of A&B

Count(DISTINCT A&B)

But you might need to add any set analysis you have in your expression... which would make it look like this

Count(DISTINCT {<SetAnalysis>} A&B)

The problem is that until and unless you share an example which is very close to the actual scenario, all our responses are going to be fairly generic and unusable for you...

Qlik Community Tip: How to Get Answers to Your Post

Preparing examples for Upload - Reduction and Data Scrambling