Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

eugeniyaromanov
New Contributor III

If Date = Today ()

Hello again!

Another problem.

I've got a table :

NameDateHiredDateFired
Name 101.01.201731.01.2017
Name 201.02.2017Today()
Name 302.02.2017Today()

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

It stores in qvd file thеn like:

NameDateHiredDateFired
Name 101.01.201731.01.2017
Name 201.02.201704.04.2017
Name 302.02.201704.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.

1 Solution

Accepted Solutions

Re: If Date = Today ()

Check the attached

Capture.PNG

View solution in original post

18 Replies

Re: If Date = Today ()

I try this:

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

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

ahaahaaha
Honored Contributor

Re: If Date = Today ()

May be

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

eugeniyaromanov
New Contributor III

Re: If Date = Today ()

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.

briancopple
Contributor II

Re: If Date = Today ()

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,' ')

eugeniyaromanov
New Contributor III

Re: If Date = Today ()

Hi!

Won't work...

Still show today date when shouldn't be.

eugeniyaromanov
New Contributor III

Re: If Date = Today ()

Again it shows today date when shouldn't be

ahaahaaha
Honored Contributor

Re: If Date = Today ()

In attached file

eugeniyaromanov
New Contributor III

Re: If Date = Today ()

Example

hope it works well.

Re: If Date = Today ()

Are you looking for one of the two?

Capture.PNG