Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I have the following issue and would be very thankful if someone has an idea.
For example I have a dataset of 3 Question:
Do you have a Car?
Do you have a Bicycle?
Do you have a Scooter?
So since it is possible that some person have more than one, I get results like this:
Person 1 | Person 2 | Person 3 | |
Car? | Car | Car | |
Bicycle? | Bicycle | Bicycle | |
Scooter? | Scooter |
Now in QlikView I'd like to have a listbox with: Car, Bicycle and Scooter. The problem is that if I use an usual if-formula like:
If([Car?]='Car','Car',if([Bicycle]='Bicycle','Bicycle',if([Scooter?]='Scooter','Scooter)))
Person 2 is only listed for having a Car, but not for having a Bicycle.
I hope someone understood my example and can help me.
Thank you very much
Herm,
Just create a sample data in q sample file by inline Table.
and post it .
You could create the table using flags (1's or 0's) and use Bit Operators
See http://community.qlik.com/docs/DOC-6464 for more details on how to use these
Regards
Richard
Hi Herm,
share your sample qvw
it will be helpful to solve
I would concur with Richard on this with one possible exception - I think that I would have a numeric value for each field so that it is future proof. I will explain.
Initially, it will be OK to have a selection on each list item as a YES/NO flag but usually with these types of systems, the question comes up to get a response for those people with more than 1 car and a bicycle.
So I would have each item specified as a separate listbox containing the number of each item that the person possesses. You can then add these measures together for a combined listbox if required.
I hope this helps