2 Replies Latest reply: Dec 29, 2017 1:10 AM by Chris Wong RSS

    Qlik Sense - Reuse calculated field in the same load script

    Chris Wong

      Dear Community,

      How to reuse calculated field in the same load script?

       

      [Table]:

      LOAD

        [Invoice No]

      , [Quantity]

      , [Price]

      , [Quantity] * [Price] AS [Amount]

      , [Amount]  * {Rate] AS [GST]

      FROM [lib://Files/table.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      In the same load script, same table

      [GST] =  [Amount] * {Rate] AS [GST]

       

      instead of

       

      [GST] = ( [Quantity] * [Price] ) * {Rate] AS [GST]