0 Replies Latest reply: Nov 21, 2016 11:56 AM by Liam Hanninen RSS

    List of Expressions, dtype, and Fields

    Liam Hanninen

      Apologies if this has already been answered but googling 'list expressions of a field qlik sense' returns mostly generic help pages about expressions, set-analysis, etc.

       

      I want to create a table of all fields (probably using $Field) as one column, their respective expressions in another column, and then the dtype as well.

       

      Can you recommend a way to do this?

       

      $FieldExpressiondtype
      Country_Popcounty_info.country_popint

       

      Extra Credit:

       

      We use a lot of flags such as IsNewMonth, IsActive and we have many small key-value tables such as a table with 0,1,2,3 equal to county names. I really want to make a table that lists all of these.

      FieldValue
      %OS_typeWindows, Linux, Ubuntu
      %County_ID0,1,2,3
      IsActive0,1

       

      Any direction would help!