Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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