topic Re: Aggr function in QlikView

Aggr function

Anonymous — Sun, 07 May 2017 05:46:58 GMT

I want to create the paging no. for each name present in dept.

page no. will be created after every 4 name in a dept ,but I dnt want to use name as dimension

I have used Ceil(Aggr(RowNo(),name)/4)

as expression but it will not work if I remove the name from the dimension it generate a blank valie

Re: Aggr function

MK_QSL — Sun, 07 May 2017 07:57:49 GMT

Go to presentation tab

Selection Name

and Hide column

Re: Aggr function

Anonymous — Mon, 08 May 2017 09:38:00 GMT

dnt want to hide the field

Re: Aggr function

Anil_Babu_Samineni — Mon, 08 May 2017 09:47:27 GMT

Check this?

Re: Aggr function

Kushal_Chawda — Mon, 08 May 2017 10:09:05 GMT

if you don't want to remove the field from dimension, then why you are removing? If you don't want name as dimension then just hide it as suggested by Manish