Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Read this thread
http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/
Do you have an example of what you have and what you want from it?
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
Read this thread
http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/
You also could experiment with expressions like that:
only({1<model=P({<gender=>} model)> + 1<gender=P({<model=>} gender)> } gender )
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?
can you post the expression for the variable
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?