Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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
MVP
MVP

I am confused Souad...

souadouert
Specialist
Specialist
Author

exemple i want show only exp <70

Capture.PNG

sunny_talwar
MVP
MVP

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