Qlik Community

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
Partner

Re: Filter Values Greater than 1

can you please share the expected output

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

r1.JPGr2.JPGr3.JPG

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
Partner

Re: Filter Values Greater than 1

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