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: 
Not applicable

Selection on a single field

Hi, I have here a data of versions:

 

Versions
Actual
Accuracy
V1
V2
V3
V4
V5
V6
V7
V8
V9

V10

I want to create 2 new list box for this called:

Version Actual, contents:

Actual

Accuracy

Versions, contents:

V1

V2

V3

so on...

If I just do an expression to separate the data, ex. I select V1, version Actual is already disabled or vice versa. I want to be able to select them and reflect. Any idea will be much appreciated.

Thanks

3 Replies
Anonymous
Not applicable
Author

Something like this:

VersionsActual:
LOAD
Versions as "Versions Actual"
From source
WHERE len(Versions)>3;

Versions:
LOAD
Versions
From source
WHERE len(Versions)<=3;

Not applicable
Author

Hi! Thanks for the reply. Yes i tried this but since the 'Version' fied is already existing on my reports, I want the new created listbox to be my filters but in the report, the field I will use is the version.

Anonymous
Not applicable
Author

Do you mean as in attached?

If not, you need to explain better, maybe upload an example.