Knowledge Uplift

[MarkSYPO]

Hello guys,

First i want to say hello 🙂 

I have already script in php which will generate me some data is any chance to convert it for Qlik Sense ? 

 $all_submitted_answers = UserQuiz::->count();
if ($all_submitted_answers > 0)
 {
       $all_correct_submitted_answers = UserQuiz::select('user_quiz.*')->join('answers', 'answers.id', '=', 'user_quiz.answer_id')->where('answers.is_correct', 1)->count();
        $total = ($all_correct_submitted_answers) ? round((($all_correct_submitted_answers / $all_submitted_answers) * 100), 1) : '0';
}

Many thanks Guys 🙂

[MarkSYPO]

Small update 

SELECT user_quiz.user_id, user_quiz.question_id,user_quiz.answer_id,user_quiz.video_id FROM user_quiz
JOIN answers a ON a.id = user_quiz.answer_id
WHERE a.is_correct =1;

[MarkSYPO]

Okay done it thanks anyway 🙂 

Can be closed 🙂 

[MayilVahanan]

Hi Mark,

You can use this SQL Query in the Qliksense directly by connecting the DB via ODBC / OLEDB connector.