Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

OR selection in multiple fields

Hi guys,

I need to make a selection in various fileds: ex. the colour "yellow" in the "cars" selection table OR (not AND) in the bicycle one, and get the result at the same time.

Has anybody an idea for me?

Thanks.

N.

25 Replies
swuehl
MVP
MVP

Oh, that's strange, because what you are asking for is what do I see in my app:

OR_Selection_187241.png

On what QV version are you? Can you check that the two list boxes on the top right are still set to CAR resp. CYCLE alternate state?

Anonymous
Not applicable
Author

I've got a 10 SR6 version.

Pls let me know where I can find the parameter you told me to check for.

Thks.

N.

rubenmarin

Just to confirm than for me swuelhl's solution is working. As he said, check if your QV version is updated enough to control alternate states.

In example, this is the properties of the Car list box

Anonymous
Not applicable
Author

Now it's clear....my qw versione doesn't support the alternative states....my list box doesn't show the combo you posted 😞

swuehl
MVP
MVP

Right, Alternate states are available since QV11. Any chance to upgrade?

Anonymous
Not applicable
Author

unfortunately the upgrade is too expensive for me...I've got a server version without the software maintenance 😞

raman_rastogi
Partner - Creator III
Partner - Creator III

To See Alternate State in your object property first you have to create alternative State.

Setting->Document Properties->General->Alternate States  

rubenmarin

Hi edp, try this expression:

Count({<Cycle>+<Car>} Family)

Set analisys to avoid Cycle selections added the count avoiding Car selections

raman_rastogi
Partner - Creator III
Partner - Creator III

Sorry but there is no alternative state in QV10

Anonymous
Not applicable
Author

Ruben, it doesn't work properly...when I select both the listbox it shows the three families but if I make only one selection it always shows all the families: Untitled-1.jpg