3 Replies Latest reply: Jun 6, 2016 9:05 AM by Sunny Talwar RSS

    Not able to remove the duplicates

    Niranjan k

      Dear Experts,

       

      Can you please help me how to remove duplicate values from Script side.

      i tried with distinct function again im getting duplicate values on dashboard.

      any suggesions

       

      LOAD Distinct

           Market_ID,

           Manuf_ID,

           Categ_ID,

           Brand_ID,

           SuBBrand_ID,

           SKU_ID,

           [Value Offtake (000 Rs.)],

           [Sales Volume (Volume (KG))],

           [Time Period],

           Corporation_Value_Sales,

           Corporation_Volume_Sales,

           Market_Value_Sales,

           Market_Volume_Sales,

           State_Corp_Value_Sales,

           State_Corp_Volume_Sales,

           State_Value_Sales,

           State_Volume_Sales,

           Brand_Value_Sales,

           Brand_Volume_Sales,

           SuBBrand_Value_Sales,

           SuBBrand_Volume_Sales,

           SKU_Value_Sales,

           SKU_Volume_Sales,

           Marketless_Value_Sales,

           Marketless_Volume_Sales,

           State_SKU_Value_Sales,

           State_SKU_Volume_Sales,

           Marketless_State_SKU_Val,

           Marketless_State_SKU_Vol,

           Ped_Val_Sal,

           Ped_Vol_Sal,

           [State Corp Val Share],

           [State Corp Vol Share],

           Record_Val_Share,

           Record_Vol_Share,

           Rank_Val,

           Rank_Vol,

           No_of_Stores,

           Num_D,

           Wtd_D,

           SAH_Val,

           Shipments_Val,

           Shipments_Vol

      FROM

      [C:\Users\Niru K\Desktop\Qlikview Project Sample\New folder\Sales_Fact.qvd]

      (qvd);

       

       

      Best Regards,

      Niranjan