topic Dimensions with calculation and group in QlikView

Dimensions with calculation and group

Mon, 17 Oct 2011 12:21:04 GMT

Hi,

Can anyone think of a solution for the scenrio below:

I need the expression [ =sum(aggr(sum(Distinct DOW), WSID)) ] for the dimension CLNO - 17 to indicate 44 and not 0 (zero) ((before actually selecting the dimension CLNO - 17)). You will notice if you do select the item CLNO-17 the correct number (44) appears in the expression column.

(This is only possible to demo in the attached file .... )

I think it's a grouping problem that I can't get around, and I can't think how to do it any other way.

Has anyone got any ideas on how to solve, if possible? Maybe using a different chart type etc...

Thanks

Dimensions with calculation and group

swuehl — Mon, 17 Oct 2011 12:25:00 GMT

Add a NODISTINCT like in:

= sum(aggr(NODISTINCT sum(Distinct DOW ), WSID ))

Hope this helps,

Stefan

Re: Dimensions with calculation and group

Mon, 17 Oct 2011 12:31:00 GMT

Unfortunately that didn't work. It nulls the expression column and displays 0 (zero) for both CLNO 14 and 17.

It should show (looking at the inline table in the qvw attached) both 44 in both cases.

It is really strange that it will show 44 in the expression cloumn once the CLNO 17 has been selected.

Something with the grouping is producing strange results. Cheers anyway.

UPDATE: in correct reply the solution does work.

Re: Dimensions with calculation and group

swuehl — Mon, 17 Oct 2011 12:35:39 GMT

Hm, it works on my side, please check attached.

Alternatively, you could try using

= sum(aggr( sum(Distinct DOW ), WSID, CLNO))

Stefan