Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

GetSelectedCount

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

Tags (1)
9 Replies
Highlighted

Re: GetSelectedCount

You can use and operator like

GetSelectedcount(column)>0 and getselectedcount(column1A)>0

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: GetSelectedCount

May be this

GetSelectedCount(Column) > 0 and GetSelectedCount(Column1A) > 0

or

GetSelectedCount(Column) > 0 or GetSelectedCount(Column1A) > 0

Highlighted
Contributor II
Contributor II

Re: GetSelectedCount

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

Highlighted

Re: GetSelectedCount

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....

Contributor II
Contributor II

Re: GetSelectedCount

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

Highlighted

Re: GetSelectedCount

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?

Highlighted
Contributor II
Contributor II

Re: GetSelectedCount

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

Highlighted

Re: GetSelectedCount

May be try this

SubStringCount('|' & GetFieldSelections(Column, '|, |') & '|', '|Assumptions|') and SubStringCount('|' & GetFieldSelections(ColumnA1,'|, |') & '|', '|Created|')

Highlighted
Contributor II
Contributor II

Re: GetSelectedCount

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