# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Highlighted
Not applicable

## How to Seperate Positive and Negative Average ?

Hi All,

I have a table like below

The Average is been Calculated based on Below formula:

Formula:

From Above table, I need an Output Like Below tables. I Need to Separate  Top  Positive(Descending Order) and  Top 10 Negative (Descending Order)Values from above table for Three Days (04/09/2017 PM,04/08/2017 PM,04/07/2017 PM)

Expected  Output:

For (04/09/2017 PM):

Positive:

 TGB Name Date Average Metro_AMI 4/9/2017 PM 0.50

Negative;

 TGB Name Date Average Bala_AMI 4/9/2017 PM -0.78 Cheta_AMI 4/9/2017 PM -0.85

For (04/08/2017 PM):

Positive:

 TGB Name Date Average Bala_AMI 4/8/2017 PM 0.80 Metro_AMI 4/8/2017 PM 0.33

Negative:

 TGB Name Date Average Cheta_AMI 4/8/2017 PM -0.13

For (04/07/2017 PM):

Positive:

 TGB Name Date Average Cheta_AMI 4/7/2017 PM 1.14 Metro_AMI 4/7/2017 PM 1 Bala_AMI 4/7/2017 PM 0.25

Negative:

For 04/07/2017 PM there is no Negative Average

Please find the attached QVW and Data Excel for your reference and kindly help me out of this

Thanks

Muthu

4 Replies

## Re: How to Seperate Positive and Negative Average ?

Like this?

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

## Re: How to Seperate Positive and Negative Average ?

try like this

Positive :

if(sign(Expression)=1,Expression)

Negative:

if(sign(Expression)=-1,Expression)

Not applicable

## Re: How to Seperate Positive and Negative Average ?

what table ? Can you please tell me the name Of the table?

Give me example for data.

Not applicable

## Re: How to Seperate Positive and Negative Average ?

Kindly use formula in enable conditional formula in

Actual table +Ve:

(Toady- Previous day)/Previous day >= 0

Actual table +Ve:

(Toady- Previous day)/Previous day <= 0