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

Possibility of selecting only values below variable

Hi,

Problem seems to be easy to solve.

I have 2 Years: 2015 and 2016 nad months connected to it.

sty is Jan, lut is Feb etc.

My Calendar has 12 months (field Month)

picture.jpg

My max date which i want to have possibility of selecting is lut (Feb) 2016.

My variable - vDateClosed is 2016-02 (table Year-Month connected with table Month).

So i want to see all months but have possibility of selecting only Jan and Feb in 2016.

In 2015 i want to select all months.


Please help.

Thank You in Advance,

Jacek Antek

1 Solution

Accepted Solutions
Digvijay_Singh

Pl Chk  I have done it here, may be this can help.

You may need to play with date format based on your format etc.

View solution in original post

5 Replies
Digvijay_Singh

I think you need field trigger(Select in field) probably on date to limit the maximum value.

Anonymous
Not applicable
Author

I suppose that you have right. Problem is how can i do this

Digvijay_Singh

Pl Chk  I have done it here, may be this can help.

You may need to play with date format based on your format etc.

Digvijay_Singh

Could you check the solution I posted?

Anonymous
Not applicable
Author

Yes, it is great solution. thank you very much,

I have to implement this into my model.

Best Regards,

Jacek Antek