Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 2 INLINE tables, that i need people to select from one or both and i need my dynamic column table to display all of the selected columns
GetSelectedCount(Column) > 0 (this command works for one table), but if i
GetSelectedCount(Column, Column1A) > 0 i get records from both tables even if no columns were selected in that table.
Any ideas.
thanks
You can use and operator like
GetSelectedcount(column)>0 and getselectedcount(column1A)>0
May be this
GetSelectedCount(Column) > 0 and GetSelectedCount(Column1A) > 0
or
GetSelectedCount(Column) > 0 or GetSelectedCount(Column1A) > 0
I tried doing both combinations, the problem with both is that you have to choose 1 column from table column and 1 column from table column1A etc
the one with the or condition shouldn't be doing that
GetSelectedCount(Column) > 0 or GetSelectedCount(Column1A) > 0
This is saying either Column has a selection or Column1A has a selection....
Sunny, when i do GetSelectedCount(Column) > 0 or GetSelectedCount(Column1A) > 0
and select a column from table column and column1A it works perfectly, but when i only select a column from table column it pickup the column from table column and every column from table column1A. and if i choose only a column from table column1A, it pick up every column is table column and column!A. if that make sense.
thx you
It does.... but how is your chart structured? Do you have every dimension listed out and then you use this condition or how exactly are you using this? Would you be able to share a sample?
Sunny, you are right
I have expressions, like SubStringCount(Concat(Column,'|'),'Assumptions') and SubStringCount(Concat(ColumnA1,''|'),'Created;)
The reason why i created 2 tables, is that on my web version of the qlik app, when you select a column on the table, and i have over 100 columns, it does a refresh, and the refresh is noticeable. When you break the columns down to 2 or more INLINE tables, the refresh is less noticeable. The app works great on my local version, but the web version is my issue. I am just trying to mask the refresh of the columns. Unfortunately i caused another problem..
thanks for all of the help
May be try this
SubStringCount('|' & GetFieldSelections(Column, '|, |') & '|', '|Assumptions|') and SubStringCount('|' & GetFieldSelections(ColumnA1,'|, |') & '|', '|Created|')
Sunny,
this seems to be working
SubStringCount(Concat(Column,'|'),'Assumptions') and GetSelectedCount(Column) > 0
i need to add the GetSelectedCount on every expression, and change the names from Column to Column!A, but this maybe my answer.
thx you