Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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)

View solution in original post

5 Replies
Not applicable
Author

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
Author

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

Not applicable
Author

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
Author

my table is constantly loading now, (hourglass)

any tips?

Not applicable
Author

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.