How to apply row restriction in straight table

[vipingarg23]

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.

[vipingarg23]

Somehow you are correct.

[vipingarg23]

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

[avkeep01]

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.

[sunny_talwar]

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

[vipingarg23]

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..

[sunny_talwar]

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...

[vipingarg23]

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?

[avkeep01]

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...

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.

[sunny_talwar]

You can use this

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

[sunny_talwar]

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