Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

If statement selection in table

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

1 Solution

Accepted Solutions
Not applicable

Re: If statement selection in table

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)

5 Replies
Not applicable

Re: If statement selection in table

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)

Not applicable

Re: If statement selection in table

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

Not applicable

Re: If statement selection in table

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.

Not applicable

Re: If statement selection in table

my table is constantly loading now, (hourglass)

any tips?

Not applicable

Re: If statement selection in table

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.

Community Browser