topic Selecting values based on multiple states in QlikView

Selecting values based on multiple states

cbushey1 — Thu, 02 Aug 2018 13:22:25 GMT

HI there,

I have a field, RiskFactor, that appears in 3 listboxes, 1 for each alternate state.

RiskFactor can not be selected in the default state.

What I want to do is select another field, Patient_Key, based on the selections made from the 3 alternate states (Risk 1, Risk 2, Risk 3).

Basically, this would give me only those Patient_Key's that have all of the RiskFactors that were selected and NOT just one of them (like a list box does).

Re: Selecting values based on multiple states

petter — Thu, 02 Aug 2018 13:49:53 GMT

In QlikView there is something called AND-mode which is meant for the purpose you are describing. A list box is default in an OR-mode but can be toggled into an AND-mode in it's properties dialog under certain conditions.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/And-mode%20in%20List%20Boxes.htm

AND-Mode

Re: Selecting values based on multiple states

cbushey1 — Thu, 02 Aug 2018 14:05:06 GMT

Peter thanks for mentioning that option.

How can I use that with the alternate states method I outlined?

Re: Selecting values based on multiple states

petter — Thu, 02 Aug 2018 14:37:58 GMT

How is your data model - specifically when it comes to the tables:

PATIENT

PATIENT_RISKFACTORS (if it exists)

and

RISKFACTORS

Re: Selecting values based on multiple states

cbushey1 — Thu, 02 Aug 2018 15:28:40 GMT

Patient table houses the Patient_Key field I am after, and it is joined to a table called RiskFactors which has two fields, Patient_ID and RiskFactor. PatientID is also in the Patient table so that is how they are joined.

Re: Selecting values based on multiple states

petter — Thu, 02 Aug 2018 18:21:21 GMT

With the AND-mode listbox you will not need the alternate states as you select all the risk factors from a single list box.

You multi-select by holding the CTRL-key down while clicking. You will see that the other possible selections will be in white and if these are not to be considered for the final selected patient you will have to turn them into NOT selections that have the ! and red background as an indicator. Read more about that in the links I gave you previously.

Re: Selecting values based on multiple states

cbushey1 — Mon, 06 Aug 2018 14:36:11 GMT

Peter,

Thanks for this approach but this doesnt really solve the question. I need a way to select the population in the default/current state, based on selections made in other states.

The example I listed is a simplified version of what I am doing in the application and many things are relying on the different states. The thing that will make what I built truly useful is being able to make this selection.