Do you have a column called Survey 1 Question?
I would better have it in a separate table then in a common column called Survey Question.
If that is not possible, then try the following function :
Returns a string with the current selections in a field.
ValueSep is the separator to be put between field values. The default is ', '.
Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.
Thanks for quick response loannis.
Approach1: having common column.
We store all survey responses to question in a single table.
It is possible that one survey called survey1 can have many number of question like "Survey 1 Question1" ,"Survey 1 Question2" which are not applicable for another survey called survey2.
There wont be any common questions between survey1 and survey2.
Approach2: getfieldselections ( FieldName [, ValueSep [, MaxValues]])
I played around getfieldselections and it is to get the selected value in a table.
But what i am trying to achieve is on selection of particular survey called survey 2 , i want to hide columns "Survey1 Question1" and "Survey1 Question2".
Thanks for your response adhimulam.
My qlikview app reloads data on daily basis to reflect new survey responses in to the app. so eventually we will be seeing new survey responses.
how do we add dynamic questions in (=getPossibleCount([Survey 2 question])).
we don't want to keep doing changes to qlikview app for new responses.