Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have defined a variables vExp in variable overview as following:
Concat(distinct 'IF(GetSelectedCount(['&[$Field]&']) > 0, '& chr(39) & '<[' & chr(39) &' & concat(distinct {<[$Field] = {"*"} - {' & chr(39) & [$Field] & chr(39) &'}>} [$Field], ' & chr(39) &']=,[' & chr(39) &') & ' & chr(39) & '] = > + ' & chr(39) &')')
I have borrowed this from internet, and I want to do an OR mode between more than two list boxes.
Refer to this link: http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/
I think the expression is correct. Now, I wish to use it in a chart like =Sum({$(vExp)} Quantity). But for some reason I haven't been able to get this to work. Can anyone help me on this?
I am new to Qlikview and don't have much understanding around how variables work.
Could you share your sample app where this can be tested? Also please describe your expected output with logical explanation.
Here, I have the list boxes from which i wish to select data. I have got a chart where i want the selections to reflect. Thanks.