topic Re: Creating variables in qlikview in QlikView

Creating variables in qlikview

Thu, 05 Sep 2013 07:08:33 GMT

HI,

How to create variable in qlikview? I want to create a report in which I want to pass time fields(to & from) as input variables.

Please guide me on this.

Thank you

Re: Creating variables in qlikview

laujerry — Thu, 05 Sep 2013 07:12:08 GMT

Settings > Variable Overview

do u mean this?

Re: Creating variables in qlikview

techvarun — Thu, 05 Sep 2013 07:14:50 GMT

Settings -------> Variable Overview --------------> Add

Re: Creating variables in qlikview

techvarun — Thu, 05 Sep 2013 07:15:52 GMT

From and to Date?

Then this is the easiest example Easy Date Range Selection with Qlikview | Min-Maxing

Re: Creating variables in qlikview

Thu, 05 Sep 2013 08:03:49 GMT

Hi Shweta,

You can create variables in qlikview using following steps:

1. Go to Settings then Variable Overview

2. Once you click on variable overview

Click on Add and then you can add a name for the variable and value.

Hope this answers your first question.

For the second question, can you elaborate a little more?

Re: Creating variables in qlikview

Gabriel — Thu, 05 Sep 2013 08:20:59 GMT

Hi,

I hope you understand what Variable is and How it work.

Variable is STORED EXPRESSION, i.e vTotal = Sum(Sales)

Few place you can declare your variable are:

1- Go to Settings -> Variable -> Click ADD and declare your variable then Select the variable and assign expression to it as in vTotal and then Select vTotal, from the expression definition enter =Sum(Sales) or whatever your definition is.

2- Variable can also be use in the Script, you can declare variable in the script as this LET vDate = Today().

To do this, Select ctrl + E, after the last LET press RETURN and enter LET vDate = Today() or whatever your expression is.

The benefit of variable is, it help with expression maintenance in one place and this helps with expression re-usability.

Hope this helps

Best Regards,

Gabriel

Re: Creating variables in qlikview

Thu, 05 Sep 2013 08:46:24 GMT

hi Shyamal Pandit

Thanks for help. I am creating a report from 'Reports' menu for which I need user selectable dates. For ex. If i want to see values for a period of 1.08.2013 to 30.08.2013 then I want these two dates as inputs from user.

I hope this gives you more clarity.

Re: Creating variables in qlikview

Thu, 05 Sep 2013 10:23:19 GMT

Thank you all for help

Re: Creating variables in qlikview

Tue, 17 Mar 2015 09:18:53 GMT

Hi Shweta

Check this link

.http://www.learnallbi.com/variables-in-qlikview/

Re: Creating variables in qlikview

vvvvvvizard — Tue, 17 Mar 2015 12:27:00 GMT

CRT+AVL+V

aDD VARIABLE Name eg Cost

add variable expression in the definition field

reference the variable in a chart expression eg with $(Cost)

Re: Creating variables in qlikview

buzzy996 — Tue, 17 Mar 2015 12:31:55 GMT

creating variable is simply from Settings Menu-Variable overview

may be u can create 2 calendar objects for choose From Date & To Date ,that will give more meaning full.

Re: Creating variables in qlikview

Anonymous — Tue, 17 Mar 2015 16:21:57 GMT

Settings Menu--->Variable Overview or CTRL+ALT+V