Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Who Me Too'd this solution

sunny_talwar
MVP
MVP
‎2017-08-17 11:16 AM

In response to 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

1 user say ditto
11,970 Views
Who Me Too'd this solution