Why not concatenate this Sales And Target data in a single table with flag field over there. Or may be you go for Canonical dates explain by HIC.
Ex:- With concatenate
'Sales' As TableFlag,
'Target' As TableFlag,
Thank you for the detail answer.
Please clarify two things:
Using concatenate option Do we need to show Sales and Target Amount in separate column using IF condition? and it will automatically display against correct date, region and business?
Secondly for using canonical date option please share syntax to create a separate Master Calendar from existing one QVD table?
I am sorry as i am very much new to Qlik.