List of Expressions, dtype, and Fields

liam_hanninen — Mon, 21 Nov 2016 16:56:03 GMT

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?

$Field	Expression	dtype
Country_Pop	county_info.country_pop	int

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.

Field	Value
%OS_type	Windows, Linux, Ubuntu
%County_ID	0,1,2,3
IsActive	0,1

Any direction would help!

topic List of Expressions, dtype, and Fields in App Development

List of Expressions, dtype, and Fields