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!

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.

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: 

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

Hello,

We have been successfully using the old Variable object that I believe we obtained from Qlik Branch/Garden/Sandbox quite some time ago. We recently decided to replace instances of that object with the Variable Input object found in the Qlik Dashboard Bundle on the assumption that this one is "officially supported" by Qlik and that would be safer to use in the long run. 

However, we have discovered that in "button" mode, some of our button labels are being truncated where they weren't with the old variable object. Also, in "input box" mode, the right side of the input box extends beyond the edge of the object; again, this didn't happen with the old variable object. 

Is anyone else experiencing these issues? 

Hi, I am new to qlik,
I have a pivot table with the dimensions group and subgroup.
the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
( (Num_Subgroup & '- '& Subgroup)).
The problem is that I get a null concatenation in the filter panel.
in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
Can you help me, please.