0 Replies Latest reply: Jul 18, 2016 4:50 PM by juthika dash RSS

    Grid chart is not giving expect chart

    juthika dash

      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([X]&[Y], 'X1Y1',X2Y2','X1Y1', ) then 'first'

      if([X]&[Y], 'X4Y1',) then 'second'

      if([X]&[Y], 'X2Y2',X2Y3','X2Y4','X3Y0') then 'third'

      if([X]&[Y], '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([X]&[Y],'X1Y1',X2Y2','X1Y1''),'first',

      If(Match([X]&[Y], 'X4Y1',),'second',

      If(Match([X]&[Y],X2Y2',X2Y3','X2Y4','X3Y0' ),'third',

      If(Match([X]&[Y]', '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