Passing Multiple Alternate selections to Straight Table

[mkiran_18]

Hi All,

I have a data set with Filed's

ISID,CSID,A/P,IPO,ISO,IS Status and Seg Levels 01 to 10 like Seg Level 1, Seg level2...

I have created 10 Multi boxes with each Multi box is having fields Seg level 1 to Seg Leve 10.

I created 10 different alternate states like STATE1 to STATE10 and passed these sates to 10 multi boxes.

Now i want to create a Straight table with

DIMS: ISID,CSID,A/P,IPO,ISO,IS Status

Expression as: IS Status .

Please help me how to pass the selections from each Multi box with corresponding Alternate sates and filter the data in straight table.

Thanks in Advance.

[andrey_krylov]

Hi. You can pass alternate state selections to expressions using set analysis, for example

sum({State0< Field1 =State1:: Field1,  Field2 =State2:: Field2 > } Amount )

[mkiran_18]

Hi Andrey,

Thanks for your response.

What i am looking for is ,let us say

if i select Field 1 , Field 2 from State 1 and Field 3 and Field 4 from State 2, how to pass all selections into set analysis expression.

sorry i am very new to work alternate states.

Thanks in advance.

[andrey_krylov]

I guess it will be like this

sum({< [Field 1]=[State 1]::[Field 1],  [Field 2]=[State 1]::[Field 2],  [Field 3]=[State 2]::[Field 3],  [Field 4]=[State 2]::[Field 4] > } Amount )

[mkiran_18]

Thank you Andrey.

I will implement in my application and test the data.

Regards

M Kiran

[mkiran_18]

Hi Andrey,

Please find the sample application that i am using to implement the above scenario.

In my application i want to create a straight table based on the selections from State 1, State 2 and State 3 multi boxes.

I have created variables to pass the selections from each list box in each multi box which are in different alternate states.

Could you please check it once and help me on this.

Thanks,

Mani Kiran D

[andrey_krylov]

Hi Mani. I looked at the file but did not understand what we want to get. Can you explain in more detail?

[mkiran_18]

Hi Andrey,

Let us say if i select some selections from Default filters and we got only one product code (5312) as per my selections.

And i created a straight table based on this.

Selections From Default Filters:

Similarly if i select the same selections from Alternate states multi boxes i need to replicate the same straight table with the selections from Alternate states selections.

I have created variables to pass the selections from Alternate states.

All these fields are from the same single table.

Please let me know if you still need any information on this.

Thanks in Advance.

[mkiran_18]

Hi Andrey,

I have attached the application again, in that there are 2 tables, Table - Default Selections and Table - Alternate Selections.

I just want the same data filtered out in "Alternate selections table" based on selections from Multi boxes which are in 3 different sates.

Is there any way to pass the variables that i created in to "Alternate selections table" dimensions or expressions so that we will get the same data as of "Default Selections table".

Please let me know if you still unclear of the requirement.

Thanks

[andrey_krylov]

Ok,  Mani. But what if you are making selections for one field in three different Multi boxes. What should be the result then? Look at the attachment, there is a logical AND for different states.