Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sijojoseph22
Contributor

Grouping the records in pivot table

Hi All,

We are having 15 records in the attached qvw.

We need to make the  as per the screen shot. We need this to generate a report in Nprinting.
1-5 records as value 'First Five'
  6-10 records as value 'Second Five'
11-15 records as value 'Third Five'

image 2.png

Thanks,

Sijo

1 Solution

Accepted Solutions

Re: Grouping the records in pivot table

Hi Sijo, you can use this expression:

=If(RowNo(TOTAL)<=5, 'First five',

  If(RowNo(TOTAL)<=10, 'Second five',

   If(RowNo(TOTAL)<=15, 'Third five')))

View solution in original post

2 Replies

Re: Grouping the records in pivot table

Hi Sijo, you can use this expression:

=If(RowNo(TOTAL)<=5, 'First five',

  If(RowNo(TOTAL)<=10, 'Second five',

   If(RowNo(TOTAL)<=15, 'Third five')))

View solution in original post

Highlighted
Partner
Partner

Re: Grouping the records in pivot table

Your records should be in order.

See attached file