2 Replies Latest reply: Aug 18, 2017 7:32 AM by Amien Amien RSS

    can i create a straight table in Sense with no dimensions?

    Amien Amien

      In QlikView i can create a straight table without any dimensions. I do this to show the measures vertical instead of horizontal.

       

      So the straight object will look like this:

       

      dim1: no dimensions

      exp1 : sum(Sales). Label : Sales

      exp2 : sum(Margin), Label : Margin.

       

      my straight table would look like this:

       

      Sales           100

      Margin         10

       

      I could make it work in sense when i create a data island table with all the needed measure labels, and use the PICK function to calculate the needed value on the specific row. But this is kind of nasty and will become quite a big formula. Plus i can't use the MasterItems.

       

      Anyone got a better solution?