7 Replies Latest reply: May 4, 2015 3:24 PM by chillara chillara RSS

    Variables in Inline table in qlikview table using let function

      Hi,

       

      I have a requirement to show the max of the percent calculated in variables to display using inline tables.

      The max of value can change based on the data, hence using variables.

      Inline is used as the fields are adhoc.

       

      Attached is the qlikview file for reference.

       

      Let   vsales1    = $(value1) ; (where value1 = max(Percent,1))

      Let   vsales2    = $(value2) ; (where value2 = max(Percent,2))

       

      Percent:

      LOAD fact_key,

           account,

           Percent

      FROM

      [C:\Desktop\fact.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      Sales:

      Load * Inline [

      id@ sales

      aabb1@ sales value is $(vsales1)

      aabb2@ sales value is $(vsales2)

      aabb3@ sales values is null

      ](delimiter is '@');

       

      the expected result :

      expected result.png

       

      the actual result :

      actual result.png

       

       

      Thanks for your replies! !