Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Try this:

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

Not applicable
Author

Wow, It worked Thanks a lot

sunny_talwar

Awesome

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