# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for
Did you mean:
Partner

## Add a column dimension return"Invalid Dimension"

I need your help and advice. I would like to add a  column dimension in a table in Qliksense  that show Grade as you can see om expect result.

1  1  A  11

1  2  B  30

1  3  C  30

2  1 D  40

2  3  C  10

2  2 B  40

3 1  A  10

4 1  B  10

This is my expect result.

1   30       3         2      B

2   40     3           1     D

3     10    1           1     A

4   10     1            1    B

I try to  use this expression  when I add a column dimension but I get "Invalid Dimension"

I also try to use

Regards

Nudjaree

Labels (2)

• ### Set Analysis As A Dimension

2 Solutions

Accepted Solutions
MVP

Try like below

LOAD *, RowNo() as Row INLINE [
1,1,A,11
1,2,B,30
1 ,3 , C, 30
2, 1, D, 40
2, 3, C, 10
2, 2, B, 40
3, 1, A, 10
4, 1, B, 10
];

Dim / Measure

=Aggr(Only({<Row = {\$(=Concat(Aggr(Min(Aggr(if(Value=max(Total <ID> Value),Row),ID, NO)), ID),','))}>}Grade), ID, NO)

Thanks & Regards,
Mayil Vahanan R
Partner
Author

@MayilVahanan It works. 🙂 Thank you very much.

7 Replies
Creator II

May be something like this

might be you are adding as dimension. You should add as measure not dimension.

Great dreamer's dreams never fulfilled, they are always transcended.
Partner
Author

Thank you for your answer but I get "-" when I create measure with this expression.

Partner
Author

Yes, I added measure  as well but I dont have the correct expression.

MVP

Try like below

LOAD *, RowNo() as Row INLINE [
1,1,A,11
1,2,B,30
1 ,3 , C, 30
2, 1, D, 40
2, 3, C, 10
2, 2, B, 40
3, 1, A, 10
4, 1, B, 10
];

Dim / Measure

=Aggr(Only({<Row = {\$(=Concat(Aggr(Min(Aggr(if(Value=max(Total <ID> Value),Row),ID, NO)), ID),','))}>}Grade), ID, NO)

Thanks & Regards,
Mayil Vahanan R
Partner
Author

@MayilVahanan It works. 🙂 Thank you very much.

MVP