Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,018 online

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

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

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion board and documents related to Qlik Associative Big Data Index.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.


Introducing Qlik Gallery

Announcing the newest addition to the Qlik Community, Qlik Gallery!

Qlik Gallery is all about sharing – apps, outcomes, and ideas. This is your space to learn from each other as Qlik users, fans, thought leaders and data enthusiasts

Recent Discussions

  • New to Qlik Sense

    Set Expression with P for prior year

    Im trying to get a sum of sales for all account IDs that has mains for a prior yearSum({<Year={$(=(v.Date.Year.Max)-1)},[AccountID] = P({<[Product Cat... Show More

    Im trying to get a sum of sales for all account IDs that has mains for a prior year

    Sum({<
    Year={$(=(v.Date.Year.Max)-1)},
    [AccountID] = P({<[Product Category]={[Mains]}>})
    >}Sales)

    If i exclude the Year section it gives me the values for this year however once i add the year -1 it throws me out Zeros. Any help will be greatly apprectiated

    Show Less
  • Qlik Sense Deployment & Management

    LDAP problem with qlik sense server

    Hello ,I have a problem with my connector of LDAP cannot retrieve users even if the sync work and the task is succesfull in the log I see :Children no... Show More

    Hello ,

    I have a problem with my connector of LDAP cannot retrieve users 

    even if the sync work and the task is succesfull 

    in the log I see :

    Children not reachable  for ldap  and database done with 0 users and 0 groups even if with ldap admin when I write the same path I have my users 

    my path is LDAP ://myIP/dc=X,dc,Z,dc,Y

    I tried also with 

    LDAP ://myIP/ou=users,dc=X,dc,Z,dc,Y

    and with additionnal filters like 

    (&(objectCategory=person)(objectClass=user)
    (cn=*)) 

     

    but it doesn't work  my version of qlik sense is june 2019 sr3 and my OS is windows server 2012 

     

    thank you for your help 

     

     

    Show Less
  • New to QlikView

    How to get correct dimension on this

    I have my sample data which is this: What I want to get is the most sold product for each week.What I did on Qlik was to add week, category and this f... Show More

    I have my sample data which is this: 

    clipboard_image_1.png


    What I want to get is the most sold product for each week.

    What I did on Qlik was to add week, category and this formula -> 'max(aggr(sum(num_orders), week, category))'

    To get the most sold product, but the category dimension makes all the categories appear.

    What should I do to filter it and make it so only the most sold category appears?

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Qlik Sense - Default App Bookmark in Mashup

    Hi everyone, I have created a bookmark in my app and set this  as the app default, so that it is applied when opening the app.  This works fine on the... Show More

    Hi everyone,

     

    I have created a bookmark in my app and set this  as the app default, so that it is applied when opening the app.  This works fine on the Qlik Sense server, but it is not applied when migrating the app to my QAP server and using it in a mashup, even though I can see that the bookmark has been migrated (by looking in the single configurator in the dev hub).  Could someone from Qlik please confirm this?

    In the meantime, I have used the applyBookmark method.

    Thanks in advance.

    Richard

     

    Show Less
  • New to Qlik Sense

    Greater then average sales by client and town

    HelloI have to calculate avg sales per client in every town, in every month.  Then for every town mark clients with higher sales than average. I have ... Show More

    Hello

    I have to calculate avg sales per client in every town, in every month.  Then for every town mark clients with higher sales than average. I have little experience with "IF" and  I don't now how to make link client sales with town average.
    I tried this:
    IF((sum(Sales))>(Aggr((Sum([Sales])),[Town],[date.autoCalendar.YearMonth])/Count ( distinct [Client])),1,0)

    Show Less
  • New to Qlik Sense

    Dynamic Map Colours

    Hi AllI am currently evaluating Qliksense, and like the clean appearance.I have a map which shows my distribution centers to customers, and set the co... Show More

    Hi All

    I am currently evaluating Qliksense, and like the clean appearance.

    I have a map which shows my distribution centers to customers, and set the color by expression so it highlights customers who have not orders, in the same map I also have set the color by Dimension so each center is a different color. What I would like to do is give the user the ability to switch between color by expression to color by Dimension and back again as required. Is this possible?

    Thanks for your help

    Chris

     

    Show Less
  • Qlik NPrinting Discussions

    How to delete reports from NewsStand?

    We have been testing reports and report distributions, and as a result, have many test reports that are listed in the NewsStand. We would like to remo... Show More

    We have been testing reports and report distributions, and as a result, have many test reports that are listed in the NewsStand. We would like to remove the test reports. I don't see any options for maintaining the NewsStand. Is there a way this can be done from the backend? I am using NPrinting 17.4.

    Show Less
  • New to Qlik Sense

    Monitoring Apps Fail at Call QRS data AFTER LogContent table is stored

    Hello everyone,I have just installed a fresh copy of September 2019 Qlik Sense on a brand new dev server and noticed that both License Monitor and Ope... Show More

    Hello everyone,

    I have just installed a fresh copy of September 2019 Qlik Sense on a brand new dev server and noticed that both License Monitor and Operations Monitor apps are failing to reload at the same place. Here's a snippet of the script from log files where tasks fail:

    License Monitor

    CALL QRS // Call QRS data AFTER LogContent table is stored
    LET NumRowsQRS = 0
    SET QRS_RowCounts = 'QRS Row Counts: '
    For each endpoint in 'monitor_apps_REST_license_user','monitor_apps_REST_license_login','monitor_apps_REST_user','monitor_apps_REST_license_access','monitor_apps_REST_app','monitor_apps_REST_license'
    CALL monitor_apps_REST_license_user
    Set NumRows_monitor_apps_REST_license_user = 0
    License_User_Access_Types:
    NoConcatenate Load * Inline [UserId]
    1 fields found: UserId,
    0 lines fetched
    For Each tipo in 'User','Professional','Analyzer'
    LET f_unused = '[Unused UserId' & if(tipo='user',']',' User]')
    LET f_quarantine = '[Quarantined UserId' & if(tipo='user',']',' User]')
    LET tipo_lower = lower(tipo)
    LIB CONNECT TO 'monitor_apps_REST_license_user'
    Error: Connection aborted (System error: The handle is invalid.)
    Execution Failed
    Execution finished.

    Operations Monitor

    CALL QRS // Call QRS data AFTER LogContent table is stored
    TRACE Fetching data from Qlik Sense Repository (QRS) database
    Fetching data from Qlik Sense Repository (QRS) database

    LET NumRowsQRS = 0
    SET QRS_RowCounts = 'QRS Row Counts: '
    For each endpoint in 'monitor_apps_REST_user','monitor_apps_REST_app','monitor_apps_REST_appobject','monitor_apps_REST_task'
    CALL monitor_apps_REST_user
    LIB CONNECT TO 'monitor_apps_REST_user_condensed'
    Error: Connection aborted (System error: The handle is invalid.)
    Execution Failed
    Execution finished.

    It seems like the there's something wrong with whatever QRS is. Some additional information about environment that I'm running Qlik Sense in:

    • Single node environment
    • Server is offline
      • As in, not allowed to be connected to internet

    Has anyone faced this and found a solution? Any idea what I can try to get these apps up and running?

    Mikhail B.

    Show Less
  • QlikView App Development

    Associations betwenne three qvd

    Hi to all.I'm new of this forum and I have a question for you.I have three qvd: one for the Contracts (with inside fields like "Business", "ContractCo... Show More

    Hi to all.

    I'm new of this forum and I have a question for you.

    I have three qvd: one for the Contracts (with inside fields like "Business", "ContractCode", "Name", "Address", "Value", "ProductCode", etc), one for the Product (with inside fields like "Business", "ProductCode" and "ProductSales") and at the end one for Cover (with inside fields like "Business", "ContractCode" and "ProductCode").

    I done this associations: Contracts with Cover throught "Business" and "ContractCode" and then the association betwenne Cover with Product throught "Business" and "ProductCode" to take "ProductSales").

    I built some reports and is all right. But if I want  to know the value for ProductSales I have all ProductSales with the same value. I think that I wrong the associations.

    Is there someone that give me a advise?

    Thanks for all.

    ciao

    ale

    Show Less
  • QlikView App Development

    Pick WildMatch default value

    I've got a Currency field that has values like, USD, EURO and UK.I want to translate UK and EURO to GBP and EUR respectively.I can do this quite easil... Show More

    I've got a Currency field that has values like, USD, EURO and UK.

    I want to translate UK and EURO to GBP and EUR respectively.

    I can do this quite easily in an If formula because there are just two values that need translating, the rest should stay the same. i.e.

    If([Currency]='EURO','EUR',If([Currency]='UK','GBP',[Currency])

    However in the future there may be currencies that need translating and the nested If statement could get quite large. I'm wondering if it's easy to set a default value using Pick and WildMatch (or Match). The following would translate UK and EURO for me but I would lose USD etc. 

    Pick(WildMatch([Currency],'UK','EURO'),'GBP','EURO')

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

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

750+ Members

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar