Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fkeuroglian
Honored Contributor

Create variable in sense

Hi expert

I would like to create a variable like =date(firstworkdate (Max(Fecha), 1),'DD/MM/YY'), i have to create in  the script?

can i use this kind of function?

thank you a lot

Fernando

Tags (4)
1 Solution

Accepted Solutions
sod
Contributor

Re: Create variable in sense

Hi Fernando,

Yes, you can create expression variables in the Qlik Sense script, and call them when needed.

Example:

SET vMeasure1 = date(firstworkdate (Max(Fecha), 1),'DD/MM/YY');

You can call this example variable by entering $(vMeasure1) as a new measure to any user interface object.  May I also make a suggestion that you can also fulfil this requirement by creating a Qlik Sense measure master item.  With this method, users can drag-and-drop the custom measure to any number of objects on the UI.  This method also avoids the need to memorize every measure variable during the development process.

Cheers,

Sean

3 Replies
sod
Contributor

Re: Create variable in sense

Hi Fernando,

Yes, you can create expression variables in the Qlik Sense script, and call them when needed.

Example:

SET vMeasure1 = date(firstworkdate (Max(Fecha), 1),'DD/MM/YY');

You can call this example variable by entering $(vMeasure1) as a new measure to any user interface object.  May I also make a suggestion that you can also fulfil this requirement by creating a Qlik Sense measure master item.  With this method, users can drag-and-drop the custom measure to any number of objects on the UI.  This method also avoids the need to memorize every measure variable during the development process.

Cheers,

Sean

dineshsingh
New Contributor III

Re: Create variable in sense

,

Can we use LET instead of SET?

sod
Contributor

Re: Create variable in sense

Hi Dinesh,

Yes, LET commands can be used in the Qlik Sense script editor as well.