topic Re: Filter Values Greater than 1 in QlikView

Filter Values Greater than 1

Tue, 28 Jun 2016 15:17:58 GMT

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

Re: Filter Values Greater than 1

krishnacbe — Tue, 28 Jun 2016 15:29:02 GMT

can you please share the expected output

Re: Filter Values Greater than 1

sunny_talwar — Tue, 28 Jun 2016 15:32:07 GMT

Is this a dimension or expression?

Re: Filter Values Greater than 1

Tue, 28 Jun 2016 16:11:06 GMT

I have updated my question

Re: Filter Values Greater than 1

ciaran_mcgowan — Tue, 28 Jun 2016 16:15:05 GMT

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.

Re: Filter Values Greater than 1

krishnacbe — Tue, 28 Jun 2016 16:30:03 GMT

Hi,

PFA the sample qvw. hope that helps.

Re: Filter Values Greater than 1

Anil_Babu_Samineni — Tue, 28 Jun 2016 16:33:04 GMT

Something Like this,

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

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

- Anil Chowdary

Re: Filter Values Greater than 1

Wed, 29 Jun 2016 08:35:43 GMT

You can done with this way, hope it helps

Re: Filter Values Greater than 1

Mon, 24 Oct 2016 07:21:31 GMT

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

Re: Filter Values Greater than 1

ciaran_mcgowan — Mon, 24 Oct 2016 13:39:29 GMT

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