Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dual Table functionality.

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

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


talk is cheap, supply exceeds demand
Not applicable
Author

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