topic Re: Problem with where clause in QlikView

Problem with where clause

Mon, 08 Feb 2016 12:19:33 GMT

Hi All,

I am stuck at some point in development process and would need you help and suggestions.

My excel file contains data in the format as specified below.

I need to load data on following conditions only

jonathandienst — Mon, 08 Feb 2016 12:24:52 GMT

Where

Activity <> 'Break'

And (Match(Name, 'Priyanka', 'Vikas') = 0 Or ([Prod/Non Prod] <> 'Non Prod' And Activity <> 'QA'))

sunny_talwar — Mon, 08 Feb 2016 12:25:20 GMT

Try this:

Table:

LOAD Name,

[Prod/Non Prod],

Activity

FROM

[https://community.qlik.com/thread/204640]

(html, codepage is 1252, embedded labels, table is @1)

Where Activity <> 'Break' and

not(Match(Name, 'Priyanka', 'Vikas') and ([Prod/Non Prod] = 'Non Prod' or Activity = 'QA'));

jonathandienst — Mon, 08 Feb 2016 12:26:41 GMT

Or, if its slightly clearer, the functionally equivalent:

Where

Activity <> 'Break'

Not (Match(Name, 'Priyanka', 'Vikas') And ([Prod/Non Prod] = 'Non Prod' Or Activity = 'QA'))

alex_millan — Mon, 08 Feb 2016 12:37:50 GMT

Hi Priyanka,

Where

Activity <> 'Break' and (

Not(Match(Name, 'Priyanka', 'Vikas')

(Match(Name, 'Priyanka','Vikas') And [Prod/Non Prod] <> 'Non Prod' And Activity <> 'QA')

);

Regards