Count times unique values appear in two different columns and display them in a horizontal bar graph

[vrrosales]

Hello Qlik community!

I want to count the unique times a cell value is present in two different columns and display them in a bar chart.

I'll try to illustrate what I need as best as possible below.

An example:

ID	ColumnA	ColumnB
1	A	B
2	B	C
3	C	A
4	C	D
5	D	A
6	A	B
7	C	B
8	A	C
9	B	C
10	A	C

I need the bar graph to display the following:

C = [xxxxxxx]7

A = [xxxxxx]6

B = [xxxxx]5

D = [xx]2

What is the code that should be added to Dimensions and Measurements?

Thanks!

Ps. [xxxxxx] are meant to illustrate the bars 🙂