Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

exclude data in load

Hello,

Need to exclude some rows in load, like

where not

(companykey=1 and monthkey >=201201) or

(companykey=2 and monthkey >=201206)

But it seems not to work.

Any idea how to do it?

br, timo v

1 Solution

Accepted Solutions
giakoum
Not applicable

Re: exclude data in load

This seems to work :

Where

          not (

(companykey=1 and monthkey >=201201) or

(companykey=2 and monthkey >=201206)

);

5 Replies
giakoum
Not applicable

Re: exclude data in load

some sample data would help

Not applicable

Re: exclude data in load

Hello Ioannis,

Here's an example

compkey mthkey amount

1 201101 100

1 201102 110

1 201103 120

1 201104 130

1 201105 140

1 201106 150

1 201107 160

1 201108 170

1 201109 180

1 201110 150

1 201111 130

1 201112 120

1 201201 110

1 201202 130

1 201203 140

1 201204 150

1 201205 160

1 201206 100

Where rows >=201201 should be excluded in load, and the same for an othet customer with an other time period

br

timo v

giakoum
Not applicable

Re: exclude data in load

This seems to work :

Where

          not (

(companykey=1 and monthkey >=201201) or

(companykey=2 and monthkey >=201206)

);

Not applicable

Re: exclude data in load

I think you could use Ioannis solution or:

where not

(companykey=1 and monthkey >=201201) and not

(companykey=2 and monthkey >=201206)

Regards

Not applicable

Re: exclude data in load

sorry for deleay, thx this worked

timo v