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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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