Hi, I am new to qlik,
I have a pivot table with the dimensions group and subgroup.
the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
( (Num_Subgroup & '- '& Subgroup)).
The problem is that I get a null concatenation in the filter panel.
in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
Can you help me, please.

Hi all, I am currently encountering an issue when I run a Talend Job that read a query from Snowflake which is able to run in my local PC Talend but not in a Remote Engine that I have connected in Talend Portal. Here is the log:

tDBInput_1 Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
java.io.IOException: Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
    at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:138)
    at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
    at fpi_dw.tcurr_0_1.TCURR.tDBInput_1Process(TCURR.java:3704)
    at fpi_dw.tcurr_0_1.TCURR.tDBRow_1Process(TCURR.java:2622)
    at fpi_dw.tcurr_0_1.TCURR.runJobInTOS(TCURR.java:7710)
    at fpi_dw.tcurr_0_1.TCURR.main(TCURR.java:7142)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager.<clinit>(UnsafeAllocationManager.java:27).
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:243)
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQuery(SnowflakeStatementV1.java:131)
    at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:135)
    ... 5 more

From my PC, works perfectly:

Talend Portal:

Appreciate with any advice and feedback, thank you!

Hi, what do i miss here??

if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',
if(frac(STARTTIME)>=MakeTime(15,30) and frac(STARTTIME)<=MakeTime(22,59,59),'EM','Natt')) as Shift

Hi,

I try to concatenate these 2 tables and the fields from the budget one (.xlsx) results in nulls as you can see in the image attatched, where I know there are values. Is there something wrong? 

Many thanks!!!

This is the code: 

The D-Link 5GHz Not Showing if your device does not support the 5GHZ network. Also, check and update the SSID names for both networks and sometimes it can happen due to a corrupted network adaptor. So to resolve it, give a different name to the 5ghz network and fix the adaptor issues.

Hi All,

I am trying to get some data out of an database. However, the load script does give an error in Qlik. When I run the SQL statement in the database, there occurs no error.

See below the error and the SQL statement.

Select
a.FK_BUDGETORDERINTAKEYEAR,
a.BUDGET,
a.MARGE,
a.BUDGETPRODUCTION,
a.PK_U_BUDGETORDERCATEGORY,
a.FK_BUDGETORDERCATEGORY,
a.FK_BUDGETSERVICECONTRACTTYPE,
a.INVOICEORDERINTAKE,
b.PK_R_ORDER,
b.FK_ORDERCATEGORY,
c.PK_R_SALESORDERDETAILMISC,
c.NETSALESAMOUNT,
c.ORDERDATE,
//c.FK_SALESPERSON,
d.FK_FINANCIALYEAR,
d.PRODUCTIONPERCENTAGE

FROM U_BUDGETORDERCATEGORY a
LEFT JOIN R_ORDER b ON a.FK_BUDGETORDERCATEGORY = b.FK_ORDERCATEGORY
LEFT JOIN V_R_SALESORDERDETAILMISC c ON b.PK_R_ORDER = c.FK_ORDER
LEFT JOIN U_PRODUCTION d ON c.PK_R_SALESORDERDETAILMISC = d.FK_SALESORDERDETAILMISC;