topic Re: If Date = Today () in QlikView

If Date = Today ()

eugeniyaromanov — Wed, 25 Nov 2020 16:16:04 GMT

Hello again!

Another problem.

I've got a table :

Name	DateHired	DateFired
Name 1	01.01.2017	31.01.2017
Name 2	01.02.2017	Today()
Name 3	02.02.2017	Today()

Today() is needed, so I can't change it.

It stores in qvd file thеn like:

Name	DateHired	DateFired
Name 1	01.01.2017	31.01.2017
Name 2	01.02.2017	04.04.2017
Name 3	02.02.2017	04.04.2017

In a file i need to display 4 fields:

Name | DataHired | DataFired | Work Experience

And I have a problem with DataFired, I want it to be shown only if the date is not today.

I try this:

if(date(DateFired, 'DD.MM.YYYY') = Today(), '----', DateFired)

but it won't work...

In another two text fields I put :

1. = Today()

2. = DataFired

just to verify data and they are the same.

Re: If Date = Today ()

sunny_talwar — Tue, 04 Apr 2017 14:21:35 GMT

I try this:

if(date(DateFired, 'DD.MM.YYYY') = Today(), '----', DateFired)

Where you trying this? Would you be able to share a sample?

Re: If Date = Today ()

ahaahaaha — Tue, 04 Apr 2017 14:23:53 GMT

May be

Only ({<DateFired={"=DateFired<>Today()"}>}DateFired)

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:24:52 GMT

Hi Sunny!

I't kind a hard because it's all in Russian

But I will make a smaller file with inline load so you will be able to see it, give me 5-10 min.

Re: If Date = Today ()

Anonymous — Tue, 04 Apr 2017 14:25:37 GMT

Can get it to work by hard coding the date in the expression which makes me assume it is something to do with the date format.

if(Datefired<>'04.04.2017',datefired,' ')

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:26:46 GMT

Hi!

Won't work...

Still show today date when shouldn't be.

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:28:04 GMT

Again it shows today date when shouldn't be

Re: If Date = Today ()

ahaahaaha — Tue, 04 Apr 2017 14:29:13 GMT

In attached file

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:38:02 GMT

Example

hope it works well.

Re: If Date = Today ()

sunny_talwar — Tue, 04 Apr 2017 14:42:06 GMT

Are you looking for one of the two?

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:43:06 GMT

Thank you for a try, but where is Name 2 and Name 3?

Re: If Date = Today ()

Anonymous — Tue, 04 Apr 2017 14:46:18 GMT

This seems to work if(Datefired<>date(today(),'DD.MM.YYYY'),Datefired,' ') wrapping the today() function in the date format DD.MM.YYYY to match the date fired. Let me know if this doesn't solve your problem.

Kindest regards

Brian

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:47:43 GMT

Eh.. no...

I should look like

Name	DH	DF	Exp
Name 1	2017-01-01	2017-01-31	30
Name 2	2017-02-01	----	62
Name 3	2017-02-02	----	61
Name 4	2017-02-03	2017-02-04	1
Name 5	2017-02-04	2017-04-03	58

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:48:38 GMT

Please, see the attachment I put, may be it'll help.

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:50:36 GMT

Hi!

No, it shows today when shouldn't...

Please, see my attachment i put, may be it can help.

Re: If Date = Today ()

sunny_talwar — Tue, 04 Apr 2017 14:51:23 GMT

Check the attached

Re: If Date = Today ()

eugeniyaromanov — Tue, 04 Apr 2017 14:57:15 GMT

Perfect!

Thanks a lot!

Saved my day

Re: If Date = Today ()

Anonymous — Tue, 04 Apr 2017 15:02:17 GMT

The below is the result I get is this what you are looking for?

I just used a pivot table with name and datehired as dimensions and the following expressions:

Datefired expression- if(DateFired<>date(today(),'DD.MM.YYYY'),DateFired,' ')

Experience expression - =sum(Exp)

I apologise if I've misunderstood your requirement.

Re: If Date = Today ()

eugeniyaromanov — Wed, 05 Apr 2017 06:12:27 GMT

Good morning!

thanks for a try, but I tried yours expression and it still shows a date when it shouldn't ...

Anyway, Sunny's expression works perfect!