topic Assigning Value to a variable at front End in QlikView

Assigning Value to a variable at front End

Anonymous — Wed, 17 Sep 2014 12:48:39 GMT

Hello All,

Can I assign a field value to a variable at front end, say in variable declaration.

I have tried through Vyear=max(Year), Vmonth=max(Month) but I want my Vmonth variable should take only available value of month corresponding to a year.

I have data till Sep 2014 , now as per date it shud take maximum value by default sep or 9 only but it is taking dec or 12.

On selection its working fine but not in case of default.

Is their any way to sort it out?

Regards,

Balraj

Re: Assigning Value to a variable at front End

Wed, 17 Sep 2014 12:55:58 GMT

pls attach sample document

Re: Assigning Value to a variable at front End

Wed, 17 Sep 2014 13:05:20 GMT

What do u mean when u say available value of the month?

It would be great if u could post a sample app.

Re: Assigning Value to a variable at front End

sunilkumarqv — Wed, 17 Sep 2014 13:34:05 GMT

Hi,

by default you want show max year then use below in expression

Sum({<Year={$(=Max(Year))}>}Amount)