topic Re: Store selection as variables in QlikView

Store selection as variables

Tue, 14 Jun 2011 16:29:25 GMT

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

Re: Store selection as variables

deepakk — Tue, 14 Jun 2011 16:55:15 GMT

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

Store selection as variables

Tue, 14 Jun 2011 17:49:33 GMT

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

Re: Store selection as variables

deepakk — Wed, 15 Jun 2011 10:56:12 GMT

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.