All,
I have an unusual scenario and hoped you might be able to provide some advice about how best to approach the problem.
I need to add a new tab to an existing QlikView document. The primary data source for this new tab is a
Questionnaire/Survey feedback database.
As the name suggests this database holds the responses to a number of survey questions. Around 100 in fact. There are three possible responses. Compliant, not applicable and Not Compliant.
For an individual respondent the database might hold 100 responses, or a partial set of responses, say 20, or no responses at all.
If a particular respondent has no responses, i.e. they haven't started the survey, the database will hold no records for the respondent. Not even a placeholder record. We know who the respondents should be because they form part of the dataset for rest of the QV document.
What I need to do here is to create some synthetic values for respondents who haven't yet started the survey or have only answered a few questions. Ideally all non answered questions should have a default value of 'Not compliant' as far as QV is concerned. P.S. I do not look after the survey database itself so cannot do anything to alter the existing design/schema/operating model.
My question is really about where to create any synthetic responses. At the SQL select level in the QV scripts or via 'If' statements in the QV script? Or by some other mechanism?
I would appreciate any example code especially for the 'If' statement scenario. For example would 'if Len(....' be better than 'if IsNull' or would a combination of the two be required? Should I be looking at the NullAsNull/NullAsValue functions?
Tom
