Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master
‎2020-05-21 03:37 AM

may i know how to remove the $Syn Table ?

Hi All

My data model as below , may i know how to remove the $Syn Table ?

HOW TO DROP SYN TABLE.png

332 Views
0 Likes
1 Solution

Accepted Solutions
5 Replies
Hemanth458
Contributor III
Contributor III
‎2020-05-21 03:41 AM

Rename Date in both tables as TableName_Date then go canonical date.

330 Views
0 Likes
paulyeo11
Master
Master
‎2020-05-21 03:45 AM
Author

In response to Hemanth458
Hi Sir

Now the table look nice.

May I know how to link all table date to master calendar ?

Paul
327 Views
0 Likes
Hemanth458
Contributor III
Contributor III
‎2020-05-21 03:48 AM

In response to paulyeo11

Please go through this link https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

325 Views
0 Likes
paulyeo11
Master
Master
‎2020-05-21 03:57 AM
Author

In response to Hemanth458
Hi Sir

Wow this is the better approach .

Paul Yeo
320 Views
0 Likes
paulyeo11
Master
Master
‎2020-05-23 03:14 AM
Author

In response to Hemanth458

Hi All

I move this post to the top . As i am solving this issue now.

Paul 

265 Views
0 Likes