Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Unique Row Count

Hi There

I am looking to get a unique row count per calculated dimension in a Pivot Table

This is how I want the data to be represented

I have attached the raw data

Period, Row Number

Innings.1      1

                     2

                     3

                     4

Innings. 2     1

                     2

                     3

                     4

                     5

                     6

Innings. 3     1

                     2

                     3

Thanks

Tags (1)
1 Solution

Accepted Solutions
nilesh_gangurde
Valued Contributor

Re: Unique Row Count

Please find attached qvw file.

Regards,

Nilesh

6 Replies
balrajahlawat
Esteemed Contributor

Re: Unique Row Count

What issue you are facing while doing same??

Not applicable

Re: Unique Row Count

Hi Balraj

Thank you for your response

I want to know the number of rows per innings and not the total row count

I get the data as follows in the Pivot Table

Period, Row Number

Innings.1      1

                     2

                     3

                     4

Innings. 2     4

                     5

                     6

                     7

                     8

                     9

Innings. 3     10

                     11

                     12

MVP
MVP

Re: Unique Row Count

Have you tried RowNo()?

nilesh_gangurde
Valued Contributor

Re: Unique Row Count

Please find attached qvw file.

Regards,

Nilesh

Not applicable

Re: Unique Row Count

Thank you Nilesh

It works

Much appreciated

nilesh_gangurde
Valued Contributor

Re: Unique Row Count

Please mark the post as answered.

Regards,

Nilesh

Community Browser