My company has an extensive deployment of DBT to build the enterprise datawarehouse. Now we are planning to implement the Semantic Layer functionality in DBT, but we are not sure if Qlik can query that semantic layer.

Any experience in this forum?

Hello Team

We are using AWS Aurora PostgreSQL as our source and have incorporated source_lookup into the task to enhance the table structure. However, its performance is not as expected. The table on which the source lookup is configured has 600K records, and the lookup table also contains 600K records. Out target is S3.

source lookup condition: source_lookup('NO_CACHING','public','custacct','cust_acct_bs_nbr','cust_acct_id=?',$cust_acct_shipto)

It seems the processing speed is 100K per hour. You can check the same on the attached screenshot.

When we tested the same configuration with an AS400 DB2 source, the performance was markedly better.

Thank you!

Haider

Hello,

I am trying to input more than one string in a variable and the best I could come with is this...

Hi,

Can any one help me why I'm not getting count(customer id) in qliksense table using 'if' condition. Please see the below data in table:

Thanks

Hi,

I'm having trouble trying to parse a XML SOAP response in Qlik, using the REST connector and hoping someone could help me out.

I'm not very experienced in the subject, but I've managed to get the response. The problem is that it comes in a single field and I don't know how parse it as a table.

1. I've set the body and header in the REST connector, and added the wsdl as the URL request. If I click "test connection" it says "succeeded".

2. If I click on the "select data" button in the connector, it opens the preview table, but it automatically is read as a CSV. If I change the option to XML, only the headers will show in the preview (no data is retrieved), while the CSV will show the actual response data encapsulated in a single cell.

(if I hover the value I see the same response I get in postman, which is correct)

(XML doesn't return values, but only these columns)

How can I display this response as table in Qlik?

PS: I've noticed the response I get carries "&lt;" and "&gt;" which I found out to be the "<>" chars. Not sure if it's relevant.

Fiz a instalação do QLIK Sense Desktop mais recente, e ao abrir, ele não aproveita a tela (Conforme print anexado).

Já ajustei a resolução e escala do vídeo, mas não deu certo.

Já passaram por isso? Caso sim, como conseguiram solucionar?

Ou melhor instalar uma versão mais antiga?

Hi All,
 
We are migrating the server from RHEL 7 to RHEL 8. 
We have a PostgreSQL target. 
 
From new box, RHEL 8, we are able to connect via command line to PostgreSQL but while trying to test connection from the Qlik UI, we are getting the below error:
 

Cannot connect to ODBC provider
RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'PostgreSQL' : file not found

Below is the o/p of site_arep_login.sh and /etc/odbcinst.ini. With same settings, it was connecting in RHEL 7.

[root@**]# cat site_arep_login.sh
# enter site specific settings here
#export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/oracle/product/193000/client_1/lib/
export NLS_LANG='ENGLISH_UNITED KINGDOM.AL32UTF8'
export ORACLE_HOME=/u01/app/oracle/product/193000/client_1/
export TNS_ADMIN=/u01/app/oracle/product/193000/client_1/network/admin/tnsnames.ora
export LD_LIBRARY_PATH=/usr/lib:/usr/lib64:/usr/pgsql-14/lib:/opt/snowflake_odbc/lib:/u01/app/oracle/product/193000/client_1/lib/:$LD_LIBRARY_PATH



[root@**]# cat /etc/odbcinst.ini
# Driver from the postgresql-odbc package
# Setup from the unixODBC package

PostgreSQL]
Description = PostgreSQL ODBC driver
Driver = /usr/pgsql-14/lib/psqlodbc.so
Setup = /usr/pgsql-14/lib/psqlodbcw.so
Debug = 0
CommLog = 1
UsageCount = 2

[SnowflakeDSIIDriver]
APILevel=1
ConnectFunctions=YYY
Description=Snowflake DSII
Driver=/opt/snowflake_odbc/lib/libSnowflake.so
DriverODBCVer=03.52
SQLLevel=1

Hello everyone
User
I have the table that contains the following fields:
LLAVECP,
CENTRO,
PLU_SAP,
NumeroSemana,
Venta_UND
I need the data to be ranked according to the Venta_UND field value for each LLAVECP

I need a cumulative count of the following data:

at the moment I've created a field called 'Count' populated with '1' in the data load and attempted a range sum

Rangesum(Before(Sum(Count),0,ColumnNo()))

which produces the following

I want it to show like this : 

Is there a way to do this - either with the formula I have or an alternative approach?

Quando visualizo um grafico em tela cheia a tela não está responsiva e abre a barra de rolagem na vertical.  Qual a solução? 

Esta situação não acontecia há uma semana atras, será que é um problema do produto?