topic Re: Dual Table functionality. in QlikView

Dual Table functionality.

Mon, 04 Mar 2013 10:04:03 GMT

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.

Re: Dual Table functionality.

Gysbert_Wassenaar — Mon, 04 Mar 2013 10:12:38 GMT

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);

Re: Dual Table functionality.

Mon, 04 Mar 2013 10:14:24 GMT

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