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!