How to select Date automatically when Month selected(Auto selection)

[#1]

Dear Friends,

We have three list boxes i.e Year,Month,Date.

As per Qlik behaviour, when we select Year, its associated Month and Date  gets highlighted(i.e possible values).

When we select Month , its associated Date gets highlighted(i.e possible values).

Our requirement is when month gets selected, its associated Date should get selected automatically(i.e without having to select date manually). Because we have one date in every month, it should be selected when month selected.

Thanks in advance.

Regards,

Kishore.

[Digvijay_Singh]

It appears you need to review your data model? Are you using master calendar having month, year and date field? Your calendar should be associated to fact data through date field. The disconnection between date and month fields in data model could be the reason.

[Anonymous · Accepted solution]

Hi karakvasala1,

You can use the field event triggers property to accomplish your goal.

1. Open Document Properties(Ctrl+Alt+D)

2. Click on Triggers tab

3. Go to the field event trigger, click on the 'Month' field and add trigger to it.

4. The required trigger in your case would be 'Select Possible'

Hope I am clear with my answer.

Thanks and regards

[swuehl]

Our requirement is when month gets selected, its associated Date should get selected automatically(i.e without having to select date manually). Because we have one date in every month, it should be selected when month selected.

If there is only one possible date per month, there is no need to explicitely select this value.

Why not just rely on the associative data model? Selections should reflect user actions.

Or maybe I am missing something else?

If you absolutely need to select the dates, you can use a field trigger on Month field and a Selection - Select in field action to select the single possible value (or maybe a Select possible action or someother action).

[#5]

select possible trigger on month field would be helpful in the above scenario .

[MindaugasBacius]

I guess it's something wrong with table model and how they are connected.

Check the link:

Creating A Master Calendar

[Digvijay_Singh]

Looks like I misunderstood, if you want to see value selected in field in green color then use field level trigger - more or less similar to as shown below , p-

[awhitfield]

Hi,

can you upload a sample QVW, so we can see what data etc. you are actually using, rather than guessing?

Andy

[#9]

Thanks for ur response.