topic Re: Multiple if in straight table expression in QlikView

Multiple if in straight table expression

Wed, 23 Dec 2015 16:55:52 GMT

=sum(If([Descriptive Analysis Response]='Beginner',2,0))or

if([Descriptive Analysis Response]='Applying',3,0)or

if([Descriptive Analysis Response]='Expert',5,0)

Actually i have survey responses like beginner, expert etc, for each questions.

I want to sum up the response and give a weighted total.

=sum(If([Descriptive Analysis Response]='Beginner',2,0)) this one works but rest of the if statement not working

Please help

sunny_talwar — Wed, 23 Dec 2015 17:32:51 GMT

Try this:

Sum(Pick(Match([Descriptive Analysis Response], 'Beginner', 'Applying', 'Expert'), 2, 3, 5))

Wed, 23 Dec 2015 17:40:33 GMT

Wow, It worked Thanks a lot

sunny_talwar — Wed, 23 Dec 2015 17:44:02 GMT

Awesome

Please close the thread since you got what you were looking for