Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Store selection as variables

Hi All,

Goodmorning:-)

How do I store my selections as variable. For example, if I select Fiscal Year 2011 in my application, which is a value in a list box called FISCAL_YEAR,

how do I store this selection in a variable so that do manipulations like any dates greater than Fiscal Year 2011.

Thanks,

Bikash

Tags (2)
1 Solution

Accepted Solutions
deepakk
Valued Contributor III

Re: Store selection as variables

Hi,

Go to  Set

tings-- > Variable overview --> add a variable and inside add the field name like = fieldname.

if you want to store year then say =max(Year).

For Ref, Try out the attach application.

Deepak

3 Replies
deepakk
Valued Contributor III

Re: Store selection as variables

Hi,

Go to  Set

tings-- > Variable overview --> add a variable and inside add the field name like = fieldname.

if you want to store year then say =max(Year).

For Ref, Try out the attach application.

Deepak

Not applicable

Store selection as variables

Hi Deepak,

Thanks for the help.

Could you please tell me how to do this.

Say the user selects Fiscal Year 2011 AND Quarter 1.

I need to count items created in this interval. i.e. from Start of FY11 Q1 to end of FY11 Q1.

Can you please tell me how to do this?

Thanks,

Bikash

deepakk
Valued Contributor III

Re: Store selection as variables

hi Bikas,

Can ou attach a sample application... If you have made your linking properly then your selection for FY11 an Q1 will provide you data as per that.

Chekc out what's new Qlikview 9 application. Go to Dashboard tab., The exmples will help you out.

If you can attach a sample application then i can help you out on this.

Community Browser