Grid chart is not giving expect chart

[#1]

I have a set of data as below :

X	Y	Product	Value
X1	Y1	P1	1
X1	Y1	P10	9
X1	Y1	P2	6
X1	Y1	P3	3
X1	Y1	P4	5
X1	Y1	P5	7
X1	Y1	P6	3
X1	Y1	P7	5
X1	Y1	P8	7
X1	Y1	P9	8
X2	Y2	P1	8.8
X2	Y2	P10	14.36363636
X2	Y2	P11	14.98181818
X2	Y2	P12	15.6
X2	Y2	P13	16.21818182
X2	Y2	P14	16.83636364
X2	Y2	P15	17.45454545
X2	Y2	P2	9.418181818
X2	Y2	P3	10.03636364
X2	Y2	P4	10.65454545
X2	Y2	P5	11.27272727
X2	Y2	P6	11.89090909
X2	Y2	P7	12.50909091
X2	Y2	P8	13.12727273
X2	Y2	P9	13.74545455
X3	Y3	P1	18.07272727
X3	Y3	P10	23.63636364
X3	Y3	P11	24.25454545
X3	Y3	P12	24.87272727
X3	Y3	P13	25.49090909
X3	Y3	P14	26.10909091
X3	Y3	P15	26.72727273
X3	Y3	P2	18.69090909
X3	Y3	P3	19.30909091
X3	Y3	P4	19.92727273
X3	Y3	P5	20.54545455
X3	Y3	P6	21.16363636
X3	Y3	P7	21.78181818
X3	Y3	P8	22.4
X3	Y3	P9	23.01818182
X4	Y4	P1	27.34545455
X4	Y4	P2	27.96363636
X4	Y4	P3	28.58181818
X4	Y4	P4	29.2
X4	Y4	P5	29.81818182
X4	Y4	P6	30.43636364
X4	Y4	P7	31.05454545
X4	Y4	P8	31.67272727
X4	Y4	P9	32.29090909

I am using a grid chart extention in qlik sense desktop.

I have few requirements as below:

- few X and Y are combined to get groups,

if(&, 'X1Y1',X2Y2','X1Y1', ) then 'first'

if(&, 'X4Y1',) then 'second'

if(&, 'X2Y2',X2Y3','X2Y4','X3Y0') then 'third'

if(&, 'X4Y2',X4Y3','X4Y4','X4Y0') then 'fourth'

And these will be in X-axis

-  Y side s will be my products.

- The will be a filter for device. When I select a device I  should see all relative values to the selected device.

For the graph, i used 2 dimensions as below:

1)

If(Match(&,'X1Y1',X2Y2','X1Y1''),'first',

If(Match(&, 'X4Y1',),'second',

If(Match(&,X2Y2',X2Y3','X2Y4','X3Y0' ),'third',

If(Match(&', 'X4Y2',X4Y3','X4Y4','X4Y0 ),'fourth','fourth')

)))

2) Product

And my dimension is

Sum({<Product,X,Y>Value})  / Sum({<Product={'$(=only(Product))'}>} TOTAL <X,Y> Value)

But I chart is only showing values for third and fourth when selecting a product(I think, showing me overall relative value).

One wired thing is when I am selecting a group('first'/'second'/'third'/'fourth') then I can see the proper value

Please help me out to solve the problem.

Thanks & Regards,

Juthika