topic Re: 2 dimension under each other in QlikView

2 dimension under each other

Mizo — Tue, 06 Jul 2021 12:51:53 GMT

I have a dimension with the following date
number:
1
2
3
4
5

and another dimension with the data
Character:
A
B
C

Now I want to create both dimensions under each other and not next to each other
It must look like this

All:
1
2
3
4
5
A
B
C

Can someone help?

sergio0592 — Tue, 06 Jul 2021 13:46:20 GMT

You can do this if your dimensions comes from two differents tables. eg

TAB1: LOAD * INLINE [ Number 1 2 3 4 5 ] ; Concatenate TAB2: LOAD * INLINE [ Char A B C D];

After that, add a dimension in your chart with

=if(IsNull(Number),Char,Number)

Mizo — Tue, 06 Jul 2021 14:04:54 GMT

Hello Sergio,

Thanks for your quick support
Concatenate was the right Keyword 🙂
It works

Thanks and best regards,

Mizo

sergio0592 — Tue, 06 Jul 2021 17:42:42 GMT

No problem, happy to help community. Dont't forget to close the topic with 'Accepted as correct solution'