Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ElviraD
Partner - Contributor II
Partner - Contributor II

Combine two dimensions in a pie chart

Hi everyone!

I have a question about combining dimensions in a pie chart. Can I somehow combine 2 dimensions (without combining them in the script) in order to have aggregated value for both together. For example:

Dimension1Dimension2Value
A 1
B 2
 C3
 D4

 

And I would like to have a pie chart that would have consider all A,B,C,D. Is it possible?

Thank you in advance,

Elvira

Labels (1)
1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @ElviraD 

Don't you just want to use Dimension1&Dimension2 as your dimension? For example:

PieConcat.png

Regards,

Mauritz

View solution in original post

4 Replies
Qlik1_User1
Specialist
Specialist

@ElviraD 

In Dimension try like this

=IF(Len(Dim1)>0,Dim1,IF(LEN(Dim2)>0,Dim2))

Measure SUM(Value)

Pie.PNG

OR

Pie.PNG

Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @ElviraD 

Don't you just want to use Dimension1&Dimension2 as your dimension? For example:

PieConcat.png

Regards,

Mauritz

ElviraD
Partner - Contributor II
Partner - Contributor II
Author

Thank you, Mauritz_SA !

I missed parentheses, that's why it didn't work for me 🙂 

Miles_Dyson
Contributor II
Contributor II

Thanks a lot