Hi all. Please advise how to avoid data duplication for the example below?
I have 2 tables

tab1:
Load
    calendar_key,
    product_key,
    operator_code_1,
    operator_code_2
    sales_dollar,
    sales_unit
from Sales;

tab2:
Load
    operator_key,
    operator_Id,
    operator_name
from Operator;

I need to connect these tables using condition that operator_key = operator_code_1 and operator_key = operator_code_2.

My idea is to solve it like this

Tab_Fact:
Load
    calendar_key,
    product_key,
    operator_code_1 as operator_key,
    sales_dollar,
    sales_unit
from Sales;

 Concatenate(Tab_Fact)
Load
    calendar_key,
    product_key,
    operator_code_2 as operator_key,
    sales_dollar,
    sales_unit
from Sales;

But as result of this solution makes data duplication. And I'm struggling to find solution that will allow to avoid it. 
Also, just map operator_key to operator_code_1 and operator_code_2 is not an option. Operator_Id field should be used as single fields for the section access. 

I'll appreciate any ideas on this case. 

Hello,

I manage to create a simple alert to test my SMTP parameters and it worked.

Thus, I would to have my data in the right format, and Qlik send me a CSV file where each row look like this :

5515,1, 39 € ,2 €,"5,74%"

I think this "€" is "€" 

Is there a possibility to choose the format in the csv file ? Or have a excel file instead ?

Second question :

When I create my alert, I would like to add multiple dimension, but I didn't manage to do so.  

Is it possible ? 

Many thanks for your help.

Hi friends,

I have been using Qlik web connector for Facebook, Twitter and Youtube data but can't find a connector for Instagram.

Is there a way to extract the data from Instagram in Qlik Sense using any other connector. If yes, Can someone please guide me.

Looking forward for positive replies.

Thanks and Best Regards

Hi,

I'm trying to create a EDI route for ORDERS. I have a sample file .edi in iput and trying to mapping it to a xml file. but it seems that the loop is not so good. I'm stuck.

Impossible de trouver un segment correspondant à "BGM[220,CMD-2026-009,9]"
Élément de map: /ORDERS/Loop-UNB

could someone help me please.

Apologies if this isn't the right part of the forum, I am happy to be directed to the appropriate place! I have reviewed a lot of the information around canonical dates here in the Community (Canonical Date - Qlik Community - 1463578, Let's Take a walk on the Calendar / Date Bridge: ... - Qlik Community - 2133428, Working with Multiple Calendars) and think I have a general sense of what I'm doing to make a canonical calendar but I'm running into a conceptual blocker that I would appreciate some help with.

In my dataset, customers apply for a course, have an assessment date, and a course start date if they are successful and then end dates each step. That's 6 dates in total - application receipt and process date, assessment start and completion date, and then course start and end date. During the course, there are regular reviews that are each associated with a single course record. Thus the course to review relationship is a one to many.

I am relatively confident in creating the canonical date for each of the start dates but two stumbling blocks I'm hitting are:

1. The start dates and end dates exist in the same table. When I add both into the canonical calendar, it creates a synthetic key as they share two columns. If my understanding of the canonical calendar is correct, I need to link each date that I want on the calendar. It is not sufficient to have just the start date connected to the calendar because it means that filtering by the canonical date will only include assessments, for example, that start on that date, not those that also end on that date. If so, I would appreciate guidance on preventing synthetic keys without reconfiguring the source data table.
2. One piece of guidance in the advice of developing a canonical calendar is to select the most granular record to develop your calendar around so you have a single date per record. The example given in my first link creates one table with all the dates. However, I would like to avoid doing this with my dataset as joining the reviews onto a application - assessment - course table would make it grow exponentially and duplicating a lot of data from a storage perspective with little gain in analysis terms. I can't see a reason why the canonical calendar won't work by just joining distinct tables to the directly to the date bridge rather than joining everything into one table but I am a novice, is there something I'm missing or can I just join my review dates directly to my date bridge?

Hopefully the above make sense but if any further information is required, please do shout! Appreciate any support anyone can provide.

Thanks in advance!

A um tempo atrás encontrei um artigo neste fórum explicando como eu poderia acessar o qlik sense Interprice por um tablet usando uma espécie de webservice, Sem a necessidade de estar logado na rede onde ele está instalado. 

Não encontrei mais este artigo, alguém poderia compartilhar?

Hi,

I've been encountering an issue with importing apps for a while, and I'm trying to fix it.

The environment is Qlik Sense Enterprise, May 2025 version.
The issue is the following : when I try to import a QVF with the "Import" from the QMC, if the QVF is too big (only a few Mo), I get the error message : "Failed to import app. Please check the log file."
There is nothing of note in the logs, and if I import a QVF file of 160 Ko, there is no error.

The first curious thing is that the QVF file I try to import is a file I exported from another environement (typically, export from test to import in production), and I always make sure I export it without data, to be sure the file is not too big (5 632 Ko exactly for the file I used to test the import).

The second curious thing is that there is a workaround, with the choice of URL :
-I get the error if I try to import the QVF while connecting to the QMC from my desktop.
-If I try it locally, from the virtual machine where Qlik is installed, I also get the error if I use the same URL to connect to QMC than from my desktop.
-But, If I try it locally, this time connecting to the QMC with the localhost URL (https://localhost/qmc/), I can import the very same file (5 632 Mo) that created an error.

There is supposedly nothing wrong with the URL I use from my Desktop, since I can import the 160 Ko file.

So far, I didn't find anything explaining this difference of results depending on the URL.
Is there something I could try ?

Best regards.

Hi Friends,

We have recently lost our remote server where we had Qliksense Enterprise installed. Server is not Turning ON due to Hardware/Disk failure. Server was not a VM and we dont have uptodate backups for our Qliksense apps/data/repository.

We are looking for recovery options but not sure whether we will be able to recover everything.

If we are able to recover, What should be our next steps to get our Qliksense working again on a new VM?

Can someone please share step by step process to restore Qliksense in a new machine.

Hi,

I am using a proxy to connect Talend Studio to the internet. While I can see the projects assigned to me in 'Studio Projects', the Git branches fail to load. Aside from *.github.com, what other URLs or endpoints need to be whitelisted for Git synchronization to work properly?

Thanks.