topic Re: How to Seperate Positive and Negative Average ? in QlikView

How to Seperate Positive and Negative Average ?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a table like below

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

Re: How to Seperate Positive and Negative Average ?

Anil_Babu_Samineni — Tue, 06 Jun 2017 06:54:03 GMT

Like this?

Re: How to Seperate Positive and Negative Average ?

avinashelite — Tue, 06 Jun 2017 06:57:48 GMT

try like this

Positive :

if(sign(Expression)=1,Expression)

Negative:

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

Re: How to Seperate Positive and Negative Average ?

Tue, 06 Jun 2017 07:02:38 GMT

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

Give me example for data.

Re: How to Seperate Positive and Negative Average ?

Tue, 06 Jun 2017 07:17:05 GMT

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