topic Please, I need support to aggr function in QlikView

Please, I need support to aggr function

Thu, 17 Nov 2011 16:38:53 GMT

Hi,

I'm using the aggr function and I don't know if I'm right.

My problem is that I have a table with lines (linea) and profiles (perfil) with their manufacturing forecast (Sum1), but I must divide the forecast between the number of lines of the same profile. I use the aggr function to obtain the number of lines of every profile, but this number only appears in the first row that the profile appears. I need to obtain this number every time.

For example:

I need that number 4 repeats at lines L3, L4 i L5 to divide 180 every row of MB1881XT profile.

Thanks for your help.

Please, I need support to aggr function

swuehl — Thu, 17 Nov 2011 16:44:18 GMT

Try a NODISTINCT qualifier

aggr(NODISTINCT count(distinct Linea), Perfil)

Hope this will help you

Stefan

Please, I need support to aggr function

swuehl — Thu, 17 Nov 2011 16:47:03 GMT

I think this might work as well, without aggr() function needed:

= count(total<Perfil> distinct Linea)

Please, I need support to aggr function

Thu, 17 Nov 2011 16:51:39 GMT

Your answers are correct (and really fast). Thank you very much!!!