Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

QlikSense OR mode

Hello,

Can someone help me in implementing OR mode between list boxes in Qliksense?

I found the solution in Qlikview using variables. I want to implement the same in Qliksense. But its not working.

I am attaching the OR mode QVW which worked in Qlikview.

1 Reply
MVP & Luminary
MVP & Luminary

Re: QlikSense OR mode

That should work in Qlik Sense too. In Qlik Sense 2.1 you can create variables in the user interface. In earlier versions you'd need to do it in the script. But in the script the $(...) will be expanded so you need a small trick:

SET vSelection.Or =

=@(=

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) & ')' , '  & ') 

);

LET vSelection.Or = replace('$(vSelection.Or)','@','$');


talk is cheap, supply exceeds demand