topic Re: hiding expression in QlikView

hiding expression

souadouert — Wed, 10 May 2017 13:51:32 GMT

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

Re: hiding expression

sunny_talwar — Wed, 10 May 2017 13:53:25 GMT

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)

Re: hiding expression

souadouert — Wed, 10 May 2017 14:09:56 GMT

i use this exp and then have this table

but i want delete the whole line

Re: hiding expression

sunny_talwar — Wed, 10 May 2017 14:11:32 GMT

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

Re: hiding expression

souadouert — Wed, 10 May 2017 14:13:29 GMT

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

Re: hiding expression

sunny_talwar — Wed, 10 May 2017 14:20:30 GMT

I am confused Souad...

Re: hiding expression

souadouert — Wed, 10 May 2017 14:32:54 GMT

exemple i want show only exp <70

Re: hiding expression

sunny_talwar — Wed, 10 May 2017 14:35:07 GMT

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

Re: hiding expression

Anonymous — Wed, 10 May 2017 14:39:05 GMT

You could also try using Dimension Limits

Re: hiding expression

souadouert — Wed, 10 May 2017 14:41:52 GMT

y mean this option

Re: hiding expression

sunny_talwar — Wed, 10 May 2017 14:45:58 GMT

Yes

Re: hiding expression

souadouert — Wed, 10 May 2017 14:51:43 GMT

thank you sunny

Re: hiding expression

sunny_talwar — Wed, 10 May 2017 14:57:53 GMT

Yay!!!