topic Re: How to select Date automatically when Month selected(Auto selection) in QlikView

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

Wed, 27 Apr 2016 09:28:21 GMT

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.

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

Digvijay_Singh — Wed, 27 Apr 2016 09:35:41 GMT

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.

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

Anonymous — Wed, 27 Apr 2016 09:38:53 GMT

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

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

swuehl — Wed, 27 Apr 2016 09:40:18 GMT

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

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

Wed, 27 Apr 2016 09:42:22 GMT

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

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

MindaugasBacius — Wed, 27 Apr 2016 09:43:18 GMT

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

Check the link:

Creating A Master Calendar

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

Digvijay_Singh — Wed, 27 Apr 2016 09:46:35 GMT

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-

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

awhitfield — Wed, 27 Apr 2016 13:06:32 GMT

Hi,

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

Andy

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

Mon, 23 May 2016 09:31:33 GMT

Thanks for ur response.