Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sibusiso90
Creator III
Creator III

Adding to Existing Dimension

Hi all,

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

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

Added Legand.png

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

One possible solution-way attached.

Capture.JPG

View solution in original post

4 Replies
tresesco
MVP
MVP

One possible solution-way attached.

Capture.JPG

sunny_talwar

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

1

2

];

Dimension

Sale

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

Expression

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

Capture.PNG

sibusiso90
Creator III
Creator III
Author

Thanks,

I am pleased. tresesco

sibusiso90
Creator III
Creator III
Author

stalwar1‌‌

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