2 Replies Latest reply: Aug 28, 2018 4:57 PM by JINHUA HUANG RSS

    Plain table that you can program/hard code each cell

    JINHUA HUANG

      is there a plain table object in qlik sense that i can program or hard code each cell value rather than using the dimension, column and measures etc?

      for example a table like this:

       

      hard-coded headerhard-coded header
      hard coded row name: "total value"select sum(value) from table1
      hard coded row name: "value change"select sum(value) - sum(value_base) from table1
      hard coded row name:  "percentage value change"
      select (sum(value) - sum(value_base))/sum(value_base) from table1

       

      table1 is a sql table.

       

      thanks