Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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);
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