topic Re: script finishes on exists() in QlikView

script finishes on exists()

Wed, 09 Mar 2016 09:04:17 GMT

Hello!

Tell me?please? why can script finish without even en error on string

IF Exists(Date2,'$(vCurrentDate)') then

Before this i'm making a table for product sales for all dates and onle one product

Best regards,

Alex

Re: script finishes on exists()

Chanty4u — Wed, 09 Mar 2016 12:02:11 GMT

chk dis

Exit ()

Re: script finishes on exists()

avinashelite — Wed, 09 Mar 2016 12:08:26 GMT

I think the value in the variable is not present in the date2 and hence the condition is not getting satisfied and part of the code in IF block is not working

//IF Exists(Date2,'$(vCurrentDate)') then

check this for the exists

Understanding EXISTS() function - Qlikview vs SQL/RDBMS

Value of the Flag as "X" is exists "Y" if not e... | Qlik Community

Re: script finishes on exists()

sunny_talwar — Wed, 09 Mar 2016 13:19:11 GMT

Have you checked the log file to confirm that there was in fact no errors?

Re: script finishes on exists()

Peter_Cammaert — Wed, 09 Mar 2016 13:24:15 GMT

Exists() is a so-called Inter Record Function that can be used to evaluate the current record based on values from a previously loaded record or field.

In an IF-THEN-ELSE control statement, you're not loading any records, so I guess the Exists() call will cease to work. Use Exists() in a LOAD statement.

Re: script finishes on exists()

cesaraccardi — Wed, 09 Mar 2016 13:26:29 GMT

Hi,

The exists() is an inter record function which means it only works in a context of a loading. I am assuming that is not the case in your script, if so you might want to transfer the logic to the WHERE clause of your load statements.