Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
mov
Esteemed Contributor III

Re: Selection on a single field

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

Re: Selection on a single field

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.

mov
Esteemed Contributor III

Re: Selection on a single field

Do you mean as in attached?

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

Community Browser