topic Re: Need a variable to assign , help needed in QlikView

Need a variable to assign , help needed

Wed, 15 Feb 2012 09:51:52 GMT

I am new to qlikview and i need a help , I am having a column with ids for ex

aa32eee

aa22rrrd

bb24rtrt

cc65sdf

I need to assign all the ids to a variable which should be like , so that i can use this variable in the script wherever i nee

'aa32eee','aa22rrrd','bb24rtrt','cc65sdf'

Need a variable to assign , help needed

CELAMBARASAN — Wed, 15 Feb 2012 09:56:26 GMT

Hi,

Try with this

vVariable= chr(39)&Concat(ID,chr(39)&','&chr(39));

Hope it helps

Celambarasan

Need a variable to assign , help needed

SunilChauhan — Wed, 15 Feb 2012 09:57:55 GMT

control +alt +v

add -> varable name

vID=Concat(ID,',')

use

=$(vID) to text or any where your want

directely

vID=Concat(ID,',')

hope this helps

Re: Need a variable to assign , help needed

Anonymous — Wed, 15 Feb 2012 10:15:08 GMT

Hope the attached file will be clarified your doubt and help to get solution for your problem

Regards

Ashok

Re: Need a variable to assign , help needed

Anonymous — Wed, 15 Feb 2012 10:16:06 GMT

Attached Sample file

Re: Need a variable to assign , help needed

Wed, 15 Feb 2012 10:58:28 GMT

In the attached sample, the month jan and feb are hardcoded... But how you can get the month field name alone so that it will display 'jan',feb','mar'

Re: Need a variable to assign , help needed

Wed, 15 Feb 2012 11:00:49 GMT

When i try your code i am getting a eroor while loading the script

LET vVariable= chr(39)&Concat(OPRID,chr(39)&','&chr(39))

Error: Aggregation expressions not allowed in GROUP BY clause

Re: Need a variable to assign , help needed

Anonymous — Wed, 15 Feb 2012 11:14:21 GMT

Hope this will be helpful for your problem

Concat(chr(39)&ID&chr(39), ',')

use this in your script load

refer the sample attached qv file

Regards

Need a variable to assign , help needed

SunilChauhan — Wed, 15 Feb 2012 11:23:06 GMT

use below code

set vcon=concat(Month,',');

Data:

LOAD * INLINE [

Product, Year, Month,Sales

A, 2011, Jan, 1000

A, 2012, Feb, 2000

A, 2013, Mar, 3000

];

and use in text box

$(vcon)

hope this helps

Re: Need a variable to assign , help needed

Anonymous — Wed, 15 Feb 2012 11:41:13 GMT

In Loding Script , use this

set vVar = Concat(chr(39)&Month&chr(39), ',');

Data:

LOAD * INLINE [

Product, Year, Month,Sales

A, 2011, Jan, 1000

A, 2012, Feb, 2000

A, 2013, Mar, 3000

];

and use in text box

$(vVar)

it will return the answer like this

'Feb','Jan','Mar',

for that variable

Regards

Ashok

Re: Need a variable to assign , help needed

CELAMBARASAN — Wed, 15 Feb 2012 11:47:06 GMT

Hi,

Where you going to use the variable expression?in Load script or in charts?

Celambarasan

Re: Need a variable to assign , help needed

Wed, 15 Feb 2012 11:55:08 GMT

In the script... i want to load some user id in a variable so that i can use the variable in any number of table to exclude the user id in that variable.

Need a variable to assign , help needed

CELAMBARASAN — Wed, 15 Feb 2012 12:02:52 GMT

Hi,

To use in Load

IDTable:

Load *Inline

[ID

aa32eee

aa22rrrd

bb24rtrt

cc65sdf];

TempID:

Load

chr(39)&Concat(ID,chr(39)&','&chr(39)) as ALLID

Resident

IDTable:

LET vID= FieldValue('ALLID',1);

Drop Table TempID;

Hope it helps

Celambarasan

Re: Need a variable to assign , help needed

jemancilla — Thu, 26 Apr 2012 23:21:33 GMT


IDS:
load * inline [
ID
aa32eee
aa22rrrd
bb24rtrt
cc65sdf
]
;

SET vVariable = '';
For i=0 to NoOfRows('IDS')-1
          If len('$(vVariable)')>0 then 
          Let vVariable='$(vVariable)'&Chr(44)&Peek('ID',$(i),'IDS');
          ELSE
          Let vVariable=Peek('ID',$(i),'IDS');
          END iF
NEXT i
;