8 Replies Latest reply: Apr 13, 2011 1:31 PM by Carlos Ayuso RSS

    How do you filter the data you want to charge in Qlik??

    Carlos Ayuso

      Hi,

      I have the following in my initial script,

      LOAD Año,

      Mes,

      Materiale,

      [Qtà stk. val.],

      [Valore stk. v.]

      FROM

      [O:\Logistic\TEMAS STOCKS\INVENTARIOS\Informes mensuales\Informes Qlik\Informe Stocks 6A*.xlsx]

      (ooxml, embedded labels, table is [Inventario mes]);

      My intention is to charge only the Data that stisfies an expression such as:

      [([Qtà stk. val.]!=0) & ([Valore stk. v.]!=0)]

      How should i change the script to make Qlikview load ONLY the Data that satisfy the expression??

       

      Thanks a lot for your time!!!!!!!