topic Re: Nested Pick(Match statements in QlikView

Nested Pick(Match statements

helen_pip — Tue, 15 Aug 2017 14:30:55 GMT

Dear Qlikview user

I have a Pick match statement which I am using to replace a nested If statement, however so far, my statement is ignoring all parts except the first part, highlighted in blue

I have tried to apply the same logic as the if, but it does not seem to be behaving as expected.

Could someone kindly point me in the right direction of how I can do a nested Pick(Match

NB: v_Flow_Graph_Arrival_Colour_Show will be 1 to activate the different colours

0 to activate the $(e_ED_Summary_Flow_Graph_Line_Colours)

=Pick(Match($(v_Flow_Graph_Arrival_Colour_Show) &'-'& Flow_Stage &'-'& ED_Mode,

'1-Before Stream-Amb',

'1-Before Stream-CarLike',

'1-Before Stream-Heli',

'1-Before Stream-Other')+1,

$(e_ED_Summary_Flow_Graph_Line_Colours) ,

$(e_ED_Summary_Flow_Graph_Arrival_Colour_Amb),

$(e_ED_Summary_Flow_Graph_Arrival_Colour_CarLike),

$(e_ED_Summary_Flow_Graph_Arrival_Colour_Heli),

$(e_ED_Summary_Flow_Graph_Arrival_Colour_Other),

Pick(Match(Flow_Stage &'-'& ED_Adm_Desc,

'After Stream-Admitted',

'After Stream-Non Admitted')+1,

$(e_Flow_Graph_Line_Colours),

$(e_Flow_Graph_Outcome_Colour_Admit),

$(e_Flow_Graph_Outcome_Colour_NotAdmit),

Pick(Match($(v_Flow_Graph_Stream_Colour_Show) &'-'& ED_Stream,

'1-EYE',

'1-CDU',

'1-MAJ',

'1-RES',

'1-PAE',

'1-MIN',

'1-CATH ',

'1-BRAM',

'1-UNU',

1-NO STREAM')+1,

$(e_Flow_Graph_Line_Colours),

RGB(255,128,103),

RGB(128,126,149),

RGB(1,124,194),

RGB(192,192,192),

RGB(97,138,158),

RGB(1,83,123),

RGB(90,184,214),

RGB(158,214,230),

RGB(226,243,245),

$(e_Flow_Graph_Line_Colours))

))

Re: Nested Pick(Match statements

sunny_talwar — Tue, 15 Aug 2017 14:36:43 GMT

Is this a single expression?

=Pick(Match($(v_Flow_Graph_Arrival_Colour_Show) &'-'& Flow_Stage &'-'& ED_Mode,

'1-Before Stream-Amb',

'1-Before Stream-CarLike',

'1-Before Stream-Heli',

'1-Before Stream-Other')+1,

$(e_ED_Summary_Flow_Graph_Line_Colours) ,

$(e_ED_Summary_Flow_Graph_Arrival_Colour_Amb),

$(e_ED_Summary_Flow_Graph_Arrival_Colour_CarLike),

$(e_ED_Summary_Flow_Graph_Arrival_Colour_Heli),

$(e_ED_Summary_Flow_Graph_Arrival_Colour_Other),

Pick(Match(Flow_Stage &'-'& ED_Adm_Desc,

'After Stream-Admitted',

'After Stream-Non Admitted')+1,

$(e_Flow_Graph_Line_Colours),

$(e_Flow_Graph_Outcome_Colour_Admit),

$(e_Flow_Graph_Outcome_Colour_NotAdmit),

Pick(Match($(v_Flow_Graph_Stream_Colour_Show) &'-'& ED_Stream,

'1-EYE',

'1-CDU',

'1-MAJ',

'1-RES',

'1-PAE',

'1-MIN',

'1-CATH ',

'1-BRAM',

'1-UNU',

1-NO STREAM')+1,

$(e_Flow_Graph_Line_Colours),

RGB(255,128,103),

RGB(128,126,149),

RGB(1,124,194),

RGB(192,192,192),

RGB(97,138,158),

RGB(1,83,123),

RGB(90,184,214),

RGB(158,214,230),

RGB(226,243,245),

$(e_Flow_Graph_Line_Colours))

))

What are these sections in Red and Green above? When do these get activated?

Re: Nested Pick(Match statements

helen_pip — Tue, 15 Aug 2017 14:50:16 GMT

Hello Sunny

Yes, this is a single expression and forms the background colour for a flow chart.

The part highlighted in Red will show a different colour to the part that is not highlighted in black

The part highlighted in green will determine the what colour the line will be, dependant on the ED_Stream field

I have attached a screenshot of how the colours look with the If statement, should a visual be more useful

Kind Regards

Helen

Re: Nested Pick(Match statements

sunny_talwar — Tue, 15 Aug 2017 15:03:21 GMT

I think you will have to do this in a single pick match.....

=Pick(Match($(v_Flow_Graph_Arrival_Colour_Show) &'-'& Flow_Stage &'-'& ED_Mode&'-'& ED_Adm_Desc&'-'$(v_Flow_Graph_Stream_Colour_Show) &'-'& ED_Stream,

and then proceed from there

Re: Nested Pick(Match statements

helen_pip — Tue, 15 Aug 2017 15:08:49 GMT

Thanks for your help, I will give it a go!

Thanks

Helen

Re: Nested Pick(Match statements

sunny_talwar — Tue, 15 Aug 2017 15:11:11 GMT

Awesome