Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 232,982 members
  • 5,909 online
  • 2,016,079 posts
  • 151,374 Solutions
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    Integration, Extension & APIs

    Apply qlik license with powershell

    Hi GuysI'm part of a team that is in charge of rolling out servers with a suite of software including Qlik sense. We need an automated method of insta... Show More

    Hi Guys

    I'm part of a team that is in charge of rolling out servers with a suite of software including Qlik sense.

    We need an automated method of installing and configuring Qlik sense.

    Currently we can install Qlik but I'm not sure how to apply the license I have, ideally I would be able to run a PowerShell script and apply the Owner name, Owner Organisation, serial number/ license key and control number without opening a web browser.

     

    Cheers

    DL

     

    Show Less
  • forum

    Qlik Replicate

    SAP's 'Statement of Direction – SAP Data Services'

    In July 2024, SAP published a technology blog entitled Statement of Direction—SAP Data Services, in which it announced its 'plans to stop or reduce th... Show More

    In July 2024, SAP published a technology blog entitled Statement of Direction—SAP Data Services, in which it announced its 'plans to stop or reduce the scope of few functionalities', including 'Attunity aka Qlik Data Integration Platform.'

    This statement refers to earlier, now defunct, integrations with Business Objects. Attunity built these integrations 10-15 years ago for Business Objects before the SAP acquisition. The integrations date back to Qlik's pre-acquisition of Attunity.

    As these benign integrations are no longer in use, this change does not impact any of our customers, and there is no cause for concern.

    SAP has published this statement of direction after reviewing the Business Objects suite and applying "end of life" to several of its products, including ending the support of an unused integration between Attunity and Business Objects Data Services.

    Show Less
  • forum

    App Development

    Section Access in Manager to Resource Hierarchy

    Hi, I've the below sample data:  ManagerID ManagerName ResourceID ResourceName ResourceStatus ResourceRole ResourceType 123456789 Mgr-1 612058116... Show More

    Hi,

    I've the below sample data: 

    ManagerID ManagerName ResourceID ResourceName ResourceStatus ResourceRole ResourceType
    123456789 Mgr-1 612058116 Test-1 Allocated Solution Manager Sub-Con
    123456789 Mgr-1 612058117 Test-2 Allocated Solution Manager BT FTE
    123456788 Mgr-2 612058118 Test-3 Allocated Solution Manager External Consultant
    123456789 Mgr-2 612058119 Test-4 Allocated Solution Manager Sub-Con
    123456790 Mgr-3 612058120 Test-5 Allocated Solution Manager BT FTE
    123456790 Mgr-3     Vacancy Solution Manager  

     

    And let's say that I have created a master dimension (Drill-Down) using ManagerID and ResourceID. 

    Now I create this table on the dashboard with just Manager details and because of drill-down dimension, it will show the relevant resource details once I click on any particular ManagerID. 

    ManagerID ManagerName
    123456789 Mgr-1
    123456789 Mgr-1
    123456788 Mgr-2
    123456789 Mgr-2
    123456790 Mgr-3
    123456790 Mgr-3

     

    All ok till here. But I also have one requirement where I need to restrict other managers to see other resources details. For e.g., Mgr-1 should only see Test-1 and Test-2 data. How do I achieve this?

    Thanks a lot, in advanced!!

     

    Show Less
  • forum

    New to Qlik Analytics

    pcking selected values from a table

    I have table with salary details, new record is maintained for all salary/grade changes. I need to pick only the records where the grade has changed. ... Show More

    I have table with salary details, new record is maintained for all salary/grade changes. I need to pick only the records where the grade has changed.

    Its SAP HCM infotype PA0008

    Show Less
  • forum

    New to Qlik Analytics

    Sum data and group by variables

      I want to show sum(Amount) group by BGID and InsOfficeNodeID. and End user should select BranchName and BGName from a list. The problem is when Bra... Show More

    D44C3E46-12F1-4166-A3B8-C2BCD081ED63.png


    I want to show sum(Amount) group by BGID and InsOfficeNodeID. and End user should select BranchName and BGName from a list. The problem is when BranchName is selected(for example ‘A’), the result is shown should be like this:
    Sum(Amount) where : BranchName=’A’ and InsOfficeNodeID= ParentID
    I don’t know how to do

    Show Less
  • forum

    Qlik Replicate

    Renaming the data folder?

    Hi, A customer had issues with the UI server service not running after doing an upgrade. I noticed that their data folder was named 'Attunity'. Could ... Show More

    Hi,

    A customer had issues with the UI server service not running after doing an upgrade. I noticed that their data folder was named 'Attunity'. Could this be an issue related to why the services are having issues with starting?

    Regards,

    Mohammed

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    Need Policy number wise aggr sales in qlik sense

    Hi Team, I have couple fields in the dashboard in this I need policy number wise sales needed  Example: Policy number ,Sales 1, 1110 2,1110 3,1110 4,1... Show More

    Hi Team,

    I have couple fields in the dashboard in this I need policy number wise sales needed 

    Example:

    Policy number ,Sales

    1, 1110

    2,1110

    3,1110

    4,1110

    5,1110

     

    While I am writing the expression in kpi object like Sum(Sales) getting unique sales only(1110).

    How will I getting the total sales i tried other methods as well Sum(total Sales) or aggr(sum(Sales), Policy Number) but no luck getting unique sum only, can anyone help me on this please

    Show Less
  • forum

    New to Qlik Analytics

    Repeat monthly values at day level

    Hi, please help me with my problem. I have a Target field in my dataset and it is separated monthly as screenshot below: here's the thing, I need to ... Show More

    Hi, please help me with my problem. I have a Target field in my dataset and it is separated monthly as screenshot below:

    poklegoguy_0-1728032228316.png

    here's the thing, I need to create a table where date (every day of a month) is one of my dimension and I will need the Target as one of my measures. I need the Target value to be repeated at every date row in the month as screenshot below:

    poklegoguy_1-1728032413083.png

    I have tried expression below:
    SUM({$<Month={"$(=Month(Day))"}>} Target

    Unfortunately, it doesn't work and I can't find any solution online. I'll appreciate any help! Thanks!

     

    Show Less
  • forum

    New to Qlik Analytics

    question about matrix

    Is it possible for Qlik to prepare 25000x25000 matrix multiplications? If it is not - how can we solve it in another way?
  • forum

    Administering and Monitoring

    Unable to access the TMC

    hello all , we are facing an issue while connecting to the tmc since yesterday norming. The error were are this codeError=error_getting_user . A ticke... Show More

    hello all , 
    we are facing an issue while connecting to the tmc since yesterday norming. The error were are this codeError=error_getting_user . A ticket was opened since yesterday but till now the issue remains unsolve.
    Why are we getting this error ? Is it because of some licences issues ?

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!