topic Re: range selection in QlikView

range selection

warrentk80 — Mon, 09 Jun 2014 14:50:22 GMT

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

Re: range selection

MK_QSL — Mon, 09 Jun 2014 15:08:51 GMT

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...

Re: range selection

shawn-qv — Mon, 09 Jun 2014 23:52:51 GMT

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?

Re: range selection

warrentk80 — Tue, 10 Jun 2014 07:00:07 GMT

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

Re: range selection

warrentk80 — Tue, 10 Jun 2014 07:05:14 GMT

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

Re: range selection

MK_QSL — Tue, 10 Jun 2014 08:17:24 GMT

Can you attach your sample file?

Re: range selection

MK_QSL — Tue, 10 Jun 2014 08:21:34 GMT

CHECK ENCLOSED FILE...

Re: range selection

warrentk80 — Tue, 10 Jun 2014 09:02:51 GMT

Great, just what I was looking for 🙂

Thank you very much

Andrea

Re: range selection

warrentk80 — Tue, 10 Jun 2014 10:25:25 GMT

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

Re: range selection

MK_QSL — Tue, 10 Jun 2014 10:28:39 GMT

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

Re: Re: range selection

warrentk80 — Wed, 11 Jun 2014 08:08:35 GMT

Hello,

in Annex I send you an example,

practically imposed the filters at the top (Area, PROC ACTIVITY ')

I have two buttons in the month and the month should be a graph with the data of the selected month or the month.

starting from the month I select a month, then when I switch to the monthly view filters set at the top disappear.

thank you

Andrea