Combine two dimensions in a pie chart

[ElviraD]

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:

Dimension1	Dimension2	Value
A		1
B		2
	C	3
	D	4

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

[Qlik1_User1]

@ElviraD 

In Dimension try like this

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

Measure SUM(Value)

OR

[Mauritz_SA · Accepted solution]

Hi @ElviraD 

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

Regards,

Mauritz

[ElviraD]

Thank you, Mauritz_SA !

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

[Miles_Dyson]

Thanks a lot