Discussion Board for collaboration related to QlikView App Development.
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'
Go to Solution.
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
Your records should be in order.
See attached file