Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Ultraviolence
Contributor
Contributor

Connecting to different databases the second table value by day are all 0

I meet a weired and tough problem, I created two connections in script, one is from spark, another is from postgre.

when I want to show sum(resolved) by day, it always shows 0 like below. but when I use sum(click), it works.

but if I create a KPI chart to show the total(resolved), it works. So it seems like the date column in postgre connection is not work?? after I deleted the spark_hive database selection, it works. WHY?? How to fix this? I just wanna use the same date column and format, it never happened in the same connection with multiple tables, but it doesnt work in simultaneously postgre and spark???

My load scriptMy load scriptexists two connectionsexists two connectionsafter deleting spark_hive database connectionafter deleting spark_hive database connection

Labels (4)
0 Replies