Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
rbecher
MVP
MVP

Selection of multiple records doesn't work

Hi,

it seems that neither

SelectTextsInColumn(0, false, ["A","B"])

nor

SelectValuesInColumn(0, ["A","B"], false)

doesn't work. It selects only the first value "A".

Is there any other way to do this in one function call?

- Ralf

Astrato.io Head of R&D
11 Replies
Nicole-Smith

The function works for me (see the attached .qar and .qvw files).

rbecher
MVP
MVP
Author

Yea, those kind of simple stuff always work. I also have some extensions that work with multiple selection, but some doesn't work.

Astrato.io Head of R&D
Nicole-Smith

Can you post an example of it not working?  I'd like to play around with it.

rbecher
MVP
MVP
Author

I cannot post this. But I have played around with all possible options and everytime only the first value gets selected..

Astrato.io Head of R&D
tlorimier
Partner - Contributor III
Partner - Contributor III

I'm using an extension at the moment and I have the same problem actually.

But I think I have identify one problem.

Those methods : SelectTextsInColumn / SelectValuesInColumn works fine with array as parameter BUT only if your column is a simple dimension (not a calculated dimension nor a conditional dimension)


For exemple :

- This work : Dimension : X => selectTextsInColumn(0,true,["a","b","c"]) => Filter a b c
- This wont work : Dimension : =if(GetPossibleCount(X) < 10, X, Null() ) => selectTextsInColumn(0,true,["a","b","c"]) = > filter a

So now it is a problem with the method ? Or the way we use dimension is too hacky ?

Here an example :

rustyfishbones
Master II
Master II

Hi Ralf,

I have never seen such a function, where is this used.

Regards

Alan

tlorimier
Partner - Contributor III
Partner - Contributor III

Those function is within the javascript API QlikView 11 for Extension.

rbecher
MVP
MVP
Author

Hi Alan,

in Extensions...

- Ralf

Astrato.io Head of R&D
rustyfishbones
Master II
Master II

Thanks for clearing that up