topic Re: How to split the expression based on a condition? in QlikView

How to split the expression based on a condition?

priyav24 — Mon, 08 Jul 2013 06:03:15 GMT

Hello Everybody,

I Have a requriment that the expression Sum(voucheramount) should be splitted into two expression like one should contain all the negative values as credit and the other one should contain Positive Values as Debit..

Thanks in Advance,

Priya

Re: How to split the expression based on a condition?

tresB — Mon, 08 Jul 2013 06:05:45 GMT

Better do it in the script like this:

Load

If(voucheramount<0, voucheramount) as Credit,

If(voucheramount>=0, voucheramount) as Debit

From ....;

Re: How to split the expression based on a condition?

er_mohit — Mon, 08 Jul 2013 06:08:36 GMT

sum(if(voucheramount<0,voucheramount,null())) // for credit

sum(if(voucheramount>=0,voucheramount,null())) //Debit

make sure in peresentation tab check on suppress null value

Re: How to split the expression based on a condition?

priyav24 — Mon, 08 Jul 2013 06:10:48 GMT

Hi tresesco,

At the moment i could not reload ..Is there any other way to do it

Thanks,

Priya

Re: How to split the expression based on a condition?

priyav24 — Mon, 08 Jul 2013 06:12:48 GMT

Thanks Mohit ..

Re: How to split the expression based on a condition?

tresB — Mon, 08 Jul 2013 06:13:28 GMT

Then use Sum( If()) as suggested by Mohit if you are only looking for the Sum.