Show the row number of a table in a text box

[#1]

Good morning, I would write in a text box ne number of line that I have in a table.

The number of lines that I have in the table depends on the selections made via the list boxes on the worksheet.

The table that I use is a simple table.

It contains only dimensions and no expressions.

Can someone help me ?

Regards

[swuehl]

Try

=Count(DISTINCT [Codice Client] & [Business Partner])

[mkelemen]

I think I understand what is the problem...

You need to count distinct rows. There might be a more elegant solution but this works for me - you need to concatenate all the dimensions used in the table and use Distinct

=Count (Distinct Dimension1 & Dimension2 & ...)

BR,

  Matus

[#4]

Ok, if I use this script in the text box I obtain the total number of rows.

But If I use the selectors presents in the sheet that could change the number of row, the number in the text box doesn't change.

[#5]

Ok, Iìve found the problem.

I used the alternate status but there was a problem with a name.

Thanks for the solution to everybody.

Thanks a lot.

[sunny_talwar]

Awesome

Please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[handry_orozco]

Hi Giovanni

Try this function

GetPossibleCount

GetSelectedCount

Bye

[petter]

They are bound to work - I have used this extensively and tested even in a real application before I posted the suggestions. It is important that you replace the UniqueID field name in my suggestion or the "TableName" in the second suggestion with an actual field name in your data model.

[craigsutton]

Thanks, this worked well for me!