topic Creating a Table with only Calculated Fields in QlikView

Creating a Table with only Calculated Fields

mccook — Mon, 31 Mar 2014 10:24:44 GMT

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 — Mon, 31 Mar 2014 10:26:41 GMT

Load

Date(Today()) as Today,

Date(Today()+1) as Tomorrow

AutoGenerate 1;

mccook — Mon, 31 Mar 2014 10:29:39 GMT

thanks.

its_anandrjs — Mon, 31 Mar 2014 10:31:04 GMT

Load like this

Temp:

LOAD

Today() as Today,

Date(Today()+1) as Tomorrow

AutoGenerate 1;

Hope this helps

Mon, 31 Mar 2014 10:31:32 GMT

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