topic Re: List Based On Current Selections in QlikView

List Based On Current Selections

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a List Box, which on selecting displays all the selections based on primary indicator Y or N. But my requirement is to first check whether current selections have the Spouse selected along with Name, if Selected then should display only the Id's with Prim Ind ='Y'. Based on the Current selections of ID it should display both Prim Ind is Y or N but only if current selections don't have spouse selected. I have attached the sample excel file and QVW. Let me know how we can do this?.

Re: List Based On Current Selections

Tue, 18 Apr 2017 16:27:42 GMT

Possibly add the flag to your table that comply all the conditions and use flag in your List Box expression.

Re: List Based On Current Selections

Tue, 18 Apr 2017 17:02:55 GMT

I tried with the flag but I still couldn't get the correct result. I need to get the ID's from the current selection and possibly match those with the P(Spouse ID). I am figuring out how we can do this on front end based on current selections.

Re: List Based On Current Selections

adamdavi3s — Tue, 18 Apr 2017 18:21:34 GMT

Its late and my brain isn't quite working, but does this do what you need?

= if((aggr(count(TOTAL [SpouseCount]),ID)>1 and [Prim Ind]='Y') OR (aggr(count(TOTAL [SpouseCount]),ID)=1) ,Name)

Re: List Based On Current Selections

Tue, 18 Apr 2017 18:41:31 GMT

Davies, I had written the similar expression but it's still doing the same thing as before like removing the [Prim Ind]='N' values. Actually my scenario is I should get distinct Spouse values based on PrimaryID. The PrimaryID is same for both prim Ind= Y and Prim Ind =N, but when both are in the current selections I should get only Prim Ind='Y' when List is selected. when only one spouse is in the current selections I should get it displayed when List is selected. This is really tough but there might be some way to do it but couldn't figure out.