Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: “Where” clause in Expressions

I hope you are doing this on the general tab and not the expressions tab?

bvssudhakar
Contributor II

Re: “Where” clause in Expressions

I tried in load script also but it's not showing in fields pane, can you check the attached images it is correct or wrong

Re: “Where” clause in Expressions

So, you need to use Preceding Load here

RMS:

LOAD *,

     Pick(Match(ishotjob, -1, 0), 'Open', 'Close') as JobStatus;

SELECT ....

bvssudhakar
Contributor II

Re: “Where” clause in Expressions

Hi Anil,

I tried this formula Count({<placementdate -= {"=Null()"}>} candidateID)

This is also working


Thank you for your help also

bvssudhakar
Contributor II

Re: “Where” clause in Expressions

Hi Sunny,

Thank you, I forgot the pattern thank you for the help now it is working.

Now i have two more questions i will create separate discussion for them

And For which answer i want give the correct answer,... for this one or previous 1st question

Re: “Where” clause in Expressions

That is for you to decide... but you can always mark helpful responses for any/all answers which you thought were helpful.

Best,

Sunny

debabrata_sahoo
New Contributor III

Re: “Where” clause in Expressions

In pick match case how can we use ELSE statement.