Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

How to Seperate Positive and Negative Average ?

Hi All,

I have a table like below

Screenshot_2.png

The Average is been Calculated based on Below formula:

Formula:

(Toady- Previous day)/Previous day

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 NameDateAverage
Metro_AMI4/9/2017 PM0.50

Negative;

TGB NameDateAverage
Bala_AMI4/9/2017 PM-0.78
Cheta_AMI4/9/2017 PM-0.85


For (04/08/2017 PM):

Positive:

TGB NameDateAverage
Bala_AMI4/8/2017 PM0.80
Metro_AMI4/8/2017 PM0.33

Negative:

TGB NameDateAverage
Cheta_AMI4/8/2017 PM-0.13

For (04/07/2017 PM):

Positive:   

TGB NameDateAverage
Cheta_AMI4/7/2017 PM1.14
Metro_AMI4/7/2017 PM1
Bala_AMI4/7/2017 PM0.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?

Capture.PNG

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)

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