Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Visualization and Usability

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services

Who Me Too'd this solution

sunny_talwar

Or just create this in the same table...

TableName:

LOAD Name,

    Question,

    Anwser,

if([Question]='Question 1' AND [Answer]='1', 'Correct',

if([Question]='Question 1' AND [Answer]='2', 'False',

if([Question]='Question 2' AND [Answer]='1', 'False',

if([Question]='Question 2' AND [Answer]='2', 'Correct'))))

as [Result]

FROM ...

View solution in original post

Who Me Too'd this solution