Restriction in analytic view

[Former Member]

Dear Experts,

We

I am facing a issue in analytic view.  below is my requirement.

Del Doc No	Item	Item Category	Qty
12345	10	KPT	12
12345	20	KPT	15
12345	30	KPT	20
12345	40	ZTPY	30
12345	50	ZTPY	25
12345	60	ZTPY	28

In the above scenario, if Item Category is Equal to'KPT' then only quantity should display, Other than Item Category'KPT'  quantity should be '0'.

As per our business requirement data should be like below.

Del Doc No	Item	Item Category	Qty
12345	10	KPT	12
12345	20	KPT	15
12345	30	KPT	20
12345	40	ZTPY	0
12345	50	ZTPY	0
12345	60	ZTPY	0

Please help me how to restrict in Analytic view.

Thanks,

Nag

[anindya_bose · Accepted solution]

Hi, use Formula to achieve this ( Calculated Column ) .

If Item Category is KPT, multiply Qty with 1 , if  ZTPY , multiply with 0.

Do you have any other category apart from these two ?

Cheers

Anindya

[Former Member · Accepted solution]

Hi Anindya,

Thanks for your prompt responce.

i am requesting you, Please tell me the syntax which i need to write in calculated column.

Thanks,

Nag

[Former Member]

Hi All,

Thanks for your post.

its got completed.

Thank you

[former_member200930]

Hi Nag,

Crate Calculated Measure column at top level and integer should be data type

Please use following formula

if(isnull("Item_category"),0,if("Item_category" ='KPT','QTY',0))

First it will check "Item_Category" column for null, if yes the it will return ZERO otherwise, it will check for next condition. If "Item Category" belongs to KPT then it will return actual quantity else it will return zero.

At the semantic level, Please hide your "QTY" column.

I hope, this will solve your problem.

Regards,

Vikram Divekar

[Former Member]

Hi Nag,

You could create a Restricted column on Qty (may be call it KPT_QTY)  with Restriction on Item Category Equal to 'KPT'. The new KPT_QTY column will contain values only for category KPT and null for all others.

Let me know if this helps.

Thanks,

Nithya V

[Former Member]

Hello Nag,

Use an input parameter (IP_item_category) to get the values of the category (if they are more than 2).

Parameter Type: Column

Column:

Give relevant values for

1. View/Table for input help

2. Reference Column

To choose appropriate category.

As Anindya suggested above, use a Formula to create new calculated column.

Alternate formula id categories more than 2:

IF (("$$IP_item_category$$"="item category"), "qty", '0000')

BR,

Vikash