We've been setting up dashboards in the SaaS cloud solution for Qlik Sense Enterprise. Now we'd like to fetch and display such visualizations in our React.js web app using the qdt-components package, either using the visualization API or Picasso. However, when I try the demo code (from https://github.com/qlik-demo-team/qdt-components/blob/master/docs/usage/React.md), I get CORS errors saying:

Access to XMLHttpRequest at 'https://<our account>.eu.qlikcloud.com/api/v1/csrf-token' from origin 'http://our-app.loc:3000' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.

Access to XMLHttpRequest at 'https://<our account>.eu.qlikcloud.com/api/about/v1/language' from origin 'http://our-app.loc:3000' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: The value of the 'Access-Control-Allow-Credentials' header in the response is '' which must be 'true' when the request's credentials mode is 'include'. The credentials mode of requests initiated by the XMLHttpRequest is controlled by the withCredentials attribute.

WebSocket connection to 'wss://<our account>.eu.qlikcloud.com/app/<app id>/identity/wejlwWbvqWuKeIui?reloadUri=http%3A%2F%2Four-app.loc%3A3000%2Flogin' failed: HTTP Authentication failed; no valid credentials available

I've noticed that all tutorials and most posts use the Windows server software, which seems to have settings for CORS/CSP as well as things like virtual proxies. How can we do this in the SaaS cloud version?

If somebody could point us in the right direction, that'd be awesome!

Hello Friends,

Appreciate your time. I am looking for a solution to show the excluded values(in the grey color instead of disappearing) after making a selection in my Qlik Sense table.

for example,

let say I have the below table

customer,units

1,10

2,20

3,30

4,40

5,50

In a QS table, when I click  the first row, the rest are all getting removed, Is there any way to show it in a gray color instead?

I have attached a demo app for your reference

below is my expression

units: aggr(sum(qty),customer) 

Thank you,

Kiruthiga

Hi,

I want to create a range filter where users can select the beginning year (from drop down menu) and ending year (from drop down menu) and get revenue for those years.

For example, data includes 2015 through 2019. But a user may want to select data from 2016 to 2018 and therefore input those years as beginning and ending years.

Is this possible?

Note: I am aware that I can create a list box but I am not looking for that.

Thanks,

CD

Hello,

I want a same situation , in my fact table (Contrat) , i have two date (begin_date and end_date) which mean begin en end of contrat identify by Contrat_ID.

I want when a user choose one date (month , year or complete data) , application show a contrat that selected date is between begin_date and end_date contrat.

Contrat:
load * inline [
Contrat_ID ,Home_Contrat_ID, begin_dade , end_date
1,1,'01/01/2017','01/01/2018'
2,2,'01/01/2014','01/01/2016'
3,3,'01/11/2014','01/12/2014'
4,4,'01/11/2014','01/12/2014'
5,5,'02/09/2019',''
];
// '' means blanck space, when the contrat is active
// Contrat_ID = Home_Contrat_ID
Resident:
load * inline [
Resident_ID ,Contrat_ID , first_enter_dade , out_date
1,1,'01/01/2017','01/01/2018'
2,5,'02/09/2019',''
3,4,'01/01/2014','01/12/2014'
4,2,'01/01/2014','01/12/2016'
5,3,'01/11/2014','01/12/2014'
];

Home:
load * inline [
Home_ID ,Home_Contrat_ID, home_type
1,2,'T3'
2,4,'T1'
3,5,'T7'
4,3,'T3'
5,1,'1'
];

Datamodel

Hi, 

I am defining some set analysis in a variable like below..

vSetAnalysis

MonthYear={' & chr(39) & '$(vSelectedMonthYear)' & chr(39) &'}

I now need to use this variable in the set analysis in the actual expression like below but i can't get it to work..

Sum({<'$(vSetAnalysis)'>}Sales)

Can anyone help to get this to work please?

How to create this association for ShipTo and BillTo address associated to an order header? In T-SQL for Microsoft SQL Server, we use the following SQL for reports.

select h.cust_order_number, BillTo.Name, BillTo.Email, ShipTo.Name, ShipTo.State, ShipTo.Country

from orders h

left outer join addresses ShipTo on h.shipAddressRef = ShipTo.addressID and ShipTo.type = 'SHIP_TO'

left outer join addresses BillTo on h.shipAddressRef = BillTo.addressID and ShipTo.type = 'BILL_TO'

The first association is created correctly, when I pick the address table and apply a filter (i.e. type = 'SHIP_TO'). How do I pick the same table and apply a different filter for the BILL_TO? Qlik Sense Data Manager is replacing the first address and association, instead of making the second association as I intend. 

In Qlik cloud I created new app with new connection to Microsoft Azure SQL database. Connection test worked fine. Then I was able to see the data through "Select data" option. Script was inserted without any issues as well. But then I try to load data I get this error message:

Hi!! I've been having a really rough time trying to solve this but i keep on getting bad Data. The context is i'm trying to join Leads with effective purchases, and i need all the values from the purchases to add on to the matching Social Security numbers on my Table of Leads (or another table alltogether) in order to understand conversion rate values.

The challenge i'm trying to figure out is that in Tables B and C, sometimes the Social security numbers are duplicated because one person can be the buyer for several products, so I can only count the record once or I get crazy conversion rates (Ex: Google shows, for product B, 120% conversion rate with 40 leads, and more than 40 sales because it isnt de-duplicating correctly with "DISTINCT")

What I need to figure out is how to load the following so that the Lead, that has richer data, joins with the sales data from tables B and C.

Here's an example of the data i'm loading:

Table A (LEADS):

SOCIAL SECURITY NUMBER,

Origin Platform (Facebook/Google/ETC),

Name,

Last Name,

If lead is PAID or ORGANIC,

PRODUCT INTERESTED IN (between A and B),

DATE

TABLE B (PURCHASES PRODUCT A):

SOCIAL SECURITY NUMBER (OF PURCHASER),

DATE (OF PURCHASE),

TABLE C (PURCHASES OF PRODUCT B):

SOCIAL SECURITY NUMBER (OF PURCHASER),

DATE (OF PURCHASE).

Can anybody help me solve this? It's eating my brain away.

Hi All,

Can we enable Status->Task tab in qlikview QMC for specific users. Basically we need to provide only privilage to specific users run their tasks in QMC. Not to touch anything in Qlik view QMC.

I thought I understood RangeSum was able to ignore a value that doesn't calculate, like if adding up field1 + field2 + field3 and one of the fields is null or not numbers.

I am trying to use RangeSum(var1,var2,var3) to add up three variables and it is not working .... I can't figure out why. The var1, var2, and var3 are calculating fine. I can see them when I put them in separate expressions by themselves.  When I change from RangeSum to var1 + var2 + var3 it works correctly. Why? 

I'm not using any of the powerful parts of RangeSum for accumulation or anything like that. Nothing fancy at all. The variables I have are just large-ish expressions and I need to add some of them together, so instead of repeating the expressions, I use the variables. 

I am using QlikView 12.4. Any help or suggestions are appreciated, thank you.