topic Re: Total for and Expression in QlikView

Total for and Expression

Sat, 07 Jul 2012 01:34:03 GMT

Hi there, I managed to create an expression that identifies the excess area within a set of buildings.

I would like to create the total for the buildings that are identified as in excess of the target I have set.

This is the chart the expression creates

If([Area Sqft]<SUM(Seats*AreaPerSeat),0,[Area Sqft]-SUM(Seats*AreaPerSeat))

I would like to create a Text Object that displays the total value of all the excess space identified in the expression.

Appreciate any support or ideas.

Thanks

Rob

jonathandienst — Sat, 07 Jul 2012 07:34:14 GMT

Rob

I cant't see your chart, so I don't know what dimension(s) it used, but you can use something like this outside of your chart:

Sum(Aggr(If([Area Sqft]<SUM(Seats*AreaPerSeat),0,[Area Sqft]-SUM(Seats*AreaPerSeat)), Dimension1, Dimension2))

Just replace Dimension1, Dimension2 with the chart dimension (actually any field in your model)

Hope that helps

Jonathan

Sat, 07 Jul 2012 16:51:44 GMT

Jonathan, that did it - brilliant!.

Thanks for your help.

Rob