topic Re: logic Help in QlikView

logic Help

abhaysingh — Tue, 07 Apr 2015 10:33:20 GMT

hey Guys,

i have one field Which contain a field AB i want to rename it in Two name in a existing field only,

.i.e. if( field = 'AB', 'AB1' or if (field = 'AB' ,'AB2' ), Field)

is it wrong?

Re: logic Help

stabben23 — Tue, 07 Apr 2015 11:40:36 GMT

This logic is fail, you have to decide if AB should be AB1 or AB2 not both.

Re: logic Help

Tue, 07 Apr 2015 11:48:16 GMT

Hey Abhay...

The OR logic itself works in a manner when first condition stands true, it won't go for next condition. So it will not allow you to rename twice using same condition.

Re: logic Help

Tue, 07 Apr 2015 11:51:26 GMT

Could you explain what you want to achieve?

I not understand from your example

Re: logic Help

Tue, 07 Apr 2015 11:51:38 GMT

you can't identify same time one field as 2 different name.

Re: logic Help

abhaysingh — Tue, 07 Apr 2015 11:57:57 GMT

Dear Chandana,

i have one field which contain hundreds of value, from hundreds of value i have one code let say LH, for which i am getting Sales Value, and for that LH Code, client given me two bifurcated target on the basis of Percentage. i.e LH1 contain 55% of total sales and LH2 is 45 % of Total Sales.

Now i want To bifurcate LH in to LH1 and LH2 and Mappe target with actuals.

NOTE- rest all value codes excepect LH should give 100% actuals and Target

thanks