topic Re: Set analysis in chart in QlikView

Set analysis in chart

Mon, 11 Feb 2013 18:09:59 GMT

I need to have a set analysis function based on the dimension of the chart. I tried this and does not seem to work.

first column - CC is my dimension.

I have added 3 expression columns to make my question clear.

On row for CC 269, i was expcting column 4 to have 6457.182.

Please help!

Re: Set analysis in chart

jagan — Mon, 11 Feb 2013 18:32:47 GMT

Hi,

Try using this with Aggr(). try this expression

=Sum(Aggr(If(CCSPONSOR1 = [CC], Sum(ACTUALMANWEEKS), 0), CCSPONSOR1))

Hope this helps you.

Regards,

Jagan.

Re: Set analysis in chart

Gysbert_Wassenaar — Mon, 11 Feb 2013 18:35:04 GMT

Set analysis expressions are evaluated per chart, not per row. So you can't use CC both as dimension in your chart and in your set analysis expression. You'll have to use hardcoded values or if statements. See here for more information.

Re: Set analysis in chart

Mon, 11 Feb 2013 19:10:14 GMT

Hi Jagan,

No, that did not work. It gave exact same result as

=sum({1<CCSPONSOR1=CC>} ACTUALMANWEEKS)

Thanks

Re: Set analysis in chart

Mon, 11 Feb 2013 19:25:35 GMT

Thanks!