topic Re: where clause inside if statement in QlikView

where clause inside if statement

Wed, 01 Apr 2015 23:39:52 GMT

I have a small piece of code which basically checks if the question is 2 or 3 and

If the question is 3, it saves the corresponding answer as Final answer.

What I need is if the question is 2, it shows test for now but I would still like to save the Final answer as whatever was answer for question 3.

Is there a way I can achieve this? Any help will be appreciated

LOAD distinct

DataPoint,

if (Question=3,Answer,'test' ) as [Final Answer]

FROM

$(vQVDLocation)DataPointAnswerChoice.qvd

(qvd) where match(Question,2,3);

The pseudo code is something along below lines

if( question =3, answer, ( answer where question would have been 3) )

Re: where clause inside if statement

robert_mika — Wed, 01 Apr 2015 23:49:31 GMT

Maybe firstsortedvalue is the answer

How is your data structured.

Could you post an examples?

Re: where clause inside if statement

rwunderlich — Wed, 01 Apr 2015 23:56:27 GMT

Do you want to save the answer from question 3 as the answer for question 2?

-Rob

Re: where clause inside if statement

Wed, 01 Apr 2015 23:59:29 GMT

Yes

Re: where clause inside if statement

Thu, 02 Apr 2015 00:00:17 GMT

Thanks, i'll look up firstsortedvalue. The data structure is complex and I do a lot of manipulations but basically it has a column to note the questions and answers as shown above.

Re: where clause inside if statement

anbu1984 — Thu, 02 Apr 2015 05:03:48 GMT

What is the common field between rows where Question is 2 or 3?

Does both rows have same datapoint?

Re: where clause inside if statement

Thu, 02 Apr 2015 05:06:45 GMT

Yes Data Point is the same.

Re: where clause inside if statement

anbu1984 — Thu, 02 Apr 2015 05:12:31 GMT

If DataPoint is same and if you assign Answer of Question=3 to Question=2, both the rows will have same values as you have only two fields selected in Load statement. Then why do you need to assign Answer of Question=3 to Question=2?

Re: where clause inside if statement

Thu, 02 Apr 2015 05:21:59 GMT

I actually have more statements like assigning the score and time stamp. I just copied the part where I assign value to Final Answer. I also have series of load statements written when question equals to 4, 5 etc,,

Re: where clause inside if statement

robert_mika — Thu, 02 Apr 2015 05:38:09 GMT

Post some of your data to better understand your requirement

Re: where clause inside if statement

anbu1984 — Thu, 02 Apr 2015 05:41:25 GMT

Tbl:

LOAD distinct

DataPoint,

if (Question=3,Answer,'test' ) as Answer3,

Question

FROM

$(vQVDLocation)DataPointAnswerChoice.qvd

(qvd) where match(Question,2,3);

Join(Tbl)

LOAD

DataPoint,

2 As Question,

Answer As Answer2

FROM

$(vQVDLocation)DataPointAnswerChoice.qvd

(qvd) where Question=3;

Final:

Load *, if (Question=3,Answer3,Answer2 ) as [Final Answer] Resident Tbl;

Drop Table Tbl;

Re: where clause inside if statement

Thu, 02 Apr 2015 17:04:48 GMT

Thank you so much anbu cheliyan. That fix worked like a charm.

Re: where clause inside if statement

Thu, 02 Apr 2015 17:05:30 GMT

Thanks for trying to help Robert, Anbu Cheliyan helped me solve it.