Creating a Table with only Calculated Fields

[mccook]

Hi,

I want to create a table like below (in reality, a little more complex):

Today	Tomorrow
31/03/2014	01/04/2014

my attempt was:

Temp:

LOAD

  Today() as Today,

  Today()+1 as Tomorrow

;

This doesn't appear to work, I get no table at all.

Any advice welcome?

Cheers,

Dean

[MK_QSL · Accepted solution]

Load

  Date(Today()) as Today,

  Date(Today()+1) as Tomorrow

AutoGenerate 1;

[mccook]

thanks.

[its_anandrjs]

Load like this

Temp:

LOAD

  Today() as Today,

  Date(Today()+1) as Tomorrow

AutoGenerate 1;

Hope this helps

[#5]

Hi,

The way I would tackle this is to set this as variables inside the load script.

LET vToday = Today();

LET vTomorrow = Today() + 1;

The reason I would use variables is because this figure changes only once a day and is not based of your data.

And then you use the variables inside the graph instead of the fields.

I have attached a sample qvw.

Regards,
Marius