Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Grid chart is not giving expect chart

I have a set of data as below :

XYProductValue
X1Y1P11
X1Y1P109
X1Y1P26
X1Y1P33
X1Y1P45
X1Y1P57
X1Y1P63
X1Y1P75
X1Y1P87
X1Y1P98
X2Y2P18.8
X2Y2P1014.36363636
X2Y2P1114.98181818
X2Y2P1215.6
X2Y2P1316.21818182
X2Y2P1416.83636364
X2Y2P1517.45454545
X2Y2P29.418181818
X2Y2P310.03636364
X2Y2P410.65454545
X2Y2P511.27272727
X2Y2P611.89090909
X2Y2P712.50909091
X2Y2P813.12727273
X2Y2P913.74545455
X3Y3P118.07272727
X3Y3P1023.63636364
X3Y3P1124.25454545
X3Y3P1224.87272727
X3Y3P1325.49090909
X3Y3P1426.10909091
X3Y3P1526.72727273
X3Y3P218.69090909
X3Y3P319.30909091
X3Y3P419.92727273
X3Y3P520.54545455
X3Y3P621.16363636
X3Y3P721.78181818
X3Y3P822.4
X3Y3P923.01818182
X4Y4P127.34545455
X4Y4P227.96363636
X4Y4P328.58181818
X4Y4P429.2
X4Y4P529.81818182
X4Y4P630.43636364
X4Y4P731.05454545
X4Y4P831.67272727
X4Y4P9

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

Tags (1)
Community Browser