Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Assigning Value to a variable at front End

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

3 Replies
Not applicable
Author

pls attach sample document

Not applicable
Author

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

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

sunilkumarqv
Specialist II
Specialist II

Hi,

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

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