topic Re: If then statement in script, evaluates the same in QlikView

If then statement in script, evaluates the same

Thu, 13 Jul 2017 19:51:29 GMT

For some reason, and I've tried many scenarios, the above always sets BuildQvd to true.

I have ValueSources in the path file, yet it still builds it each time.

Any idea why?

Thank you

Re: If then statement in script, evaluates the same

vishsaggi — Thu, 13 Jul 2017 20:19:04 GMT

Correct me not sure i understand your query.

Your script says if no of records from Values_Sources is > 0 then

you want to set your vBuildQVD = 'False' ELSE

vBuil,dQVD = 'True'.

You dont have any records in your table. So it always be true. So what exactly you are trying to do?

Re: If then statement in script, evaluates the same

marcus_sommer — Fri, 14 Jul 2017 07:33:40 GMT

I think the reason are missing single-quotes and a $-sign expansion around your variable which are needed if the variable contained string-values. It should be look like:

...

if '$(vBuildQVD)' = 'True' then

...

Whereby in your above scenario you don't need these variables - you could directly use the first if with the QVDNoOfRecords to switch in your different branches.

Beside them it's quite often useful to create numeric or even better boolean variables instead of strings. In your case it could be for examples:

let vBuildQVD = ceil(QVDNoOfRecords('path/file.qvd') / 100000000000);

which returned 0 respectively FALSE if there is no record and 1 respectively TRUE if there is any record (whereby each number unless 0 will be in Qlik treated as TRUE).

- Marcus

Re: If then statement in script, evaluates the same

Fri, 14 Jul 2017 14:00:37 GMT

If I'm not mistaken, QvdNumberofRecords returns the records in that qvd. So since I already have that qvd with data in it, it should be greater than 0, so then it doesnt rebuild the qvd from scratch

Re: If then statement in script, evaluates the same

Fri, 14 Jul 2017 14:31:27 GMT

I was having issues with it always evaluating to the same value.

This is what fixed it.

If the file doesnt exist, the records will be null, not zero.

let vQVDExists = not isnull(QvdCreateTime('filepath.qvd'));

if $(vQVDExists) = 0 then

..........

END IF

Thanks!