topic Re: Dynamic Columns in App Development

Dynamic Columns

alexsid-qlik — Sat, 16 Nov 2024 19:52:43 GMT

Dear Community,

I am currently testing a functionality for my dashboard. The goal is to let the user choose columns that the user wants to see in a table. A very basic demand but still I struggle.

I show available columns with a Filter Pane with $Field as dimension.

And then I have a table where I use the Show condition with this formula < if(GetFieldSelections($Field) like '*Car*',1,0) >.

Now I have a lot of columns and want to make the part < like '*Car*' > not static but dynamic.

Any ideas how to achieve that? Looking forward to your ideas 🙂

Cheers, Alex

Re: Dynamic Columns

sunny_talwar — Thu, 17 Oct 2019 14:20:14 GMT

but this is show column if condition for a already known dimension... what difference would it make if you change the condition from static car to something dynamic?

Re: Dynamic Columns

alexsid-qlik — Thu, 17 Oct 2019 14:26:23 GMT

Thanks for your reply.

Some more info on that topic:

I want to have a condition formula where I do not have to specifiy the column name.

So I have a dimension Car, Cost, Type and I would need 3 different formulas. But is it possible to have one formula for all column show conditions?

Cheers, Alex

Re: Dynamic Columns

sunny_talwar — Thu, 17 Oct 2019 14:29:56 GMT

You want to use a single formula for all three dimensions? But this same formula will be repeated three times for each of the three expressions, right? I don't think you can create a single formula which can be copy pasted for each expression... something will need to tell it that if it is cost or car or type dimension

Re: Dynamic Columns

alexsid-qlik — Fri, 18 Oct 2019 07:31:32 GMT

Thank you Sunny.

I really thought it would be possible to have one formula for all columns. I thought about using some kind of identifier for the column "ColumnNo()" based on the "RowNo()" the same field has in the "$Field" Table. But I dont know if that approach works.

Re: Dynamic Columns

sunny_talwar — Fri, 18 Oct 2019 10:31:23 GMT

You might be able to employ GetObjectField , but even with that, you will need to specify which field you want to look into? like for first dimension it would be

$(='[' & GetObjectField(0) & ']')

and for second dimension it would be

$(='[' & GetObjectField(1) & ']')

So, even with this solution you cannot just blindly copy paste the expression across your dimensions.