Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)