Hi All,

I am trying to get some data out of an database. However, the load script does give an error in Qlik. When I run the SQL statement in the database, there occurs no error.

See below the error and the SQL statement.

Select
a.FK_BUDGETORDERINTAKEYEAR,
a.BUDGET,
a.MARGE,
a.BUDGETPRODUCTION,
a.PK_U_BUDGETORDERCATEGORY,
a.FK_BUDGETORDERCATEGORY,
a.FK_BUDGETSERVICECONTRACTTYPE,
a.INVOICEORDERINTAKE,
b.PK_R_ORDER,
b.FK_ORDERCATEGORY,
c.PK_R_SALESORDERDETAILMISC,
c.NETSALESAMOUNT,
c.ORDERDATE,
//c.FK_SALESPERSON,
d.FK_FINANCIALYEAR,
d.PRODUCTIONPERCENTAGE

FROM U_BUDGETORDERCATEGORY a
LEFT JOIN R_ORDER b ON a.FK_BUDGETORDERCATEGORY = b.FK_ORDERCATEGORY
LEFT JOIN V_R_SALESORDERDETAILMISC c ON b.PK_R_ORDER = c.FK_ORDER
LEFT JOIN U_PRODUCTION d ON c.PK_R_SALESORDERDETAILMISC = d.FK_SALESORDERDETAILMISC;

Hello, 

A bit at a loss while trying to implement a specific set of actions on a button click. 

I have a table, i have some filters that can be applied. I have a button that selects just the ID after filters are selected and clear the rest of the filters. I want yet another button that does the opposite. It needs to exclude from the selected accounts from the previous selection. Using 'select exclusion' works, but for the whole table. The previous selection is overwritten. 

As in the picture attached, i want to use the filters to get a subset of the 7 ids already selected. Let's say number 1 and 3. The Exclude selection button should exclude 1 and 3 and lock the final selection to 2,4,5,6,7. At the moment it returns all IDs in the table(which ar emore than 7) except 1,3.

Any advice?

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, what do i miss here??

if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',
if(frac(STARTTIME)>=MakeTime(15,30) and frac(STARTTIME)<=MakeTime(22,59,59),'EM','Natt')) as Shift

I want to show chart and insight in WhatsApp using chatbot from the qliksense dashboard , is there any way either easy or difficult. Please let me know I am in dire need of this possibility.

Hallo Zusammen,
ich bin recht unerfahren in der Nutzung von Qlik und würde mich sehr freuen, wenn mir jemand einen Tipp geben könnte.

Ich müsste einen Filter definieren der aus einer Auswahl von Werten einer vorhandenen Tabelle besteht. Die Tabelle hat über 3000 Einträge aus der man mehrere Hundert Werte auswählen müsste, um mit diesen Werten bestehende Arbeitsblätter zu filtern. Die Auswahl aus dem Drop-Down Menü ist mühsam und fehleranfällig, weshalb ich einen Weg suche den Filter mit dem Formeleditor abzubilden. Die Filterwerte würden in Textform vorliegen.

Gibt es eine Funktion mit der man das Arbeitsblatt wie gewünscht filtern kann? Bestenfalls würde ich diesem Filter gerne einen Namen geben und ihn als Drop-Down Auswahl zu Verfügung stellen. Könnte mir aber auch mit entsprechenden Lesezeichen behelfen.

Vielen Dank im Voraus für Eure Hilfe.

I have multiple qvds uploaded in my data load editor with each qvd containing a few datapoints that have similar data but different column names. I created aliases for each to join each other but that created multiple synthetic keys. I want to join these tables so that these common fields can become filters on the dahboard. I can not concatenate the tables since the names are not the same in each table. Adding an example of data below. 

Table 1: 
Load
ProductName
Sales
Cost
Projects
City
From[Source]

Table 2:
Load
Products
Profit
Cost
SKU
ProjectName
CityName

Table3: 
Product
PersonID
PersonName
CityEnName
Project

The filters that I want to create are Product Names, Project Names & City Name. 
Please suggest how. I also tried creating joins but creating multiple joins for more than 20 tables doesn't work either. 

{"errors":[{"title":"State verification failed","detail":"State parameter not valid, try accessing the tenant url directly","code":"STATE-1","status":"401"}],"traceId":"5ca138b53b455ee35f9e25502159cc42"}

 Getting State parameter not valid while accessing Qlik cloud from Single page application .

Using Qlik Sense ClientId and Client secret key  with  Azure AD configuration by ADFS.