Hello everyone,

We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.
We would like to be able to access these servers via ourdomain.com/qliksense1 and ourdomain.com/qliksense2.
Is it possible to configure Nginx to allow this?

Furthermore, we also require virtual proxies for some of our custom apps and we would like to be able to access the virtual proxy via ourdomain.com/qliksense1/virtualproxy and ourdomain.com/qliksense2/virtualproxy.
Is this possible?

Thank you!

Is there a decent zero to REST API tutorial or guide for Qlik Sense Enterprise?

I’m a full stack dev who is comfortable with JWTs, basic auth etc and very comfortable with Node/JS and API calls, custom headers, etc but for some reason none of the guides I’ve found really cover every setting that is required.

Why do I need a cert etc? What’s a virtual proxy vs proxy? If only there was an API to call...

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.