Discussion Board for collaboration on QlikView Scripting.
Is that I can hide an expression from a simple table depending on the value eg if an exp <100 I do not want to display it
Go to Solution.
Use a hide show condition for each of your expression
Expression 1 -> Exp1 < 70
Expression 2 -> Exp2 < 70
Expression 3 -> Exp3 < 70
Expression 4 -> Exp4 < 70
Expression 5 -> Exp5 < 70
You can use an if statement for all your expressions to force them to be null when exp <100... So say you have 3 expressions and you want to show only when exp3 >= 100, you would do this
If(exp3 >= 100, exp1)
If(exp3 >= 100, exp2)
If(exp3 >= 100, exp3)
i use this exp and then have this table
but i want delete the whole line
You just don't want to see this expression? Are you expecting to see only one value for each expression?
If expression has a value for example <100 I display the line otherwise I hide all the expression
I am confused Souad...
exemple i want show only exp <70
You could also try using Dimension Limits
y mean this option