topic Grouping the records in pivot table in QlikView

Grouping the records in pivot table

sijojoseph22 — Mon, 10 Aug 2015 12:00:53 GMT

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'

Thanks,

Sijo

Re: Grouping the records in pivot table

rubenmarin — Mon, 10 Aug 2015 12:08:28 GMT

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')))

Re: Grouping the records in pivot table

maximiliano_vel — Mon, 10 Aug 2015 12:18:00 GMT

Your records should be in order.

See attached file