topic Re: count rows displayed in QlikView

count rows displayed

Thu, 24 Apr 2014 21:14:00 GMT

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!

swuehl — Thu, 24 Apr 2014 21:17:17 GMT

Maybe something like

=COUNT(TOTAL<Material> DISTINCT Orden)

Fri, 25 Apr 2014 13:29:02 GMT

It worked fine.

Thanks for your support!

Fri, 25 Apr 2014 13:49:24 GMT

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

Fri, 25 Apr 2014 13:51:31 GMT

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

Fri, 25 Apr 2014 14:53:10 GMT

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

Fri, 25 Apr 2014 15:05:00 GMT

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

Fri, 25 Apr 2014 15:16:37 GMT

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

Fri, 25 Apr 2014 15:26:02 GMT

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

Fri, 25 Apr 2014 15:35:01 GMT

Great Brian, thank you very much!