Can you please let me know if using the resident tables causes performance impact as that data is originally loaded from huge qvd files?
If so, do we have to write the output to a seperate qvd and again load the qvd?
what is the beast approcah?
As I am new to qlikview any suggestions would help.
Thanks in advance
Link the two tables with forming key i.e
visitnum &'-'& floor(orderdate) as Key,
orderdate as order_Date,
visitnum &'-'& floor(paydate) as Key,
paydate as pay_date
and then in front end you can use If(IsNull(pay_date),order_Date,pay_date) to get one date