is it possible to make chart from two tables

[sakshi_jain]

Hello community,

I don't know whether this type of chart is possible to make in Qlik sense or not.Please help me to build the alternate type of chart if this isn't possible to make. Let me know how to set these dimensions values in the chart.

Image provided below.

Thank You

[Lisa_P]

Try using a combo chart with Priorite as dimension, then whatever is on your Y axis as a measure represented by a marker. What do the colors represent ?

[sakshi_jain]

Thanks I  have made the chart but unable to set color. Color represents categories. I tried to set expression in scatter plot but doesnt get any result.

As I am unable to add multiple if conditions like if category =0 then red, if category =1 then blue and so on...

I used this expression and it doesnt seems to work

if(category ='1',Orange()),
if(category ='2',Yellow()),
if(category ='3',Green()),
if(category ='4',Blue())

[StarinieriG]

Hi, 

have you tried to create a master dimension and set the color inside that?

[kaanerisen]

You can try this:

Pick(match(category),Orange(),Yellow(),Green(),Blue())

[puneetagarwal]

Hi Sakshi,

Create a master dimension and call that dimension in your chart and you will get the desired color for the chart.

Note: Also check in the colors and legend tabs, Persistent color check box should be enabled.

Regards,
Puneet Agarwal

[sakshi_jain]

Thanks to all !!

Can we open a popup on click of bubble in scatter chart and can redirect it to any webpage ?