Discussion Board for collaboration related to Creating Analytics for QlikView.
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;
Go to Solution.
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)
in a table on the dimension articlenr , however it is not taking .(
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.
my table is constantly loading now, (hourglass)
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.