Amount greater than 1 and less than 1 based on below 3 fields

[amita1621]

Hi,

Actually in excel when i am dividing the value so i am using 3 fields(Period, reinsurer , Reinsured code)

and from that using sim ifs it is calulcated >1 and <1 , same implication is qlikview has to be done.

I hope  this will help..

[neelamsaroha157]

Are you trying to separate +ve and _ve values?

If yes,

Sum({$<Amount={">$(=1)"}>}Amount)

Sum({$<Amount={"<$(=1)"}>}Amount)

[amita1621]

When we seperate using this way it gives +ive and -ive on amount basis , but i have to divide them based on reinsurer name and reinsurer name code as we have created pivot of reinsure, rein name code and amount and then by using sumifs have taken value, But how can this be implemneted in qlikview.

See the above screenshot for Rein payable and recivable one of excel and qlikview as attached.