topic Deafault date while selection in QlikView

Deafault date while selection

Thu, 27 Feb 2014 15:44:42 GMT

Hi All

I have one variable GDate which is max date of max Quarter.

I need this as default when I open a document, but the problem is it shows the date lastly selected and saved.

I tried to initialize by creating Trigger, but not working.

Any clue please?

Thanks in advance to all

Raj

Re: Deafault date while selection

MK_QSL — Thu, 27 Feb 2014 15:49:08 GMT

Before your trigger add one more trigger clear all..

i.e. Add >> Selection >> Clear All

Re: Deafault date while selection

PrashantSangle — Thu, 27 Feb 2014 15:52:28 GMT

Hi,

I think you are looking for clear all action.

You can find this in sheet properties

Re: Deafault date while selection

aveeeeeee7en — Thu, 27 Feb 2014 15:56:19 GMT

Hi Rajendra

Create on more Trigger "Clear All" before your Date Trigger.

Follow these Steps:

1) Right Click on Sheet

2) Select Properties

3) Go to Triggers Tab

4) Click Add Action(s)... under OnActivateSheet

5) Select Add

6) Click Action Type: Selection and Select "Clear All"

7) Set Ok

😎 Again Click on Add

9) Click Action Type: Selection and Select "Select in Field"

10) Set Ok - Field - Date Search String - Max(Date)

Also See the Attachment.

Regards

Aviral Nag

Re: Deafault date while selection

Fri, 28 Feb 2014 01:48:08 GMT

Hi Nag

I have performed all steps you mentioned here.

Still not working. Like if I have max date 12/31/2013.

Now I select 09/30/2013 and save. So when I open I should see 12/31/2013 but I am seeing the date lastly saved.

Thanks

Raj

Re: Deafault date while selection

Fri, 28 Feb 2014 01:49:20 GMT

Even the attached QV file does the same, when open than pop up lastly saved date but not the max.

Thanks

Raj

Re: Deafault date while selection

Fri, 28 Feb 2014 01:49:57 GMT

Hi Max

I have performed clear all and then max date.

Still not working. Like if I have max date 12/31/2013.

Now I select 09/30/2013 and save. So when I open I should see 12/31/2013 but I am seeing the date lastly saved.

Thanks

Raj

Re: Deafault date while selection

Fri, 28 Feb 2014 01:50:33 GMT

Hi Manish

I have performed clear all and then max date

Still not working. Like if I have max date 12/31/2013.

Now I select 09/30/2013 and save. So when I open I should see 12/31/2013 but I am seeing the date lastly saved.

Thanks

Raj

Re: Deafault date while selection

MK_QSL — Fri, 28 Feb 2014 06:49:38 GMT

Can you upload your sample file please?

Re: Deafault date while selection

Fri, 28 Feb 2014 08:05:34 GMT

Manish

In attached QV whenever I open it shows lastly selected date but not max date

Thanks

Raj

Re: Re: Deafault date while selection

sunilkumarqv — Fri, 28 Feb 2014 08:15:35 GMT

Please find the attached file

Go to settings tab

sheet properties -Triggers -Onactivate Sheet-EditActions-Select in Field Search String as =Max(Date) then Save it

Hope you get desired results

Re: Deafault date while selection

Fri, 28 Feb 2014 08:48:46 GMT

Hi Sunil

I don’t get.

Please see attachment

When I open document I can see the date lastly saved but not max.

Thanks

Raj

Re: Re: Deafault date while selection

MK_QSL — Fri, 28 Feb 2014 09:14:15 GMT

Like This?

Re: Deafault date while selection

Fri, 28 Feb 2014 10:15:46 GMT

Manish

I think you are referring Sample-1(3).qvw

If so than still does’t work. I tried the same but after saving doc and reopen again it pop up the date which you have saved last

Thanks for helping

Raj

Re: Re: Deafault date while selection

MK_QSL — Fri, 28 Feb 2014 10:20:33 GMT

NOW?

Re: Deafault date while selection

Fri, 28 Feb 2014 10:30:10 GMT

Manish

I saved with ‘03/01/2014’. When I reopen it was showing the same date but not ‘06/01/2014’

File attached here

Thanks lot

Raj

Re: Deafault date while selection

ashwanin — Fri, 28 Feb 2014 10:35:14 GMT

You have to do the below to set the maximum date.

Go to Setting -->Document Properties-->Triggers--> Select on open --> edit actions-->Choose Select in Field -->choose field Date and in search string put formula =max({1} Date) . Sample qv attached.

Use formula =max({1} Date)

Re: Deafault date while selection

Fri, 28 Feb 2014 10:52:59 GMT

Hi Ashwini

Now it’s woks perfectly fine.

I appreciate all of you for valuable efforts, Excellent job all of you did.

Thanks

Raj

Re: Deafault date while selection

ashwanin — Fri, 28 Feb 2014 10:57:44 GMT

If it works, then close the thread.

Re: Deafault date while selection

sunilkumarqv — Fri, 28 Feb 2014 10:57:53 GMT

So much of work contributed every one please make correct anwser