topic Re: Display value straight table in Qlik NPrinting

Display value straight table

emteam162 — Mon, 27 Jun 2016 13:44:34 GMT

Hi,

I have straight table as

I want to display only rows red

the role are if (Exp1 <-30% or Exp2 <-30% then display value of each column)

how can i do that wiht nprinting

Many thanks for your help

Said

jonathandienst — Mon, 27 Jun 2016 13:51:27 GMT

Expression 1

=If(...expression 1... < -30 Or ... expression 2... < -30, ...expression 1...)

Expression 2

=If(...expression 1... < -30 Or ... expression 2... < -30, ...expression 2...)

Substitute your actual expressions into the above

jonathandienst — Mon, 27 Jun 2016 13:54:03 GMT

Or as long as you are using a straight table, create expression1 and expression2 normally Then create two more expressions:

=If(Column(1) < -30 Or Column(2) < -30, Column(1))

=If(Column(1) < -30 Or Column(2) < -30, Column(2))

and hide expression 1 and 2 in the presentation tab. This has the advantage that each expression is only evaluated once.

emteam162 — Mon, 27 Jun 2016 14:44:53 GMT

Hi,

Its work

many thanks

Said