# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

## Filter Values Greater than 1

Hello,

I have a field called Values

Values

0.5

0.3

0.4

1.5

1.8

0.2

0.3

and I have a Pivot Table that has:

Name            Values      Volume

Totals              5.0          340

Blue                0.5          100

Red                0.3          50

Yellow             0.4          40

Black              1.5          20

Green             1.8          80

Orange           0.2          30

Pink               0.3          20

Is there a way to filter the values that are greater than and equal to 1 and less than 1?

Expected Output if greater than one is chosen:

Name            Values      Volume

Totals              3.3            100

Black              1.5             20

Green             1.8             80

and same with the less than

Thank you

Message was edited by: Roy Morales

9 Replies
Partner

## Re: Filter Values Greater than 1

can you please share the expected output

MVP

## Re: Filter Values Greater than 1

Is this a dimension or expression?

Not applicable

## Re: Filter Values Greater than 1

I have updated my question

Partner

## Re: Filter Values Greater than 1

This will show everything greater than or equal to 1

if(Values>=1, Volume)

And this will show everything less than

if(Values<1, Volume)

If these are your only expressions, then any volume that doesn't meet you criteria won't be displayed.

Partner

## Re: Filter Values Greater than 1

Hi,

PFA the sample qvw. hope that helps.

## Re: Filter Values Greater than 1

Something Like this,

=If(sum({<[Comapny Name] = {"Volume>=1","Volume<1"}>})Sales)

OR

==If(sum({<[Comapny Name] = {"Volume" : ">=1 and <1"}>})Sales)

- Anil Chowdary

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

## Re: Filter Values Greater than 1

You can done with this way, hope it helps

Not applicable

## Re: Filter Values Greater than 1

How can i put formula where i have data from negative to positive and i need from -1 to +1..

Partner

## Re: Filter Values Greater than 1

if(DATA >= -1 AND DATA <= 1, VALUE)