topic Re: if condition in QlikView

if condition

Fri, 26 Apr 2013 12:43:42 GMT

Hi i am attempting to stop a value loading based on a condition.

I have Two fields in my example

Article Number ; MovementDate

what i would to do is say if Article number has not been changed (connected to Movement Date) do not include in budget;

is a flag required first to mark the article as unmoved over the last year?

if so how is the code setup for this and if not how can one create a count statement based on this?

Best,

Bradley

Fri, 26 Apr 2013 12:48:59 GMT

Hi!

Try

Table:

Load *

From Table_Script

Where MovementDate > (dayend (Now(), -365 ))

Rebeca Gums

Fri, 26 Apr 2013 13:31:02 GMT

HI Rebecca!

Thank you for your reply. It works perfectly.

If one were to use this in an expression however, could it be expressed as the following, I receive a syntax mistake when attempting to do this.

=if (Artikeltyp = 'z' and MovementDate > (dayend (Now (), -365)), ArticleNr;

It is brackets problem I have there.

Fri, 26 Apr 2013 16:21:32 GMT

Hi,

If my answer is that you need, please mark it as correct!

Rebeca Gums