topic Re: Passing Multiple Alternate selections to Straight Table in QlikView

Passing Multiple Alternate selections to Straight Table

mkiran_18 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Passing Multiple Alternate selections to Straight Table

andrey_krylov — Sat, 29 Sep 2018 15:36:29 GMT

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

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

Re: Passing Multiple Alternate selections to Straight Table

mkiran_18 — Sat, 29 Sep 2018 18:40:09 GMT

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.

Re: Passing Multiple Alternate selections to Straight Table

andrey_krylov — Sat, 29 Sep 2018 18:51:56 GMT

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 )

Re: Passing Multiple Alternate selections to Straight Table

mkiran_18 — Sat, 29 Sep 2018 18:58:01 GMT

Thank you Andrey.

I will implement in my application and test the data.

Regards

M Kiran

Re: Passing Multiple Alternate selections to Straight Table

mkiran_18 — Mon, 01 Oct 2018 18:44:35 GMT

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

Re: Passing Multiple Alternate selections to Straight Table

andrey_krylov — Mon, 01 Oct 2018 19:00:15 GMT

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

Re: Passing Multiple Alternate selections to Straight Table

mkiran_18 — Mon, 01 Oct 2018 19:21:56 GMT

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.

Re: Passing Multiple Alternate selections to Straight Table

mkiran_18 — Mon, 01 Oct 2018 20:11:34 GMT

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

Re: Passing Multiple Alternate selections to Straight Table

andrey_krylov — Tue, 02 Oct 2018 03:11:40 GMT

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.

Re: Passing Multiple Alternate selections to Straight Table

mkiran_18 — Tue, 02 Oct 2018 05:29:17 GMT

Hi Andrey,

If the user select one field in one multi box, he should not select the same field from another multi box.

For example if we select 'Dairy' as Product Category from Multi box 1, then he should not select the 'Product Category' from other 2 Multi boxes.

As per the requirement its working fine, i will implement the same thing in my original application and get back to you.

Thanks a lot Andrey.