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!

Greetings!

I am looking for the most recent version of the document titled "Natural Language Query Features", December 2019.  Please see attachment of the doc I am referring to.

Cheers,

++José

Hi,

I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis.

The differences is that in the balance sheet you have an ingoing balance and then the changes during the month is booked and then you get an outgoing balance, in my dataset there is no ingoing balances available from the database from any tables that I've found.

I want to to a rolling 12 months analysis on inventory turnover rate and need to be able to calculate averages for a twelve months period every month ending to get this KPI. 

I've added the ingoing balance for 2021-05-01 manually and concatenated with the transaction data, from this I can get an outgoing balance every month with RangeSum and Above where I've set period of times to 100000, (maybe there is a smarter way) which gives me the outgoing balance every month.

RangeSum(Above(Sum({<Sub_Group={'Inventory'}>}Amount),0,100000),)

How do I use this? I need to bring the value from 2021-05-01 to 2024-03-31 for example to be able to get my outgoing balance for 2024-03-31, see example below.

Is there a way to make a calculated field instead to use in set analysis or any other way that is more simple just shoot with ideas!

Help much appreciated, thanks!

We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load is going success the job is failing with the error Failed to rename file repcmd.log to repcmd__240417043324.log .

Hi everyone, I'm having trouble with a task and need some help.

I have two tables:

• One with all the products in a CRM - (ImportedProducts)
• One with all the products and prices from an ERP - (PricebookView)

I want to update the prices of all the products in the CRM (ImportedProducts) based on the prices in PricebookView. To do this, I need to make multiple API calls with the following structure:

URL: www.url.com/products/ {productid} where {productid} is dynamic and represents the ID I have in ImportedProducts

BODY (to update the subtotal, for example):

{
  "subtotal": {price}
}

where {price} is the price for the {productid} in the URL. Of course, there are many prices to update.

I've implemented the basic job functionality, but I'm stuck on how to pass dynamic values to the URL and body. Any suggestions? Thanks!

Here the actual job has an error (Syntax error on token "") }"", delete this token. But I think this is not only a syntax error but a structure error.

Talend Studio 

Can anyone explain how to create merged column headers in a table? I.e.

Group Column Header 1     |   Group Column Header 2

Sales| Region| Country|           Product|Price|Distributor|

Right now I have ValueList(Header1, Header2) dimension and expressions conditional on ValueList(Header1, Header2)='Header 1'

but the table says all expression are disabled.

Thanks

(Apologies, this was posted earlier but was my post was so full of flaws, I removed it).

I am trying to show a graph of tickets raised over a periiod of time.  In my data I have zero 'Open' tickets in October and as a result October does not show on my graph.

I have tried a 'Master Calendar' which works until a filter is applied.  -

I have also read about adding + sum({1}0) to my measure.

Count({<[Status]={'Open'}>}id) + sum({1}0)

and setting the Addons -> Data Handling -> Include zero values 

Any help would be appreciated