Segregate the value positive and negative.

[iahmadmca1]

Team,

jus want to let you know I have one expression which giving both values positive and negative based on expression want separate value for negative and positive could you please help me to do this.please find the below expression.

=Round((Sum(Rolling_1_days.Counts)-above(TOTAL sum(Rolling_1_days.Counts) ))/above(TOTAL sum(Rolling_1_days.Counts) ),0.001)

As for example:

Table:

Seasion	Degree
summer	5
winter	-5

output(positive)

A:

Seasion	Degree
summer	5

output (Negative)

B:

Seasion	Degree
winter	-5

Note: I need both outputs based on above expression.

Thanks,

Irshad Ahmad

[sunny_talwar]

Cool, please close this thread by marking correct and helpful responses.Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny