topic Re: how to pass values in a variable in QlikView

how to pass values in a variable

Anonymous — Thu, 27 Apr 2017 09:20:51 GMT

I need to show a list box with values Weekly , Monthly

If the user selects Weekly then I need to execute a set of conditions and if the user selects monthly then another set of conditions need to be executed.

I wanted to create single variable that will accept weekly and monthly values and then use a nested if to execute these conditions.

What i cant figure out is how to create this varibale in a script to take weekly and monthly values and how to create a listbox around it?

Any ideas on this are most welcome!!!

Re: how to pass values in a variable

prieper — Thu, 27 Apr 2017 10:27:17 GMT

If a listbox is required you may load an island table in your script

IntervalSelector: LOAD * INLINE [Interval

Monthly

Weekly];

and choose "Only one selected value".

All conditions then may refer to these fields:
PICK(MATCH(Interval, 'Monthly', 'Weekly'), condition month, condition week)

Similarly you may work with variable an then an inputbox, where entry is retricted to just these two values...

HTH Peter

Re: how to pass values in a variable

Anonymous — Thu, 27 Apr 2017 11:32:30 GMT

Thanks Peter.. I will use this suggestion