topic Re: Re: Need 'If' help !!! in QlikView

Need 'If' help !!!

ajaykumar1 — Mon, 02 Jun 2014 17:05:16 GMT

Hi Everyone,

I have the small req like below and attached the sameple data as well and i have to develop the same at design level.

If ACTUAL BALANCE is -ve then we have to replace with 0 for all the products.

If PRODUCTS FD/RD have blank then we have replace TARGET BALANCE by ACTUAL BALANCE along with the above condition.

The sample output has been attached.

Thanks,

Ajay

Re: Need 'If' help !!!

Mon, 02 Jun 2014 17:16:38 GMT

EDITED

I think this is what you're looking for....see attached

TEST:

LOAD * INLINE

[

ITEM,ACTUALBALANCE,TARGETBALANCE,TYPE

100,-980,,CA

101,345,4564,SA

102,454,56563,CA

103,-230,2525,SA

104,-42344,,FD

105,25252,,RD

106,4524525,,FD

107,78787,,RD

108,5878,,FD

109,4554,1234,SA

110,456,535,CA

];

TEST2:

LOAD

ITEM,

if(ACTUALBALANCE < 0, 0, ACTUALBALANCE) as ACTUAL,

TYPE,

if(TYPE = 'FD' OR TYPE = 'RD', if(ACTUALBALANCE < 0, 0, ACTUALBALANCE), TARGETBALANCE)AS TARGET

RESIDENT TEST;

DROP TABLE TEST;

Re: Need 'If' help !!!

ajaykumar1 — Mon, 02 Jun 2014 17:17:38 GMT

Any hint from anyone...

Re: Need 'If' help !!!

ajaykumar1 — Mon, 02 Jun 2014 17:23:37 GMT

Thanks Christian...Its good..But i have to develop the same in Design level.Because all the fields are coming from various qvd's in data model.

Thanks,

Ajay

Re: Re: Need 'If' help !!!

Mon, 02 Jun 2014 17:35:57 GMT

Updated sample, not sure if this is still off but hopefully leads you in the right direction.

Re: Need 'If' help !!!

ajaykumar1 — Mon, 02 Jun 2014 17:36:24 GMT

Any suggestions from anyone....

Thanks,

Dhanu

Re: Need 'If' help !!!

its_anandrjs — Mon, 02 Jun 2014 17:37:53 GMT

Let me know what do you mean by Design level (it is on front end or may be it is on load script level).

Re: Need 'If' help !!!

ajaykumar1 — Mon, 02 Jun 2014 17:40:02 GMT

We need to develop at front end.

Re: Re: Need 'If' help !!!

venkatg6759 — Mon, 02 Jun 2014 17:43:23 GMT

Check the attachment

Re: Re: Need 'If' help !!!

its_anandrjs — Mon, 02 Jun 2014 18:20:02 GMT

On the straight table write Dimension expression like

Dimension:- Item

Dimension:- Type

Exper(For Actual):- if(sum( ACTUALBALANCE) < 0 ,0, sum(ACTUALBALANCE))

Exper(For TARGET):- if(TYPE = 'FD' OR TYPE = 'RD', if(sum(ACTUALBALANCE) < 0, 0, sum(ACTUALBALANCE)), Sum(TARGETBALANCE))

Re: Need 'If' help !!!

ajaykumar1 — Tue, 03 Jun 2014 16:27:49 GMT

Thanks Venkat and Anand...Its working.