Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Multiple if in straight table expression

=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

3 Replies

Re: Multiple if in straight table expression

Try this:

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

Not applicable

Re: Multiple if in straight table expression

Wow, It worked Thanks a lot

Re: Multiple if in straight table expression

Awesome

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

Community Browser