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: 
souadouert
Specialist
Specialist

hiding expression

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

12 Replies
sunny_talwar

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)

souadouert
Specialist
Specialist
Author

i use this exp and then have this table

suny.PNG

but  i want delete the whole line

sunny_talwar

You just don't want to see this expression? Are you expecting to see only one value for each expression?

souadouert
Specialist
Specialist
Author

If expression has a value for example <100 I display the line otherwise I hide all the expression

sunny_talwar

I am confused Souad...

souadouert
Specialist
Specialist
Author

exemple i want show only exp <70

Capture.PNG

sunny_talwar

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

Anonymous
Not applicable

You could also try using Dimension Limits

souadouert
Specialist
Specialist
Author

y mean this option

Capture.PNG