Hi, hope someone can help me with my issue. I'm using Qlik Sense September 2017 version. When I want to load a SQL Script it doesn't load anything but there is no error message. The SQL Script works correct on a SQL Developer. It seems that the last left join (red marked) is causing the issue. Does someone know why?
SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='$#,##0.00;-$#,##0.00'; SET TimeFormat='h:mm:ss TT'; SET DateFormat='M/D/YYYY'; SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'; SET FirstWeekDay=6; SET BrokenWeeks=1; SET ReferenceDay=0; SET FirstMonthOfYear=1; SET CollationLocale='en-US'; SET CreateSearchIndexOnReload=1; SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'; SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
LIB CONNECT TO 'reporting (ldap_username)';
SELECT u.id, u.datetime, to_char(u.datetime, 'YYYYMM') "month", u.customer_id, u.customer_number cid, u.msisdn, u.brand, CASE WHEN u.product = 'M-Budget Mobile Mini ' THEN 'M-Budget Mobile MINI' WHEN u.product = 'M-Budget Mobile Maxi ' THEN 'M-Budget Mobile MAXI' ELSE u.product end as product, u.product_id, u.type_id, u.event_type, u.call_type_group, u.call_type_name, u.sec, u.min, u.kb, u.mb, u.gb, u."sms/mms", u.charge, round(u.charge::numeric, 2) as charge_excl_vat, round(u.charge::numeric*1.077, 2) as charge_incl_vat, case when u.charge = 0 then 'yes' else null end as included, u.billed, u.invoice_nr, u.gender, u."language", u.nationality, u.cumulus, u.wireline, u.customer_status, u.customer_age, u.customer_age_group, u.pay_method, u.disp_method, u.canton, u.violated_usage, u.violated_voice_national, u.violated_voice_roaming, u.violated_data_national, u.violated_sms_mms_national, u.violated_sms_mms_international, case when date_trunc('month', u.datetime::date) > date_trunc('month', current_date - interval '3' month) and u.violated_usage is not null then 1 else 0 end as violated_last_3months, case when date_trunc('month', u.datetime::date) > date_trunc('month', current_date - interval '3' month) and u.violated_voice_national = 1 then 1 else 0 end as violated_voice_national_last_3months, case when date_trunc('month', u.datetime::date) > date_trunc('month', current_date - interval '3' month) and u.violated_voice_roaming = 1 then 1 else 0 end as violated_voice_roaming_last_3months, case when date_trunc('month', u.datetime::date) > date_trunc('month', current_date - interval '3' month) and u.violated_data_national = 1 then 1 else 0 end as violated_data_national_last_3months, case when date_trunc('month', u.datetime::date) > date_trunc('month', current_date - interval '3' month) and u.violated_sms_mms_national = 1 then 1 else 0 end as violated_sms_national_last_3months, case when date_trunc('month', u.datetime::date) > date_trunc('month', current_date - interval '3' month) and u.violated_sms_mms_international = 1 then 1 else 0 end as violated_sms_international_last_3months, c.dunning_level current_dunning_level FROM wingo_view_usage u left join v_reporting_customers c on c.customer_id=u.customer_number left join v_reporting_dunning_reminder d on d.customer_id=u.customer_number and to_char(d."date", 'YYYYMM')=to_char(u.datetime, 'YYYYMM') where u.datetime >= '2018-01-01' ;