Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
warrentk80
Creator
Creator

range selection

Hello to all

I need to make sure that if the user selects a month (eg May)

Automatic selection range to take the January, May.

is it possible?

thanks

Andrea

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

CHECK ENCLOSED FILE...

View solution in original post

10 Replies
MK_QSL
MVP
MVP

Go to Document Properties

Trigger

Field Event Trigger

Select Your Month Field

Add Action

Add - Select In Field

Field

Month

Search String

='('&concat({1<Month={'<=$(=Max(Month))'}>} aggr(only({1<Month=>}Month),Month),'|',Month)&')'

Now Create a List Box for Month Field and Select any month...

shawn-qv
Creator
Creator

In your example, if a user selects May in Month, do the other months (i.e. Jan - Apr) need to be shown as selected (i.e. highlighted in the QV "green")?

Or do you only require the values (i.e. a date range) as a criteria in your calculation?

S.

warrentk80
Creator
Creator
Author

initially I wanted to use the selected months in the expression, then since I have not solved the problem I changed the street and thought I select in the green range.

thank you

Andrea

warrentk80
Creator
Creator
Author

ello, Thank you for having responded to me,

I performed the instructions you sent me.

and inserted into the search field on the month 'action

= '(' & concat ({1 <Month = {'<= $ (= Max (Month))'}>} aggr (only ({1} <Mese=> Month), Month), '|', Month) & ')'

then I created a list with the month field but if I select a month, it's business as usual.

thank you

Andrea

MK_QSL
MVP
MVP

Can you attach your sample file?

MK_QSL
MVP
MVP

CHECK ENCLOSED FILE...

warrentk80
Creator
Creator
Author

Great, just what I was looking for 🙂

Thank you very much

Andrea

warrentk80
Creator
Creator
Author

Hello, another question if I may.

the selection of the month I cancel all selections, on other fields, how can I avoid this?

thank you

Andrea

MK_QSL
MVP
MVP

Not getting your question properly... can you please elaborate little more?