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:
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:
However, we are experiencing some issues:
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])
Hi,
I have a table with several records, every record has a field 'Season' that can contain values like: 'W20', 'W21', 'W22', 'W23', 'S20', 'S22', 'S23', 'S24'...
where 'W' stays for 'Winter' and 'S' stays for 'Summer'.
I'd like to create a summary table like this:
Group, Season1, Season2, Season3, Season4
Summer, S24, S23, S22, S20
Winter, W23, W22, W21, W20
Thank you.
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?
Qlik Staige, an all-encompassing solution that provides the technology, ecosystem, and expertise you need to bring better insights to your business, faster.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on Sept. 27th at 10 AM ET for the next Do More with Qlik session, where we will be featuring Insight Advisor – our intelligent AI-assistant in Qlik Sense.
Real-time Responses Delight Burgan Bank's Customers.
Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!