Discussion Board for collaboration related to QlikView App Development.
Have a req in which I want to have inverted coma and end bracket ,PFA as mentioned in text box.
Thanks in advance
This works when 1 year is selected,
=If(GetSelectedCount(Year) > 0,GetCurrentSelections(' and ',' in (''')&Chr(39)&Chr(41),'')
But if you are selecting multiple years, the Concat function may be better,
='Year in ( '&Chr(39)&Concat(Year,Chr(39)&','&Chr(39))&Chr(39)&Chr(41)
View solution in original post