Please tell me how to correctly write the formula for the measure of a diagram:

If the variable “filename” contains “AP”, then calculate the ratio of the number of values “1” for the variable “Code by Classifier” to the number of the sum of values “1” and “0” for the variable “Code by Classifier”

I tried two formulas, but both did not work correctly, it seems to me:

1. If(WildMatch(filename, '*АР*'), 

   Count(If([Code by Classifier] = 1, 1, 0)) / Count(If([Code by Classifier] = 1 or [Code by Classifier] = 0, 1, 0))

)

2. Count({< [Code by Classifier] = {"1"}, [filename]={"*АР*"} >} [Code by Classifier]) / Count({< [Code by Classifier] = {"0", "1"}, [filename]={"*АР*"} >} [Code by Classifier])

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: 

Hello,

Just wondering if this "works as designed" or if it's a bug. In Qlik Sense Enterprise, when you go into an app's settings and select Disable Sheet Header, the nav icons "<>" are no longer present. This may seem obvious, but I was told by someone that in Qlik Sense Cloud, they appear in a different location.  So I was wondering if that claim was true and if they should also be visible in Qlik Sense client-managed as well. 

Thank you

Steve

Hello,

Is it possible to have a Qlik Enterprise manager version November 2023 hosted on a Windows server, that manages Linux hosted Qlik Replicate server, version May 2022?

Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:" 
Processing aborted due to error 300002:1355844283; incident 3722464.
to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;

What does this error mean?  

Hello community

i made a post aksing for help to load and empty table, at the end i could find a solution, using a where 1=2 on the consult,

but the problem its that im trying to load field from TABLES in SAT DATA BASE, so

i desing this, in order to load this tables, but as i understand qlik always look in the record on the tables, that means if i say 1=2 i know this is false and the result will be none data, but qlik dont understand that way, making this consult take like 30 min or more to load only empty fields, so i wanna know if there is a way to load the empty field, by telling qlik bring ONLY THE FIELD AND DONT LOOK IN THE RECORDS or always will be that way? cuase i really need load like 40 Tables and we are talking about like tables that contains records from many many year, you will say add a filter in the field of years, the problems is that the field year can be called in diferent ways in diferent tables, and some other dont have that field, so finally im thinking in something simple, JUST BRING THE FIELDS AND NO DATA. Is that posible? one more thing i know qlik make relation and i try to cancel this with a no concatenate but it dont work is there a way to cancel the relation beside the Qualify sentence?

Set vTablas1 = 'MARD','MBEW','MSEG','T001','T001L','T001W';
set vfield = 'BURKS', 'WERKS';
FOR  each i in $(vTablas1)  
 let WhereClause = '1';
	for each j in $(vfield)
    let fieldexist = FieldNumber('$(j)','$(i)');
    if $(fieldexist) > 0 then
		LET FieldValue = IF('$(j)' = 'BURKS', '1000', '1081');
        LET WhereClause = '$(WhereClause) AND $(j) = "$(FieldValue)"';
        End If;
        next j;
  Qualify*;      
    '$(i)':
    LOAD 
    * ;
    SQL SELECT * FROM $(i) where 1=0;
NEXT i

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!