topic Re: Different ways to declare variable in QlikView

Different ways to declare variable

Mon, 30 Nov 2015 06:08:06 GMT

Hi Experts,

Can any one explain me regarding different ways to declare a variable with an example...how to create

Thanks & regards,

Reddi Kishor

Re: Different ways to declare variable

raman_rastogi — Mon, 30 Nov 2015 08:19:57 GMT

The Magic of Variables

Creating variables in qlikview

Re: Different ways to declare variable

Anonymous — Mon, 30 Nov 2015 08:21:57 GMT

see this:

Creating variables in qlikview

The Magic of Variables

Re: Different ways to declare variable

Anonymous — Mon, 30 Nov 2015 08:22:31 GMT

this one as well

Variables in QlikView | Learn QlikView

Re: Different ways to declare variable

Mon, 30 Nov 2015 08:24:39 GMT

Hi kishor,

Following are the ways you can declare variables

1. Using Settings >> Variables Overview >>Add

Assign a value to the variable

2. Use keywords LET and SET in the coding window

Examples

Let C= 1+2

Treat as string

SET C = 1+2

Evaluate after = sign(numeric)

I hope this helps.

Regards,

Re: Different ways to declare variable

engishfaque — Mon, 30 Nov 2015 10:20:31 GMT

Dear Reddi,

Listed below are the ways through which you can create variables,

1. Using LET

2. Using SET

3. Through Variable Overview

4. Loading variables and values using For Loop in edit script such as given below,

tmp:

LOAD

VariableName,

VariableValue

FROM

sales.xls;

Let vNoRows = noofrows('tmp');

For I = 0 to $(vNoRows) - 1

Let vVarName = peek('VariableName', $(I), 'tmp');

Let vVarValu = peek('VariableValue', $(I), 'tmp');

Set $(vVarName) = "$(vVarValu)";

Kind regards,

Ishfaque Ahmed

Re: Different ways to declare variable

thakkarrahul01 — Mon, 30 Nov 2015 10:29:48 GMT

This blog link is also helpful to understand basics and usage scenarios:

http://www.analyticsvidhya.com/blog/2015/06/variables-qlikview-data-stories/

Kind Regards,

Rahul Thakkar