Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 173,951 members
  • 2,146 online
  • 1,794,050 posts
  • 137,219 Solutions
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Find top 10 unique issues by type by using aggregate function in Qliksense

    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 sh... Show More

    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

     

    Show Less
  • forum

    Alerting

    Using set analysis to get a value of previous period

    Hi. I have a dataset with the fields: Account_id, account_score, year_quarter, YearQuarterKey (which is a running sequencial number for every year-qua... Show More

    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

    Show Less
  • forum

    New to Qlik Sense

    Set analysis to compare data at two differents date

    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], [av... Show More

    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 ? 

     

    Show Less
  • forum

    Integration, Extension & APIs

    How to keep different Qlik Sense HTTP sessions (cookies) on the same Qlik Sense ...

    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... Show More

    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!

    Show Less
  • forum

    App Development

    VLOOKUP with terms in Qlik

    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 tha... Show More

    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.

    Show Less
  • forum

    Qlik Enterprise Manager

    Analytics Postgres Instal

    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 ... Show More

    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

    AnERROR Postgres Install cert warning.PNGERROR Postgres INstall revokation error.PNG

     

     

    Show Less
  • forum

    QlikView App Dev

    Qlikview file failed to open WITH nodata option

    I am receiving "The document [file name] failed to load" error. I have already tried opening with nodata and ApplicationRescue and ScriptRescue from t... Show More

    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.

     

    Show Less
  • forum

    New to Qlik Sense

    Measure filtered by all available values for a field

    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... Show More

    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])

     

     

    Show Less
  • forum

    App Development

    Similar to crossover table

    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', 'S... Show More

    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.

    Show Less
  • forum

    QlikView Connectivity

    Regarding the update of "QVD"

    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 restart... Show More

    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?

    Show Less
Leaderboard

Customer Story

New Data Integration Customer Story + Video

Real-time Responses Delight Burgan Bank's Customers.

Customer Story

Talking Analytics to the Frontier

Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!