topic Re: How to use Where Clause at script leve in QlikView

How to use Where Clause at script leve

GauravSS04 — Mon, 11 Feb 2019 06:33:36 GMT

In Organization report, under column Employee Type I want to select only rows where row value is 'Employee' and it should be done at script level. Could you help me with Where condition?

Re: How to use Where Clause at script leve

pradosh_thakur — Mon, 11 Feb 2019 06:48:20 GMT

Try below. Please check the field name and value once.

where [Employee Type] = 'Employee';

or

Where Match( [Employee Type] ,'Employee');

Re: How to use Where Clause at script leve

GauravSS04 — Mon, 11 Feb 2019 10:41:05 GMT

Thanks for sharing me with the solution....but this would be useful in case I am using in SQL and in Qlik it will throw an error by not mentioning the source after Match expression. I can use this even by using resident load and then joining with old table. However, I was looking for Where clause to be used in [Employee Group1] field and not use Resident load option...

[Leave Reason] AS [J.Leave Reason],
[Length of Service] AS [J.Length of Service],
[Email ID] AS [J.Email ID],
[Scope of Role] AS [J.Scope of Role],
Nationality AS [J.Nationality],
[Employee Group1]

FROM
[C:\Users\Desktop\Misc\xxxxxxx.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: How to use Where Clause at script leve

pradosh_thakur — Mon, 11 Feb 2019 10:45:13 GMT

[Leave Reason] AS [J.Leave Reason],
[Length of Service] AS [J.Length of Service],
[Email ID] AS [J.Email ID],
[Scope of Role] AS [J.Scope of Role],
Nationality AS [J.Nationality],
[Employee Group1]

FROM
[C:\Users\Desktop\Misc\xxxxxxx.xlsx]
(ooxml, embedded labels, table is Sheet1)

where [Employee Group1] ='Employee' ;

the above gives you an error? I dont think so. You can use it in the source table itself.

Re: How to use Where Clause at script leve

GauravSS04 — Mon, 11 Feb 2019 10:53:29 GMT

Hello Pradosh, its working now.
Thanks for correcting me....i couldn't relate the earlier solution. 🙂