filter rows on value of an expression

[#1]

I have a straight table chart with a calculated expression for SalesCount per product, How can I filter this Chart so that rows with a SalesCount >$(MyVariable) are not Diplayed. My varaible is the value of an inputBox

ColinR

[lmonincx]

Hi,

see attached qvw, use an if in the expression:

if

(Sum(Sales)<$(MyVariable),Sum(Sales))

Regards,

Linda

[#3]

not quite,

I need a conditional display for the entire row if a expression is < my value

[#4]

Hello,

I have exactly the same question and I am very interested in an answer !

Did you find something ?

[lironbaram]

hei

see the attach example

you need to put your condition on the dimension

hope its helps you

[#6]

Thanks !

I have modified the expression to put a null() when the condition is not satisfied and then I also to tick the option "SUppress when value is null".

It is working fine now.

[lironbaram]

hei ]

if you approve the answer then

it will benfit other users in the forum

thank you

glad it helped you

[#8]

Sorry may be I did not do the right thing :

I wanted to post my own answer (built with your help) wich is to put the following :

=if(START_DATE>=Inputdate, if(START_DATE<=InputdateEnd,SCIENTIST_NAME, null()), null())

it displays only the rows for the scientists between certain dates.