Dual Table functionality.

[#1]

Hi All,

How to use Dual table in QV and how to view the values in QV?

i am looking like ,

Load DaylightSaving() as <alias name> .....<Table Name>;

For Ex like,

In SQL

Select 1+2 from dual;

O/P – 3.

Select Date from dual;

O/P – Todays date;

Select timestamp from dual;

Select Addmonth(vDate,1) from dual;

O/P –Month+1;

Reagrds,

Senthil.

[Gysbert_Wassenaar]

Qlikview doesn't have a dual table like oracle. Simply calculate what you want:

LET vDate = today();

MyTableName:

Load

1+2 as MySum,

FieldA - today() as FieldB,

addmonths($(vDate),1) as FieldC

from MySourceTable;

OtherTable:

load today() as today

1+2 as sum

autogenerate(1);

[#3 · Accepted solution]

I assume, you are using this temp(dual) table in inner query. then you can use Preceding load. Calculate whatever you want in inner query and then pipe the out put in outer query.

Preceding load eg : http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load