Today date not giving properly

[saivina2920]

I'm just giving 

=Date(Today()) ==> It's showing 2000

How and Why....?

[saivina2920]

Awsome..
Is it possible to display <5days from today count while loading the page by default.?
now it's showing all the count which is greater than 5 and <= is blank while load page. can we apply some conditions..
later if user select listbox, then it should show the count based on that

[sunny_talwar]

May be use triggers to set the values

[saivina2920]

can you give some sample..i am new for triggers in qlikview...

[sunny_talwar]

I can, can you give me the exact behavior you are looking for?

[saivina2920]

definitely.
By default (first time loading the page), the count should display only for <5 days from today.
now, we currently derived formula while loading the page
>=' & vCalDate' ==> =date(vToday-5,'DD-MM-YYYY')
<=' & vFinalCountDate ==> user haven't select. it is null. so displaying all the count.
I want below.
First :
By default (first time loading the page), the count should display only for <5 days from today.
For example,
>=' & vCalDate' ==> =date(vToday-5,'DD-MM-YYYY')
<=' & vFinalCountDate ==> we should not consider this. because we haven't select.

Second :
if i select values from listbox, then the count vary based on our condition. below seems to be okey.
>=' & vCalDate' ==> =date(vToday-5,'DD-MM-YYYY')
<=' & vFinalCountDate ==> selected from list box. we are getting the valies.
below seems to be okey. no need to do anything
=Count({<NewDate = {"$(='>=' & vCalDate & '<=' & vFinalCountDate)"}>}NewDate)
we have to arrive First condition only...

[saivina2920]

Pls. find my final Qlikview File.
My requirement is i want count in 3 ways
1. count <5 Days from Today
2. count >10 Days and <20 Days from Today
3. Count > 20 Days from Today
I have modified my logic based on my requirement.
I want to work around as i said
"By default (first time loading the page), the count should display only for all the 3 Conditions".

As you said, we can use Triggers. If you are providing the logic then we can implement.

i am waiting for your valuable details

Pls. find attached latest file.

[sunny_talwar]

When you say "first time loading the page"... you mean first time the dashboard is reloaded and you enter the dashboard? Or do you mean that anytime you enter the sheet?

[saivina2920]

Until or unless I select drop down, value remain the same and calculate based on the rules. For example, if less than 5 days or 10 to 20 days or greater than 20 days then it should count from today.
If I select drop down then it should add in that formula as a day and then should give count..

[saivina2920]

Or simple Logic as below.
If i haven't selected any ListBox at any time my expression is as below
For < 5 days
=Count({<NewDate={">=$(vCalDate)<=$(vToday)"}>} NewDate)

If I Selected ListBox any values then my expression is below
For <5 days
=Count({<NewDate = {"$(='>=' & vCalDate & '<=' & vFirstConditionLT5Days)"}>}NewDate)
Will 2 different formula work....?
If this works, then no need to call any trigger or some other option.
pls. reply if you have any doubts....

[saivina2920]

Or simple Logic as below.
If i haven't selected any ListBox at any time my expression is as below
For < 5 days
=Count({<NewDate={">=$(vCalDate)<=$(vToday)"}>} NewDate)

If I Selected ListBox any values then my expression is below
For <5 days
=Count({<NewDate = {"$(='>=' & vCalDate & '<=' & vFirstConditionLT5Days)"}>}NewDate)
Will 2 different formula work....?
If this works, then no need to call any trigger or some other option.
pls. reply if you have any doubts....