I have two fields like 

Order Quantity and Net price Net price in Decimal so I want to include Decimals also. If I use Round Or Floor or Ciel I will miss or Get More Spend.

Output should be like This

Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024

A EXPRESSÃO QUE ESTOU USANDO É: 

( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)

ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
 

Is it possible to do an interval match with two set of intervals? In my fact data, I have the field month end, which looks in the interval Effective Start and Effective Stop. In that same interval match function, can I have the Sales field from my fact data, look in the interval Min Threshold and Max Threshold as well? This is ultimately so I can find out what scale to give my fact data, based on if the sales is between a certain amount and if the sales took place between a certain date range.

Here is what my two tables look like.

Fact Data:

Dimension/Intervals Data:

I have just installed Feb 2024 on a lab server for testing.

Have imported one of our production apps (from Feb 2022 cluster) which uses derived fields for calendar dimensions using the DECLARE FIELD DEFINITION....FIELDS and DERIVE FIELDS FROM FIELDS .... USING .... script construction

There seems to be a bug with the derived fields  - it recognises them and shows them in field list but in expression editor it reports an error in expression with red border round field box and when using the derived fields in conjunction with a function - in this case the CLASS function it does not work and returns an error

This all works 100% OK in our Feb 2022 production environment

Has anyone else encountered this ?

Hi All, 

I have run the below command in the bin folder of the Qlik server which is installed in F drive.

My outfolder will be D drive. 

ComposeCli.exe export_csv --project WH_Master --outfolder D:\WHPUAT

This command exported all csv files related Model, Mappings and Data Marts only.

It didn't export any files related to Datawarehouse tasks and SQL files and also showed an error 
SYS-E-HTTPFAIL This given path's format is not supported.. 

Could you please help me with this error. 

Thanks!

We have some python scripts residing in one of the qlik nodes which is connected to qlik sense (which resides in aws server) through analytic connection
is it possible to move those scripts to aws lambda function and establish a connection from Qlik sense enterprise windows ? I believe AWS lambda connector will work with Qlik cloud only.

Hi all,

i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.

the token is made up like this:

user details: name sub and email are the exactly like the console.

any idea of what can go wrong here?

thanks,

Loris

due to find Qlik Sense Enterprise for Windows Remote Code Execution (RCE) Vulnerability (Authenticated). with suggestion we need to install patch 6 to solve this problem. 

After download the patch and run with administrator on server.  System show logs and installation failed.

detail see file attached. 

It is very urgent for me to find a solution.  Any one met same case and solved.

BS

jens