topic Selections from Alternate selections to Straight table in QlikView

Selections from Alternate selections to Straight table

mkiran_18 — Mon, 01 Oct 2018 18:52:06 GMT

Hi All,

Please find the sample application that i am using to implement the 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.

My requirement is Product code should be same if i select selections manually and from Alternate States.

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 in Advance.

Thanks,

Mani Kiran D

Re: Selections from Alternate selections to Straight table

sunny_talwar — Mon, 01 Oct 2018 19:20:54 GMT

What exactly do you want to happen in straight table based on selection in different alternate state?

Re: Selections from Alternate selections to Straight table

mkiran_18 — Mon, 01 Oct 2018 19:28:24 GMT

Hi Sunny,

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, so that we can see the same data for Product Code 5312.

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

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

Thanks in Advance

Thanks,

Mani Kiran D

Re: Selections from Alternate selections to Straight table

sunny_talwar — Mon, 01 Oct 2018 19:36:58 GMT

Based on the selections made in the image above... what would you straight table need to look like?

Re: Selections from Alternate selections to Straight table

mkiran_18 — Mon, 01 Oct 2018 20:00:59 GMT

Hi Sunny,

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