topic Adding to Existing Dimension in QlikView

Adding to Existing Dimension

sibusiso90 — Mon, 13 Nov 2017 09:48:20 GMT

Hi all,

I am trying to add a new value in an existing dimension, I initially have this.

I want to have an extra Bar called group avg in all the sales column.

Please see the attached qvw to understand the situation better and I am source the way I have it in the back end.

tresB — Mon, 13 Nov 2017 12:25:42 GMT

One possible solution-way attached.

sunny_talwar — Mon, 13 Nov 2017 13:03:14 GMT

Another option is to use CrossTable Load like this

Sale:

CrossTable(Sale, Value)

LOAD * INLINE [

Groups, Sale1, Sale2, Sale3, Sale4, Sale5

Group1, 0.79759424, 0.09878233, 0.274495397, 0.283752506, 0.077262074

Group2, 0.572974879, 0.037239144, 0.021465945, 0.838789364, 0.160991477

Group3, 0.750333678, 0.204238937, 0.239284092, 0.631995441, 0.698577191

Group4, 0.751788678, 0.073845562, 0.418150331, 0.338250451, 0.611715877

];

And then add an Island Table like this

Dim:

LOAD * Inline [

Dim

];

Dimension

Sale

=Pick(Dim, Groups, 'Group Avg')

Expression

=Pick(Dim, Sum(Value), Avg(Value))

sibusiso90 — Mon, 13 Nov 2017 13:04:38 GMT

Thanks,

I am pleased. tresesco‌

sibusiso90 — Mon, 13 Nov 2017 13:09:58 GMT

Welcome back, it's been a while since I saw you active on community.