Hi all,

Have to do a Lookup to find out the Name of the case handler. Each case handler has an abbreviation (KURZZEICHEN) and all specific details are locatated in Table "SB".

The Table "PE" has order information. Each order has one case handler and two contact persons. The abbreviations of the contact persons are located in Table "ST". All Details of contact persons and case handlers are in the Table "SB".

Goal:

Would like to do a Lookup to find out which person has the specific abbreviations (Table "ST" ST_KURZZEICHEN1 & ST_KURZZEICHEN2) from Table "SB".

Would like to have an output with all Dimensions information in one table. With this Data Model I get an cartesian product. Thank you for your help.

Hola! Favor su ayuda con este problema. Cómo puedo, en una tabla pivot, hacer referencia por cada fila al código del cliente para obtener la misma fórmula que al filtrar cada uno de los clientes.

Así se ve la tabla cada vez que filtro un cliente, mostrando las ventas de los otros clientes que coinciden con su categoría

Lo que necesito es que sin filtrar clientes, en cada fila me sume el total de ventas de cada cliente que coincide con sus categorías.

Se agradece cualquier tipo de idea para obtener el resultado, muchas gracias!!

Hello,

I am new to Qlik and having difficulty in joining tables. Below is my code in SQL, can you please help to write in Qlik language?

SELECT C.Customer_ID, C.Customer_Name, C.Address_ID, O.Product_Name, A.Address_ID, A.City
FROM
Customers AS C
LEFT JOIN Orders AS O ON C.Customer_ID = O.Customer_ID
LEFT JOIN Addresses AS A ON C.Address_ID = A.Address_ID

Thank you

Hi All,

I have a field 'Year ' in filter pane and I have to default this filter to recent 3yrs of date(2017,2018 and 2019) .
How can I do it?

Thank you in advance

Hi,

I have a table like this:

I would like to count how many ID_USERS are in each marital status, but annually the patients are monitored and the question about marital status is asked again, so the status can change. I need an expression that count the max date record for my patient not to duplicate. 

ps: i don't use the date in my dimension

I have below KPI , its not changing color as per the conditions specified in the code 

Text object prop-> Background -> color> calculated

Conditions: Display RED if % > 70 (default)

Display Red if % > 20 (when anything else is selected on the block chart)

Hi,  I have the following xls table :

Is it possible to transpose this during the load so I can get :

etc

etc

Many thanks for any help

Phil

I have written this script to create one column with most recent update

If(Oppty.Date >= Contact.Date, [Oppty.Date], [Contact.Date])
as LAST_ACTION_DATE

Now some values of [Oppty.Date] and [Contact.Date] are null.

I want to introduce another line of code to take the field with a date if the other is null. Please help

Dear friends,

Suppose I have three columns like this:

So, my goal is to know which NAMES has values from VALUE1 that also appear in VALUE2. I wish to have a result like this:

Note that EEE's FLAG value needs to be NO, since his VALUE1 (4) does not exists in VALUE2 column,

Anyone can help me? many thanks in advance.

Boa tarde.

Peço ajuda para conseguir somar valores distintos numa mesma coluna. Apliquei a seguinte fórmula, mas o resultado apresentando é diferente do que deveria ser, fosse calculado pelo excel:

count({<[TEM NA PLANILHA DA NATÁLIA?]={"SIM","SIM - 16.10.2019"}>}[TEM NA PLANILHA DA NATÁLIA?])

Na coluna existem 03 (três) valores distintos: "SIM" , "SIM - 16.10.2019" e "NÃO".

Necessito de apresentar através do campo KPI apenas os dados "SIM" e "SIM - 16.10.2019".

No excel o resultado apresentado foram 69. Já no Qlik Sense foram 245.

Att.;

SLRMenezes