Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

“Where” clause in Expressions

Hello Experts

Here I am having two doubts can you guys please help me from below mentioned doubts:

1.How to write the “where” clause in Expressions


For example:

I want count(candidateID) where placementdate is not null (can you guys elaborate this please)


2. How to change the names of values in our columns


For Example:

I have one column named as Status, In that Column values are 1,0 now i want to replace those values with open, close. i am not getting the idea how to change the values if it is excel we can modify but i am taking query from Sql Server Database.



Please Help out from this as soon as possible guys



Thank you in advance

16 Replies
sunny_talwar

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

bvssudhakar
Creator III
Creator III
Author

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

sunny_talwar

So, you need to use Preceding Load here

RMS:

LOAD *,

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

SELECT ....

bvssudhakar
Creator III
Creator III
Author

Hi Anil,

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

This is also working


Thank you for your help also

bvssudhakar
Creator III
Creator III
Author

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

sunny_talwar

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
Contributor III
Contributor III

In pick match case how can we use ELSE statement.