I want to identify the list of source and target endpoints for all the Qlik tasks defined on our Qlik replicate server.
Is there any API we can use to get this complete information for any give Qlik server?

Hello i am working on a task to improve the current load script for easy readability

we are loading the last 3 financial year files the files are named as follows

eg: Filename_year_2021

Let vFinPayCurrent = $(vMfinyr)&$(vMfinyr)+1; //Current Finpay
Let vFinPayLastYear = $(vMfinyr)-1&$(vMfinyr); //Last financial year
Let vFinPay2YrsAgo = $(vMfinyr)-2&$(vMfinyr)-1; //2 Financial Years ago

For loop to concat all these together,

Set vfilelist ='vFinPayCurrent','vFinPayLastYear','vFinPay2YrsAgo';
for each var in vfilelist
MyTable:
load *
FROM [$(vG.QVDPath)/Filename_year_$(var).qvd]
Next var

CURRENT Approach:

mytable:

load * from 

[$(vG.QVDPath)/Filename_year_$(vFinPayCurrent ).qvd]

concatenate

load * from 

[$(vG.QVDPath)/Filename_year_$(vFinPayLastYear ).qvd]

concatenate

load * from 

[$(vG.QVDPath)/Filename_year_$(vFinPay2YrsAgo ).qvd]

Thanks in advance

Greetings!

During the weekend we upgraded a customer site to Qlik Sense Enterprise on Windows Feb 2024, Patch 3. 

Today the customer is reporting that selections in a composed field (essentially a field presented in a straight table using an expression such as: =field1 & '-' & field2) are not working.  We tried using recent versions of Chrome, Edge and Firefox and we got the same results for all browsers. 

If the user searches for the field value in the column's  search box, then values can be selected, but not when trying to make selections directly using a mouse. 

We tried to see if the same problem is happening in QS Desktop but ts is working OK. 

Could this be a bug? 

Please advise.

++José

Hi!

I have a dashboard with 2 excel tables in the contents (Table 1 and Table 2). I need to do some KPIs, summarizing, values from table 2, but just the ones that belongs to a list of people in Table 1. The field that I need to use to compare between 2 tables is the "key" between the tables. Is there any way or formula I can use to do that conditional exercise. 

Is it clear? Can maybe I build a new table from the 2 existing ones?

Thank you! 

Hello,

I have a data set of 1.3 million rows. For a lot of the visuals I require a long table so when i create a long table it produces 153 million rows. The widgets have a hard time loading that much data especially when the widget is using the long table. the long table gives me what im looking for in the visuals but the widget loading is really bad, Is there any other options that has the same functionality of the long table? 

Hello,

I'm new to Qlik Cloud Integration. 

Creating the Onboard from Onprem to target snowflake.

While running the task, it is keep on going to Queued and not completing with data load to target system.

Only metadata is getting created in snowflake.

I dont have windows configuration access from my side to check the memory or CPU. If anything to verify in Qlik cloud or any other workaround .Please suggest.

With the latest version of Qlik Cloud, I am unable to get to the Data Model Viewer.  Following the information on permissions, I tried the following, but nothing can show.

• Owner of the App - only see Data Manager and Data Load Dditor.
• Can Edit Data in Apps permission - cannot see Data Model Viewer

Even when trying to directly go to the Data Model Viewer from the URL https://my-tenant.us.qlikcloud.com/datamodelviewer/app/{appId}, I get the following.

Did something change recently about accessing the Data Model Viewer?

Hello Im using following script for bar graph, i would like it to be blank and then populated based $Fields selected from a filter but i would like to in the bar graph to be able to show multiple fields and the value count based on what was chosen in the filter. Right now it works but only for 1 filter selected but i would like it to work for multiple. thank you! 

=$(='['&only([$Field])&']')