topic Re: Multiple If-Dimensions in QlikView

Multiple If-Dimensions

Thu, 08 May 2014 09:45:32 GMT

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

Re: Multiple If-Dimensions

sujeetsingh — Thu, 08 May 2014 09:47:49 GMT

Herm,

Just create a sample data in q sample file by inline Table.

and post it .

Re: Multiple If-Dimensions

richard_pearce6 — Thu, 08 May 2014 09:51:40 GMT

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

Re: Multiple If-Dimensions

Thu, 08 May 2014 09:56:06 GMT

Hi Herm,

share your sample qvw

it will be helpful to solve

Re: Multiple If-Dimensions

Roop — Thu, 08 May 2014 10:00:18 GMT

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