5 Replies Latest reply: Apr 6, 2012 4:22 AM by Jason Michaelides RSS

    Key Brands Availability Comparision of LM vs L3M

    Qlikview Baru

      Hello All,

       

      My requirement is to show the ''Key Brands Availability Comparision of LM vs L3M'' i am having different products,this should be shown in pivot table for example like this..

      Key Brands Availability Comparision of LM vs L3M
      product1product1product3product4product5product6product7product8product9product10product11product12product13product14
      65.20%12.70%33.40%47.60%15.50%1.50%2.10%40.50%61.80%0.50%4.00%13.40%0.10%0.40%
      95.80%71.20%52.70%40.80%77.30%35.00%31.20%
      99.00%97.40%83.70%75.60%78.80%
      100.00%64.80%1.10%27.30%92.00%4.50%17.00%
      95.00%61.50%25.70%36.90%57.50%0.60%0.60%
      88.60%0.30%98.70%94.90%27.30%96.60%96.60%0.30%29.30%13.80%
      30.90%98.90%77.70%30.90%91.60%87.70%6.10%2.20%
      13.20%95.00%43.00%2.50%76.00%90.10%2.50%
      20.60%99.50%48.60%9.30%86.00%80.40%
      93.80%61.10%10.60%54.00%80.50%3.50%
      92.70%16.80%71.10%41.70%51.70%11.20%11.40%
      97.00%34.70%61.00%71.20%97.50%14.60%41.10%
      57.80%10.20%24.00%20.00%96.00%25.00%11.00%
      56.60%29.20%92.50%8.50%37.70%
      91.00%97.70%5.20%93.90%50.40%79.70%49.30%5.50%0.60%7.80%9.30%
      80.30%87.70%0.20%97.60%4.30%4.30%0.30%2.10%
      49.30%90.70%60.10%14.20%35.40%0.30%2.90%
      50.30%59.50%16.70%0.20%32.10%36.10%0.40%0.90%
      66.60%31.80%31.00%0.80%16.30%22.80%2.20%3.30%
      89.50%82.50%59.70%85.30%0.70%63.70%63.90%0.40%5.60%

      can any one know how to get this type in pivot table.i am writing the expression but it is not getting the correct value.

      Regards,

      bar