topic Re: Segregate the value positive and negative. in QlikView

Segregate the value positive and negative.

iahmadmca1 — Wed, 24 May 2017 14:50:20 GMT

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)

Seasion	Degree
summer	5

output (Negative)

Seasion	Degree

winter	-5

Note: I need both outputs based on above expression.

Thanks,

Irshad Ahmad

Re: Segregate the value positive and negative.

sunny_talwar — Wed, 24 May 2017 14:53:49 GMT

May be this, table 1

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

table2

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

Re: Segregate the value positive and negative.

iahmadmca1 — Wed, 24 May 2017 15:51:59 GMT

Thanks, Sunny.let me try and get back to you

Re: Segregate the value positive and negative.

iahmadmca1 — Wed, 24 May 2017 15:55:52 GMT

Sunny i tried your expression but its not working, could you please give the other logic for achieving this problem.

Re: Segregate the value positive and negative.

sunny_talwar — Wed, 24 May 2017 15:59:18 GMT

Logic is simple... for the first table where you want to just show positive values, I am forcing negative values to be 0 using RangeMax()

RangeMax(Expression, 0) -> When Expression gives 5 -> 5> 0 -> 5

When Expression gives -5 -> -5 < 0 -> 0

Similarly, picking the negative values in the second table and forcing positive values to be 0 using RangeMin() function

Re: Segregate the value positive and negative.

iahmadmca1 — Wed, 24 May 2017 16:14:21 GMT

Sunny i have one straight table which is containing both values positive and negative from that table value i want to separate in two table.

source Table expression:

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

Source Tabel:

Seasion	Degree
summer	5
winter	-5
summer	4

Output table

Seasion	Degree
summer	5

summer	4

Output table.

Seasion	Degree

winter	-5

Note: don't consider the blank field of table A and B I need only value

Thanks,

Irshad Ahmad

Re: Segregate the value positive and negative.

sunny_talwar — Wed, 24 May 2017 16:15:58 GMT

That is what it should do my friend.... if you can share a sample where it isn't working, I can pinpoint the issue...

Re: Segregate the value positive and negative.

iahmadmca1 — Wed, 24 May 2017 16:36:49 GMT

Now it is working Sunny I did small changes in dimension thank for your collaboration.

Re: Segregate the value positive and negative.

sunny_talwar — Wed, 24 May 2017 16:37:31 GMT

What was the change in dimension that you made?

Re: Segregate the value positive and negative.

iahmadmca1 — Wed, 24 May 2017 16:48:47 GMT

I am using Rolling_2_days.Counts instead of Rolling_1_days.Counts that is it.

Re: Segregate the value positive and negative.

sunny_talwar — Wed, 24 May 2017 16:54:52 GMT

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

Best,

Sunny