topic Re: If statement selection in table in QlikView

If statement selection in table

Tue, 21 May 2013 20:18:10 GMT

hi i have a condition i would like to run on my dataset.

I am not sure where this condition should go, assuming ArticleNr in the diagram conditions box?

Also my syntax is horribly wrong and help greatly appreciated.

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

Best,

Bradley

Re: If statement selection in table

Tue, 21 May 2013 20:40:21 GMT

Your syntax isn't that far off. As for where it would go, are you trying to use this condition in an expression or in your script?

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

Re: If statement selection in table

Tue, 21 May 2013 20:44:10 GMT

in a table on the dimension articlenr , however it is not taking .(

Re: If statement selection in table

Tue, 21 May 2013 20:49:51 GMT

It looks like you are putting it in the "Enable Conditional" field. Uncheck the box and instead click Edit (looks like Redigera for you). That's where you put the calculated dimension. Next, check the "Suppress when value is null" box.

Re: If statement selection in table

Tue, 21 May 2013 21:08:34 GMT

my table is constantly loading now, (hourglass)

any tips?

Re: If statement selection in table

Tue, 21 May 2013 21:12:19 GMT

How much data are you runing that if statement against? You will get better performance if you use set analysis, but of course that depends on what you are trying to achieve.