topic Re: Create a variable for code based on selection in QlikView

Create a variable for code based on selection

Fri, 15 Jan 2016 03:10:12 GMT

Hello,

I am hoping to create a variable that I can use multiple times in a code. It should be based on a selection of a list box.

For example, I created a list box called Age_Group. When the user selects '30-39' in the Age_Group box, I want string '30-39' to be put in the equations below in the place of the variable vAge. Below is the code that I tried:

set vAge = [Age_Group];

Expression:
load * inline [
Expression, Exp
'Medical Incurred', sum({<Age_Group= {$(vAge)}>} T_ITD_INCRD_MED_AMT)/sum(total <Accident_Year> T_ITD_INCRD_MED_AMT)
'Indemnity Incurred', sum(<Age_Group> T_ITD_INCRD_INDM_AMT)/sum(total <Accident_Year> T_ITD_INCRD_INDM_AMT)
'Indemnity Paid', sum({<Age_Group= {$(vAge)}>} T_ITD_PD_INDM_AMT)/sum(total <Accident_Year> T_ITD_PD_INDM_AMT)
];

Side note: I am already taking 2 different list boxes into account when creating these equations, hence why I already used the load inline statements. I am open to any other suggestions that involve taking several fields. It gets a bit complicated when looking at percentages of a whole set number. I'm trying my best at learning set analysis

Thanks for any help you can provide!

Re: Create a variable for code based on selection

tresB — Fri, 15 Jan 2016 05:19:23 GMT

This way you can't pass your selection to script (during load). Instead of loading the expressions, define variables in the front-end.

Re: Create a variable for code based on selection

Fri, 15 Jan 2016 18:36:50 GMT

Thank you for your response! Can you please clarify what you mean? I tried moving the set vAge = [Age_Group];
to the very beginning of the script, but this didn't seem to work.

Re: Create a variable for code based on selection

tresB — Mon, 18 Jan 2016 06:06:41 GMT

Open your application-> press Ctrl+Alt+V , you would get the variable overview window where you can define variables in the front-end. The variavles defined in here, are responsive to selection.

Re: Create a variable for code based on selection

Wed, 20 Jan 2016 13:07:11 GMT

Thank you, this worked!

It didn't end up working in the inline statement like I had above, so instead I used conditional hide/ unhide under expressions. For anyone's reference, I used this equation:

=sum({$<Age_Group= {'$(vAge)'}>} T_ITD_INCRD_INDM_AMT)/sum(T_ITD_INCRD_INDM_AMT)