Hello ,

I have attached the data set and  I need to achieve below :-

1) Using aggregate function in qlik to join Issue and type of claim inorder to show top 10 unique issue by type

2) Create heatmap/treemap in QLiksense showcasing Issue wise state contributions on Losses with color highlight increase or decrease over years/month

Can anyone please help me with this ?

Thanks in advance

Hi. I have a dataset with the fields: Account_id, account_score, year_quarter, YearQuarterKey (which is a running sequencial number for every year-quarter combination). I want to use set analysis in a table presentation on my app, and to add the field previous_quarter_score to every row ! in the table, according the field YearQuarterKey I tried: =max( {< YearQuarterKey = {"$(=(YearQuarterKey-1))"} >} account_score) It did not work. Any thoughts on how to accomplish this? Thanks

Hello,

I am a beginner in Qliksense and I have a question on the use of set analysis.

My data are formatted like this : [Date] , [ID], [Contract], [availability], it is a database that record everyday if employees are available and what is their contract (CDD, CDI)

I would like to compare two different dates in order to know how many employees are CDI and how many are CDD

I have 2 dates picker with 2 differents alternatives states : Date1 and Date2

I don't manage to have the correct KPI corresponding to the selected date. 

My expression is : =Count({<Contract={'CDI'}>}Distinct ID)

And this KPI is affected by Alternative State "Date1"

Could you please help me ? 

In my organization, we have a Qlik Sense Enterprise server. We have a website where we create mashups for non-public apps (no anonymous access allowed).

For each mashup:

• Our website authenticates the user and checks if they are authorized to access the mashup.
• If not authorized: we show an error message.
• If the user is authorized:
  • Our website requests a ticket from the QPS API.
  • We make the user's browser request a static resource from the Qlik Sense server, consuming the ticket, which starts the session and establishes the cookie.
  • Once the session is started, using the Capability API, we open the Qlik Sense app, retrieve objects and embed them into our website's HTML.

The thing is we didn't want to manage user rights on Qlik, because we already had all permissions set in our website. We wanted Qlik to be as detached from the actual permissions and security rules as possible.

With this in mind, we designed a very simple system: one dummy user per app and each user has access to that app and only to that app. One single access rule: userId = appId.

This way, with the QRS, we request a ticket for the dummy user, the human's browser consumes the ticket and immediately opens the app with the Capability API.

This approach looked very good because:

• A ticket can never be used to access more than one app.
• Qlik Sense is completely free of complex security rules, which were already implemented in our website's code.

However, we are experiencing some issues:

• If, on tab T1 of the browser, you open mashup M1, linked to app A1, everything works fine.
• If you then, on tab T2 of the browser, open mashup M2, linked to app A2, everything works fine.
• If you go back to tab T1 of the browser, all interaction (selections, retrieving visualizations, etc.) with app A1 works fine, but:
  • Images from app A1's content library that were not loaded before app A2 was open will not be loaded.
  • You can start data exports for app A1's visualisations, but you will not be able to download the resulting file.

This is because whenever we open a new mashup, linked to a new app (A2), we obtain a new ticket, linked to another Qlik Sense user (also called A2). So, even if the Capability API works fine because it relies on the unaffected WebSocket connection, any kind of HTTP request sent to the server will be linked to user A2. So, all resources of app A1 will be forbidden.

Our question is: What would be the best strategy to follow in our case to solve this issue?

We thought of creating one virtual proxy per app (~300 apps), but we don't know how that would affect performance. Also, even though we could create the per-app virtual proxy on the fly, that would invalidate ALL sessions linked to the central proxy, which we don't want. All users would be immediately logged out.

We really would like to keep the security handled by our website and Qlik believing blindly what the website says.

Permissions are set dynamically through a web interface on our website and they can change often. They are based on usernames, departments, email addresses, users belonging to groups defined on our website and some other details that are not necessarily stored in Qlik Sense.

What we need to achieve is something like each mashup having its own Qlik Sense HTTP session (cookie) so they don't overwrite each other's sessions. When you export data from app A1, you retrieve it with a Cookie linked to user A1. When you export data from app A2, you retrieve it with a Cookie linked to user A2.

If anyone has had a similar problem in the past with non-public mashups that require authentication and authorization handled by external systems, I would love to hear how they managed to implement the security on Qlik Sense.

Thanks a lot for your ideas!

I created a visual with the columns transport zone and departure day.
These two columns both come from a different table but are linked by a field that exists in both tables.

I have a third table where each transport zone has the departure time. It may be that a transport zone has multiple departure days and therefore the transport zone must be matched with the departure day to get the correct departure time from the third table.

Does anyone have an idea how I can set this up in Qlik?

Thanks in advance for thinking with me.

Installing Postgres on WEM Server using the provided postgresqlkit

When it gets to Stack Builder 4.2.1 I am getting a warning and then error

"Couldn't access the URL 'https://www.postgresql.org/applications-v2.html"

Any ideas ?

Thanks

An

I am receiving "The document [file name] failed to load" error.

I have already tried opening with nodata and ApplicationRescue and ScriptRescue from the help>about Qlikview>settings menu and still didn't work.

I'm using Version 12.70 and I created the original document and it has been used by only me. I'm also not using Personal Edition.

Are there any other suggestions to recover this document or is it totally beyond fixing now? I can't find anything anywhere apart from the above suggestions.

I am looking to create a measure that is filtered only by the *available* values for a specific field.

So if I had classes 1,2 & 3  and a user filters on [country] & [product] , which as a byproduct only left classes 1 & 3 remaining,

Then I need to do a MAX on the entire data set for classes 1 & 3.

(there are lots more fields in the actual  app, and many more values for [class] !)

Current attempt was as below, but maybe I have misinterpreted the 'P' function ?

Max({1<[class_name]=P([class_name])>} [duration])

The QV server became unusually heavy and I checked the task manager and found that the memory was close to 100% under the name QlikView.
Then I restarted QlikViewServer on Services.
But, the memory is still running at over 80%.
When I looked at the properties of QlikView in Task Manager, I found "QVD".
　→At this point, the QlikView Management Console(QMC) is not being used to update reports.
　→The report is not even opened in the QV app on the desktop.
Please tell me why "QVD" is using so much memory when no updates are being made in the QMC task scheduler.
Which folder (hierarchy) and which file should I check for logs?