topic Scripting help please in QlikView

Scripting help please

Tue, 24 Apr 2012 08:18:42 GMT

hello everyone,

i have a littele difficulty in writing a script.

i have a long list of channel Ids and i i know which channel ID sold our product. Now for the purpose of overview i want to calculate a column which only show which different chanels were used before that sale was made.

i am using this left function

left('CIDconsecution.channel',Visitor.consecution) as List

but its always giving me invalid expression error. As the second parameter should be number. Is there anyother way to do this or any script help?

Regards,

Salman

Scripting help please

Michiel_QV_Fan — Tue, 24 Apr 2012 08:49:36 GMT

Set the Visitor.consecution as a variable

untested but something like this:

set vVisitor.consecution = 3;

left('CIDconsecution.channel',$(vVisitor.consecution)) as List

Scripting help please

Miguel_Angel_Baeyens — Tue, 24 Apr 2012 08:51:59 GMT

Hi Salman,

Which form has a sample line you want to modify? Left() function returns the n first (starting from left) characters of a given string or field, hence the second parameter needs to be a number or an expressionor variable that returns a numeric value. Is that what you need?

Hope that helps.

Miguel

Scripting help please

Jason_Michaelides — Tue, 24 Apr 2012 08:53:53 GMT

Can you post some sample data, or better still your app?

Scripting help please

Jason_Michaelides — Tue, 24 Apr 2012 09:08:43 GMT

SubField() will do it if I understand you correctly. Or a mixture of LEFT() and Index.

SubField(pfad,'Visitor.consecution',1)

Hope this helps,

Jason

Scripting help please

Wed, 25 Apr 2012 15:34:32 GMT

thanks everyone for the help.

Scripting help please

Jason_Michaelides — Wed, 25 Apr 2012 15:46:08 GMT

Giving yourself credit for the answer doesn't help other visitors to this thread knowing which solution worked for you!