How to Set Default Date in our Qlikview Application?

[khasimvali85]

Hi Community,

                    How to Set Default Date in Qlikview Application.

I want to show whenever the user open the application the default date should be shown?

Can any body give suggestion?

Regards,

Khaism.

[#2]

Hi,

You can create a text object with "=today()-1", which will give you yesterday's date.

[khasimvali85]

Hi Amay,

               Thanks  for your suggession but date only display, but not impact in my chart objects.

Regards,

Khasim.

[Anonymous]

Hi

[Anonymous]

Hi,

use below syntax  in text object:

=Date(max(Datefield),'DD/MM/YYYY')

change datefield with you field name.

[#6]

Hi Khasim,

you need compare this date(today()-1) with your max(date) in your expressions in each of your chart object, which will give you yesterday's data only in the chart.

I hope this is what you wanted.

or can you post a sample.

Regards,

Amay

[khasimvali85]

Hi Neeta,

               Thanks for Suggest i know that syntax but i want to use in calender object this date field.

Regards

khasim.

[Anonymous]

hi,

Create variable in script:

LET vTodaysDate = date(today(),'DD/MM/YYYY');

copy paste below syntax in script:

Date(Min(Date#(Date,'DD/MM/YYYY'))) as MinDate,
Date(Max(Date#(Date,'DD/MM/YYYY'))) as MaxDate,

use in object:

[Anonymous]

Modify according to your requirement

[khasimvali85]

Hi Neeta,

                    Thanks for your Suggestion but i have done same thing but not impact in my application.

Regards,

Khasim.

[rustyfishbones]

Create a Text Object and use Select in Field

text object with Yesterday as the text

And then use Select in Field option, assuming your field is called Date