Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count rows displayed

I´m trying to count the rows displayed for each value of a column.

I´ve used both rowno(total) and rowno() however none of them gave me the amount of rows displayed for each "Material" column

I need to use the displayed value, because the cardinallity of the data doesn´t allow me to use count()

How can I solve it? 

Thanks in advance!

Captura.PNG.png

9 Replies
swuehl
MVP
MVP

Maybe something like

=COUNT(TOTAL<Material> DISTINCT Orden)

Not applicable
Author

It worked fine.

Thanks for your support!

Not applicable
Author

Can I assign a number of row that starts with every new Material?

Not applicable
Author

Can I assign a number of row that starts with every new Material?

Not applicable
Author

Rank(-Orden)  should do it as long as you maintain the sort order the way that you have it.

Not applicable
Author

Brian, I´ve tried but it returns allways 1.

Not applicable
Author

What I´m trying to do is to apply a formula for the first record of each material and another for the rest.

Not applicable
Author

If(Orden=Min(Total<Material> Orden),'Formula One','Formula Two')

Best Practice would be to make sure you use an aggregation function like Sum(...), or Only(...) around all that.

- Brian

Not applicable
Author

Great Brian, thank you very much!