Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,745 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    Deployment & Management

    Migration Qlik Sense by restoring of VM snapshot

    I'm migrating our Qlik Sense to a new server for to a technology update.We created a server image and then restored it to a new server in the same dom... Show More

    I'm migrating our Qlik Sense to a new server for to a technology update.
    We created a server image and then restored it to a new server in the same domain.
    So, the services are up, but I can't use Qlik by qmc and hub.
    I'd like to know what best practices are for completing the migration and getting started using Qlik on the new machine.

    Show Less
  • forum

    Security & Governance

    Override Stream default Access Rule

    Hello Community I have 2 groups of user : Sales and Finance and I am trying to allow my users to have access to different sheets located in the same a... Show More

    Hello Community 

    I have 2 groups of user : Sales and Finance and I am trying to allow my users to have access to different sheets located in the same app called "Report" located in the stream "Invoices" so I followed every step of the following post : https://community.qlik.com/t5/Qlik-Sense-Documents/Sheet-or-App-Object-Level-Security-Qlik-Sense/ta-p/1485114

    I started by creating two custom properties : @ApplvlManagment and @StreamlvlManagment with the following values :  "Sales" and "Finance" for my two group.

    After assigning the custom properties to the stream, app and users I created a first rule on App.Object_* : user.@AppLevelManagment=resource.@AppLevelManagment and two other rules : one manage the app object access for the Finance group and the other manage the app object acces for the Sales Group.

    I had to disable the default stream rule but I couldn't see my apps without it so I cut only the second part of the rule: "or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read"))"

    Now it is working well I can see only certain sheets with the Finance group and other sheets with the Sales group located within the same app. My problem is that I have other streams and my users cannot access to the app object of those streams anymore. I know it is because I deleted the part that granted App.Object access in the stream default rule.

    Is there a meaning to override the stream default rule and write an other one to still have my users of the two group Finance and Sale separated within the app "Report" while allowing them to keep seeing the AppObject contained in other apps within other streams ? 

    Show Less
  • forum

    New to Qlik Sense

    Count if and set analysis

    Hi, what’s the best way to do the following.Count all employeesIf(count({<field = {yes}, field2 = {no}>}counter) = 1,1,0)I need to do aggr counting al... Show More

    Hi,

     

    what’s the best way to do the following.

    Count all employees

    If(count({<field = {yes}, field2 = {no}>}counter) = 1,1,0)

    I need to do aggr counting all the employees where there’s a 1 in the IF statement.

     

    the expression is to go into a table with 1 row of data, I don’t want to add the employees field, hence I think I’ll need a aggr.

     

    thanks

     

    Show Less
  • forum

    New to Qlik Sense

    Time Series plotting for data has separated day and hour columns

    My data has separated Day and hour(=Zulu), and I need to draw a time series plot with the order of Zulu/Day/Month/Year.Such an order of 0/01/01/2020  ... Show More

    My data has separated Day and hour(=Zulu), and I need to draw a time series plot with the order of Zulu/Day/Month/Year.

    Such an order of 0/01/01/2020  ->  1/01/01/2020  ->2/01/01/2020    and so on..

    How can I adjust them at the load editor?  or can I combine and adjust them directly and  a plot chart?

    YearMonthDayZuluValue
    20201102
    20201113
    20201125
    20201134
    202011411
    202011543
    20201163
    202011735
    20201184
    202011967
    202011102
    202011113
    202011125
    202011134
    2020111411
    2020111543
    202011163
    2020111735
    202011184
    2020111967
    202011203
    2020112135
    202011224
    2020112367
    20201202
    20201213
    20201225
    20201234
    202012411
    20201253
    202012635
    Show Less
  • forum

    Qlik Compose for Data Warehouses

    SYS,GENERAL_EXCEPTION,Input string was not in a correct format during MARTS Vali...

    In our Environment we have a master project and several other projects where developers make changes. For one of these projects I imported the Entity ... Show More

    In our Environment we have a master project and several other projects where developers make changes. For one of these projects I imported the Entity and Mapping changes from the UI. Validate worked for the DW and DM. 

    Next I exported the project CSVs and merged the DM changes from the Developer's project into the Master. There were changes to around 5 Facts and 6 Dimensions.  The import completed successfully using the CLI.

    Upon running validate Compose throws the following error in Master. 

    ubanerjee_0-1632332686625.png

    How should we go about debugging this issue? In the past I have tried to restore a backup and tried to bring one Dimension or fact at a time. Is that the ideal way or is there a way to query the sqllite db or json file to identify the root cause of this issue? 

     

    Show Less
  • forum

    App Development

    Sum Distinct Values in Table Total

    Hello,I have a question that i cant seem to solve.I have the following table:Region CoverageSales EmployeeTargetsEastuser11,350,000Eastuser21,350,000E... Show More

    Hello,

    I have a question that i cant seem to solve.

    I have the following table:

    Region CoverageSales EmployeeTargets
    Eastuser11,350,000
    Eastuser21,350,000
    Eastuser31,350,000
    Eastuser41,350,000
    Total 5,400,000

     

    Since, the region is the same and the targets are the same, can we have the total to be 1,350,000 since all targets in the regions are the same?

    Thank you in advance.

    Waleed

    Show Less
  • forum

    New to Qlik Sense

    Merging Split Field and Removing Value

    I had split out a column in the data manager to 3 total new columns. In a bard chart I am looking to merge the values which I accomplished with the be... Show More

    I had split out a column in the data manager to 3 total new columns. In a bard chart I am looking to merge the values which I accomplished with the below formula:

    =pick(match($Field,'Competitor Name-1','Competitor Name-2','Competitor Name-3'),[Competitor Name-1],[Competitor Name-2],[Competitor Name-3])

     

    BUT now I am wanting to remove a specific value from the Competitor list (for each dimension). How can this be accomplished?

    Show Less
  • forum

    App Development

    Section access removes Always one selected value

    Dear friendsI have marked the Currency field in a Sales-app with "Always one selected value". But it gets unmarked when I reload the app with Section ... Show More

    Dear friends

    I have marked the Currency field in a Sales-app with "Always one selected value". But it gets unmarked when I reload the app with Section Access. Any idea how to solve this issue?

    We are on release Qlik Sense Aug 2021 SR1

    Thanx Johan

    Show Less
  • forum

    Alerting

    Customize system Alert Email

    HI,Just wondering if it is possible to customize the email body that is generated from the system alerts?Thanks
  • forum

    New to Qlik Sense

    multiple ORs in an expression

    Hello. I'm having an issue with my expression. I'm trying to count any time that the status changes and the status type is either one of these status ... Show More

    Hello. I'm having an issue with my expression. I'm trying to count any time that the status changes and the status type is either one of these status types. I don't know what I'm doing wrong here, says I'm missing a ) somewhere? Thanks for the help.

     

    COUNT(DISTINCT if(StatusChanges > 0 AND (SP_StatusType = 'ONSITE' , OR SP_StatusType = 'TRIAGE', OR SP_StatusType = 'REPAIR IN PROGRESS', OR SP_StatusType ='LEAVING SITE',
    OR SP_StatusType = 'PRODUCT SHIPPED'),SP_RFACallNumber))

    /

    Count(DISTINCT SP_RFACallNumber)

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region