All Forums

Hello, I am opening an existing qlik app using qlik.openApp(appId) then creating hypercubes to fetch data from qlik and use it in mashups

I have three challenges when trying to retrieve data using hypercube in a Qlik mashup:

1. I need to exclude a specific value while filtering data. I'm looking for an alternative to app.field.selectValues or selectMatch, something akin to the SQL NOT IN clause. For example, I want to get all records where the country is NOT IN "".

2. On my product comparison page, I need to fetch data for two products either sequentially or asynchronously. I have to apply multiple filters for the first product, create a hypercube to store that data, and then apply filters again for the second product, repeating the process. However, I've noticed that sometimes cube returns the same data for both products. This inconsistency is puzzling; about 50% of the time, it provides the correct, distinct data for the two products, but at other times, I receive identical data. I've experimented with various JavaScript methods to manage asynchronous behavior, such as promises and async/await, but the results remain unstable.

3. Occasionally, some values are returned incorrectly. At times I dont require any dimensions but just measures like SUM, Avg but here the values displayed in the Qlik app do not match what I get when querying in the mashup through hypercube. Refreshing or filtering again sometimes resolves the issue, but this behavior is also inconsistent, as the same code works at times.

For fetching data I am using app.createCube and to apply filters app.field().selectValues or selectMatch. I am a web developer and good with working with apis but not very famililar with qlik hypercube filtering. Any help would be greatly appreciated. Thanks!

Hi,

Currently we are using JWT Proxy workflow with section access. We use qlik mashup api's to load the qlik app.

We would like to continue to do so, but the current issue we are facing is socket's disconnection while relaying the requests. We would like to remove our backend so that it can directly connect to qlik.

Is this something possible with M2M? I could not find any examples for M2M with mashup api's. We cannot use qlik embed since we would need to we-write the application itself.

@Jeffrey_Goldberg  Could you provide any input on this? as you suggested the initial approach for proxy when there M2M impersonation was not available?

Thanks,

Akshay

Hi, 

We are trying to use Qlik sense Enterprise on org tablets.
When using Tablets we see that hub is trying to open, but then we get error: "Internal Server Error"

Please note that accessing from local computer is working properly.

Thanks

I have two REST API connections set up. In the first one, I retrieve a token, and in the second, I send a message. The issue is that the token is dynamic, and I haven't been able to create the second connection, even as a generic one, to modify it later in the code. In Python, it works fine because it's a single operation.

Hi, I'm having a hard time trying to display a floor plan in a map object. Basically I want to show the floor plan and then build some shp or kml in QGIS to plot over the image and have selectable areas, etc.

The expected output would be something like this:

I'm just very lost. I found and followed multiple tutorials, but most of them is using Qlik Desktop and I'm on SaaS. They are also from 6-8 years ago, so it's probably different now, there are new connectors, etc.

My main struggle is showing the image. The image has 1920x1080px, so I've set it like this (saw it in a post):

I've set the map to use "none" as base and "user defined meters" as projection. I made it work a couple times, but I'm assuming the image is too small comparing to the "base" map. I guess I just lost the image in the map and the "home" button doesn't even click, it's just grayed out. I've managed to display it and then started trying to add the area layer, but the map then moves/zooms and I guess I lose the image somewhere.

I'm pretty sure this is possible I'm just getting crazy, please help.

How can I have a big enough image over the map so I don't "lose" it around?

How can I match the area layer coordinates to the image?

PS: I've attached the image and the KML in case an angel would be willing to share a qvf

Anyone have luck getting the Qlik Mobile App to generate a CSRF API call successfully? Seeing no issues using the call on desktop and mobile browser but when using the Qlik Mobile App, the CSRF call doesn't return a token. 

I submitted a support ticket but it was suggested to post here as well.

Hi, I have Qlik Nprinting (May 2021 SR2 Version: 21.14.5.0)

I want to make a report per week, so each sheet has a separate week number, and in there is a pivot table with data for that week.

Sheet per week I make by levles -> its ok

after:

I make a pivot table based on a normal table from Qlik  -> its ok

My table is made like this, unfortunately after refreshing, it is not consistent with the expected result, I wanted the weekend number to be in B1.

How can I fix it?
before

after

Good day All, 

I have a question. I have long/lat inside my fact data. I want a process or idea of how i can dynamically search that and it gives me the region, city, country for those coordinates.

Dear Community,

I getting below error when I am trying to load KML file into Qlik sense.

The file you are attempting to load is corrupt. Check the file for errors and try again.

Error code:3002

When I load the same KML file in Google Earth Pro it's working fine.

Kindly suggest if there is any other way we can achieve Area Layer Map.

Best Regards,

Sudheer

Hello everyone, let me explain my problem

Several reports are filtered at recipient level, so that each recipient only receives data for his or her region. So I've created a filter for each recipient in the distribution list as well as in the application, and so far it's working well. But I have other reports in other applications for the same recipients where they must receive all the data, so no filters.

Report generation doesn't work because filters are present in the distribution list but not in the application, since I want to send all the data, my questions :
- What if some reports have filters at the recipient level, but for others I want all the data? Do I need different distribution lists? One with my filters and one without?

best regards

Hello there guys,

We have a very large & complex deployment in our site which uses Nprinting/ODAG/SessionApp/Mashup/HUB access solutions all at the same site. Also we have a very large developer team, we already shared them a QlikClient certificate in order to automate things like cachewarmup/app deployments etc.

My problem is somehow someapps are loading memory into central or centralfailover server. But none of our virtualproxies set to forward loadbalance requests to central or failover node. Is it possible to find our IP that made or trigger this open app requests? 

When i investigate Engine>Trace>Session logs, i can find appID and user. But proxysessionID is "0" for all of them. I have to match this proxysessionID with Proxy>Trace>AuditProxy logs in order to find IP Address. But 0 matches with nothing. Is there a way to find, which IP triggers/makes these open app requests or how this apps opened in central nodes?

In one of our security assessments, we got a finding in Qlik Sense as follows:

'Disable the use of verb tunneling such as http verb: HEAD using such headers or query parameters. If a legitimate case exists to enable this feature, it is important to restrict access of such requests to its intended purpose.'

Could anyone please provide guidance on how to disable verb tunneling in Qlik Sense?

Hello,
We have a language difference for error messages when there is no data, the message is different between the QlikView application and the report generated by Nprinting.
The application was loaded correctly, as was the metadata, but there is a language difference.
we have test :
- Modification of the expression: in Qlikview it's in French, but in Nprinting it's in English.
- Modification of calculation conditions: in this case, the correct language is taken into account.
However, in this case we have to create a new expression for each case.

can you help me

here are the screenshots

In qlikview  :

In nprinting : 

Thanks in advance

My company is currently against allowing our users to connect to our Qlik Sense SaaS tenant using the mobile app. Is there a way to block this functionality for some/all users?