topic Variables in QlikView

Variables

Anonymous — Wed, 16 Nov 2011 06:02:29 GMT

Using Variable any idea to store Tables

Variables

SunilChauhan — Wed, 16 Nov 2011 06:16:27 GMT

can come again in brief?

Re: Variables

Anonymous — Wed, 16 Nov 2011 06:22:41 GMT

set Variable = select * from Employee like wise

let Variable = Variable + select * from Employee like wise

Re: Variables

johnw — Thu, 17 Nov 2011 01:25:11 GMT

Maybe this?

LOAD *
;
SQL
SELECT EmployeeName
FROM Employee
WHERE EmployeeID = 12345
;
LET Variable = peek('EmployeeName')
;

Re: Variables

Anonymous — Thu, 17 Nov 2011 11:18:53 GMT

Hi john,

i want to stroe all columns in one Variable.is it possible...Variable is like a function in sqlserver right..in sqlserver we write three type of function ..Tabled Value Function it returns Tables,Scalar Value Function it Returns Values and Aggregate functions it Return Grouped Value.....but in qlikview we write only Scalar Value Function...Variable Returns Values Only..is Any way to return Tables...

LOAD *
;
SQL
SELECT EmployeeName,EmployeeID,Salary,Department
FROM Employee
;
LET Variable = peek('EmployeeName',' EmployeeID','Salary','Department');

is it Correct?

Re: Variables

johnw — Fri, 18 Nov 2011 00:38:00 GMT

A variable isn't a function. It's just a place to store a value.

Maybe this?

LET Variable = peek('EmployeeName') & ',' & peek('EmployeeID') & ...;

That just gives you one row, though. All columns, one row. All columns, all rows, comma delimited would look something like this:

LOAD concat(EmployeeName & ',' & EmployeeID & ...,'
') as AllMyData; // is is important that this is on a separate line - it's how you get separate lines in your data
SQL
SELECT EmployeeName,EmployeeID,...
FROM Employee
;
LET Variable = peek('AllMyData');

I don't have any idea why you'd do something like that, but you could.