I would like to create a bicycle model on Qlikview using drop down questions from a list. The list could well be over 100+ questions with a number of possible answers, for example :- type (racing bike, mountain bike) colour (red,blue,green) frame size, wheel size (20", 22") etc.
This list will be on an excel sheet perhaps in columns, but the only way I can see to get this to work without 100s of tables for every question, would be to create a matrix with all possible combos, and i've already got that to work so far.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.