topic Re: How to add a code dynamically in QlikView

How to add a code dynamically

Sat, 17 Sep 2016 17:37:32 GMT

I have a scipt which is,

If(Match(Book, '101', '102', '103') and Year(RecordDate) = '2016', '1') as BookRecordFlag

I want to use a input box to dynamically add more data in this statement and store as BookRecordFlag. If I enter 110 in the input box, it should add that value in the match statement where the statement will look like this If(Match(Book, '101', '102', '103', '110') and Year(RecordDate) = '2016', '1') as BookRecordFlag. I am pulling this BookRecordFlag in a frontend object and I want this object to reflect the new code. Is it possible?

Re: How to add a code dynamically

marcus_sommer — Sun, 18 Sep 2016 07:33:34 GMT

You could try:

If(Match(Book, '101', '102', '103', '$(vInputboxVariable)') and Year(RecordDate) = '2016', '1') as BookRecordFlag

- Marcus

Re: How to add a code dynamically

Mon, 19 Sep 2016 06:05:30 GMT

Thanks Marcos, I tried this but it did not work. I created a input box and entered a value for vInputboxVariable, it does not show the entered value. is there any other way?

Re: How to add a code dynamically

Anonymous — Mon, 19 Sep 2016 06:23:39 GMT

Hi Enthu,

You can add a variable, and concatenate with last value of the same variable if the new input value doen't exists on it, for example:

If(Len(YourVarName)=0,InputBoxValue,

If(SubStringCount(YourVarName,InputBoxValue)=0,YourVarName&','&chr(39)&InputBoxValue&chr(39),YourVarName))

Then, on your expression, If(Match(Book, '$(YourVarName)') and Year(RecordDate) = '2016', '1') as BookRecordFlag

Regards!

Re: How to add a code dynamically

marcus_sommer — Tue, 20 Sep 2016 06:13:51 GMT

What didn't work? Which client do you use? How do you execute the reloal?

- Marcus

Re: How to add a code dynamically

Anil_Babu_Samineni — Tue, 20 Sep 2016 07:31:37 GMT

Marcus solution solution should work

If(Match(Book, '101', '102', '103', '$(vInputboxVariable)') and Year(RecordDate) = '2016', '1') as BookRecordFlag

Have you created this variable on your machine vInputboxVariable?

OR Else please share more information which part you stucked after using Marcus solutions