selection option - "OR" instead of "AND"

[amiroh81]

Hi,

In Qlikview when i choose to fields its show me the common data to both fields ('AND').

it is possible to change the selection option to "OR" instead of "AND" ?

Thanks in advanced

[sunny_talwar]

Do you have an example of what you have and what you want from it?

[amiroh81]

Hit

his is just example (3 inline table) :

DATA:

LOAD * INLINE [Customer,model,manufactureID,genderID

John,iphone6,1,1

Ben,iphone6s,1,1

Dan,G3,2,1

Suzi,S7,3,2

Michel,iphone7,1,2

];

manufacture:

LOAD * INLINE [manufactureID,manufacture

1,apple

2,lg

3,samsung

];

gender:

LOAD * INLINE [genderID,gender

1,male

2,female

];

if i will choose apple+female i will get only 1 row =    

Customer	model	gender	manufacture
Michel	iphone7	female	apple

But i want to see the following data :

Customer	model	gender	manufacture
Ben	iphone6s	male	apple
John	iphone6	male	apple
Michel	iphone7	female	apple
Suzi	S7	female	samsung

the first example bring me Apple 'AND' Female,

The secound one bring me Apple 'OR' Female.

Thanks

[vinieme12 · Accepted solution]

Read this thread

http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/

[Anonymous]

You also could experiment with expressions like that:

only({1<model=P({<gender=>} model)>  + 1<gender=P({<model=>} gender)> } gender ) 

[amiroh81]

Hi,

this solution help me on specific Example.

but when i try to implement on my model i got:

"Error: Error in set modifier ad hoc element list:',' or ')' expected:"

to vSelection.Or .

do you know Why?

[vinieme12]

can you post the expression for the variable

[amiroh81]

Hi,

This is the Variable:

=$(=

Concat(DISTINCT {<[$Field]-={$(vSelection.IgnoreFields)}>}

'If(GetSelectedCount([' & [$Field] & ']) > 0, ' & chr(39) &

'<[' & chr(39) & ' & Concat(DISTINCT  {<[$Field]={"*"} -

{'& chr(36) & '(vSelection.IgnoreFields)} - {' & chr(39) &

[$Field] & chr(39) & '}>} [$Field], ' & chr(39) & ']= ,[' &

chr(39) & ') & ' & chr(39) & ']= > + ' & chr(39) & ')' , '  & ') 

)

i found that when i choose the name of the field on $Field then the Variable Displayed correct.

But if i not choose the name of the field on $Field the Variable  show '-' .

On the other hand in the Example on top i dont need to choose the field on $Field.

Have an idea of the cause of the problem?