Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
souadouert
Contributor III

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

Re: hiding expression

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

12 Replies

Re: hiding expression

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
Contributor III

Re: hiding expression

i use this exp and then have this table

suny.PNG

but  i want delete the whole line

Re: hiding expression

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

souadouert
Contributor III

Re: hiding expression

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

Re: hiding expression

I am confused Souad...

souadouert
Contributor III

Re: hiding expression

exemple i want show only exp <70

Capture.PNG

Re: hiding expression

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

atkinsow
Valued Contributor II

Re: hiding expression

You could also try using Dimension Limits

souadouert
Contributor III

Re: hiding expression

y mean this option

Capture.PNG

Community Browser