Hello,

I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
if(Gender='F','Female',if(Gender='M','Male')). it works fine.

Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

could someone help please?

Thank you!

I am getting this kind of error while importing file

:5500/:1 Access to fetch at 'http://localhost:4848/resources/qmfe/import-map.json' from origin 'http://127.0.0.1:5500' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.

I am using pure JS and HTML to work with , is there any suggestions for me?

Bonjour,

On a 2 conteneurs : le premier conteneur contient des graphiques sous forme de synthèse et le deuxième conteneur des tableaux simples et/ou croisés dynamiques sous forme de détail. 

Est-il possible de faire en sorte par exemple si on clique sur l'onglet Synthèse A dans le conteneur 1  on a automatiquement l'onglet Détails A qui s'affiche au niveau du conteneur 2; si on clique sur l'onglet Synthèse B dans le conteneur 1 on a automatiquement l'onglet Détails B qui s'affiche au niveau du conteneur 2 ainsi de suite ? Sachant qu'on les mêmes dimensions et mesures entre les composants des 2 conteurs (par exemple les dimensions et mesures de "Synthèse A" sont les mêmes que ceux de "Détails A" ... c'est juste qu'on a plus d'informations dans les onglets Détails ... que dans les onglets Synthèse ... (cf. capture d'écran ci-dessous) :

Y aurait-il des cas similaires qui ont été remontés dans ce forum ou des méthodologies à suivre dans Qliksense qui pourront nous aider à traiter cette question ?

Merci par avance,

Cordialement, 

------------------------------------------------------------------------------------------------------------------------------------------------------

Hello,

We have 2 containers: the first container contains graphics in summary form and the second container contains simple and/or pivot tables in detailed form.

Is it possible to ensure that, for example, if we click on the Synthèse A tab in container 1, we automatically have the Détails A tab displayed at container 2; if we click on the Synthèse B tab in container 1 we automatically have the Détails B tab which is displayed at container 2 and so on? Knowing that we have the same dimensions and measurements between the components of the 2 storytellers (for example the dimensions and measurements of Synthèse A are the same as those of Détails A ... it's just that we have more information in the Détails ... tabs and in the Synthèse ... tabs (see screenshot below) 

Are there similar cases that have been reported in this forum or methodologies to follow in Qliksense that can help us address this issue?

Thanks in advance,

Best regards

How do I create an expression similar to the following?

sum({<Field1={Test1}, [Field2]<>[Field3]>} [Field4])) 

Field4 should be displayed if Field2 and Field3 are not equal. If I create an expression as above, I get an error because <> is not a valid relational operator.

How do I create this correctly?

First - is there a good place to learn the qlik expression language that anyone particularly enjoys? I'm trying to use ChatGPT and not finding it terribly helpful.

My main question is out of this dataset that I have attached, the request is to calculate the:

Count of Consent Date, where Consent Date is not Blank, the Inactive field does not equal YES, and the Delivery Date IS blank.

How could I structure this? I've tried multiple ways and keep getting 0's. It looks like any blanks are being populated with "-" when I look in Data Manager, and I've tried to update formulas accordingly but still not having success.

I trying to do a binary load, but I get error message "General Script Error". How do I solve this issue. 

Does it make a difference if the QVF file is on the server file vs personal drive when loading?

Also, Is there a way to remove section access after a binary load? 

HI Team,

Hope you are doing well. We are upgrading Qlik version from Nov2022 to May2023. After upgrade we have faced issues listed below:

- Font color changed for few KPIs

-Text alignment changed 

-Some charts showing invalid visualization error

- some front end formulas not working. 

Kindly help here at earliest.

Hello everyone,

I am trying to distribute a slightly larger table with Tabular Reporting. The table has 31 columns and, depending on the filter, 100-200 thousand data records.

When I try to export it, I get the message in the preview: Max number of objects exceeded in report, error code: REP-400039.

Now the help (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-service-specifications-limitations.htm) says something about

Reporting limits for the Qlik add-in for Microsoft Excel
Metric Value
Maximum number of nested levels in a template 5
Maximum number of object tags in a template 200
Maximum number of objects per generated report

A single chart, variable value, level value, or expression value counts as one object.

For Excel tables, 500 generated cells count as one object. If there is an additional remainder of less than 500 cells (for example, several smaller tables containing a total of as many as 499 cells), this does not count as an object.

50,000
Maximum number of generated images in a report 1,000.

Does this mean that I can generate a maximum of 50,000 cells per report (in my case 31 columns x 1612 rows)? Per Excel file, per tab sheet?

Maybe someone can help?

Thanks and regards.

Hi, I have been trying for a couple days to solve the JVM compatibility error.

I get the error when I try to run a job from my imported Talend workspace.

The Java I have installed is of version 11. The compiler is set to 1.8 by default.

I've tried several things:
- Modifying a configuration file of Talend and then adding a Java path as well.

- Getting third party modules to see if it would help resolve the error.

- Reinstalling Java and Talend. I also tried different versions, such as 8 and 22.

I've also tried different solutions that I could find online but none of them seemed to work.

Please help, I can also supply more information if needed.

Kind regards,
J.