topic Re: Add column to table as on-demand in App Development

Add column to table as on-demand

jpjust — Fri, 04 Jun 2021 18:28:38 GMT

Hi All,

I use qliksense.

I have an long table with many columns which don't fit into one page.

Is there a way that we can have users (analyzers) pick themselves add / remove columns to the table according to their needs? I used to see this in qlikview with some marco code some thing like that..

Thanks

Re: Add column to table as on-demand

rubenmarin — Sat, 05 Jun 2021 08:42:54 GMT

Hi, you can create a column selector something like:

LOAD * Inline [ IdColumn, Column 11,Column1Title 12,Column2Title ... ];

And use the show condition of each expression like:

Index(Concat(IdColumn,','),'11') //For column 1 Index(Concat(IdColumn,','),'12') //For column 2

Re: Add column to table as on-demand

jpjust — Mon, 07 Jun 2021 01:58:14 GMT

Thanks Ruben, will give it a try and let you know.

Re: Add column to table as on-demand

Jayavignesh — Mon, 07 Jun 2021 07:20:42 GMT

There are also many extensions available - e.g. https://developer.qlik.com/garden/578fc358ba99b7951dee28a9

Re: Add column to table as on-demand

jpjust — Mon, 07 Jun 2021 13:16:42 GMT

Hi Ruben,

I have the inline and the expression on "Show column if" on the table.

Now the column is always visible on the table. How this works? Where would I list the columns for the users to select and which chart I should use?

Thanks

Re: Add column to table as on-demand

jpjust — Mon, 07 Jun 2021 16:37:18 GMT

Hi Ruben - I got it to work. I have an field selection table with 2 fields, IDColumn and Column (Column title)

And then I have an conditional expression on "Show column if" for each fields on the actual data table. When I select / deselect an field from the field selection table , the column appears / disappears from the actual data table.

Is it possible to have inline table with column name instead of the numerical value, then modify the expression accordingly on "Show column if" for each fields on the actual data table, then I can display the values in the filter pane (Column title) instead of field selection table for the users to select?

Thanks

Re: Add column to table as on-demand

rubenmarin — Tue, 08 Jun 2021 08:25:06 GMT

Hi, you can use an inline table with just the title, the numerical value is to separate index and text.

You can keep both, numerical and text, and only show the text (column title) in the filter panel for the user, when the user selects a text the expression uses the index related to that text, you don't need to show both.

Re: Add column to table as on-demand

jpjust — Tue, 08 Jun 2021 12:27:24 GMT

Unfortunately, having just the column title did not work. May be I am missing some thing.

I have this field selection table below and if I remove ColumnID and then just selecting on ColumnTitle did not work. Only if I select ColumID field, the other data table works. Same with the filter pane as well.

ColumnID ColumnTitle

1 Site

2 Year Month

This is my expression on each fields- Index(Concat(IdColumn,','),'1')

Index(Concat(IdColumn,','),'2') and so on...

Below is my inline table.

LOAD * Inline [
IdColumn, Column
1 , Site
2 , Year Month
3, UNIT Count

];

Can you please let me know how to make it work just by using title instead of the columnID?

Thanks

Re: Add column to table as on-demand

rubenmarin — Tue, 08 Jun 2021 16:14:24 GMT

If you don't have the column id you need to use the title in the expression:

Index(Concat(ColumnTitle,','),'Site')

Index(Concat(ColumnTitle,','),'Year Month')

But as I said before you can keep the Id to use in expression and only show the title for the user

Re: Add column to table as on-demand

jpjust — Tue, 08 Jun 2021 19:19:10 GMT

Thanks Ruben, everything worked as expected.