Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,311 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.


Challenge the status quo

See why Qlik (Attunity) is recognized in the 2019 Gartner Magic Quadrant for Data Integration Tools.

Recent Discussions

  • New to Qlik Sense

    I can't create or view apps with any user

    The problem is the following, we create a server for the Qlik Sense in which the users with AD were registered and configured, at the time of creating... Show More

    The problem is the following, we create a server for the Qlik Sense in which the users with AD were registered and configured, at the time of creating or viewing an app with both a local user of the server and an AD user it does not leave access by returning the message that you do not have access permission, I tell you what was tested

     

    Create a local and AD user and assign a professional license.

    Those same users were assigned RootAdmin permissions.

    And the rule that allows creating and modifying it is reviewed.

    In addition to that, the directories were given permission to both the user group that uses Qlik and the users individually.

     

    Show Less
  • New to QlikView

    Line Chart

    HelloI want to create a line chart with the data I have like- 'Date column' which is having dates from May to Sep(Format :5/11/2017-9/31/2017) and oth... Show More

    Hello

    I want to create a line chart with the data I have like- 'Date column' which is having dates from May to Sep(Format :5/11/2017-9/31/2017) and other column I have is 'Overdue' which contains numbers  like-  1,2,3,4,5 with repetition. 

    So I want to calculate -how many are 5's in 'Over due' for particular month( Suppose May) /how many are overall numbers(1,2,3,4,5) like wise each month I need to calculate and create line chart. I took dimension as date column and in Expression how to write to achieve the above scenario. Please help me out as soon as possible. Thanks!

    Show Less
  • New to Qlik Sense

    search field not contain specific text

    ‌I could search from a table field which contains certain text using * . Is there a way to search from table which does not contain certain text?THank... Show More

    ‌I could search from a table field which contains certain text using * . Is there a way to search from table which does not contain certain text?

    THanks

    Show Less
  • Qlik Sense Deployment & Management

    Deallocate Qlik Sense Token automatically

    Due to all the privacy regulations and policy of the company, i need to deallocate the licence and delete the user, when someone leaves the company. I... Show More

    Due to all the privacy regulations and policy of the company, i need to deallocate the licence and delete the user, when someone leaves the company. I don't want to do this manually cause of the amount of users.

    The user itself i can delete with an API instead of manually in QMC --> Manage Content --> Users. I didn't test this yet, but i'm sure there is an API call for this.

    But what about tokens? I couldn't find an API call to do this. Is there even one available? Or is there any other way?

    Thanks for helping out.

    Btw. .. i'm not looking for a way to by-pass the 7 days limit. Deallocating the token after 7 days is just fine.

    Show Less
  • New to QlikView

    Qlikview Certification

    Hi Team, i would like to complete the Qlikview Certification can i get any  sample questions and  link for them. please help me.&n... Show More

    Hi Team,

     

    i would like to complete the Qlikview Certification can i get any  sample questions and  link for them.

     

    please help me.

     

    Thanks In advance.

    Thanks,

    Hima Bindu Chadalawada

    Show Less
  • Qlik Sense App Development

    Calculated Dimension to filter for Value displayed instead of AGGR Dimension.

    Hello,I have a calculated dimension that categorizes customers into groups. The groups are formed by comparing sales $ from this current period to las... Show More

    Hello,

    I have a calculated dimension that categorizes customers into groups. The groups are formed by comparing sales $ from this current period to last year's period. I have the dimension working fine. But when filtered, it filters for the customers in that specific group. I have learned the cause is because the customers is what I AGGR on. Is there any way for the filter to only select the outcome of the calculated dimension? I have tried loading an inline table and having the formula pull from that instead, but I cannot get it to work. below is my working dimension:

    =(aggr(
    IF(round((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2019'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2019'}>}
    (or_shipquant*or_price))))
    = '0' AND
    round((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2018'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2018'}>}
    (or_shipquant*or_price))))
    = '0',null(),

    IF(round((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2019'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2019'}>}
    (or_shipquant*or_price))))
    =
    round((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2018'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2018'}>}
    (or_shipquant*or_price)))),'OK',

    if((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2019'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2019'}>}
    (or_shipquant*or_price)))
    = '0', 'Gap',

    if((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2018'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2018'}>}
    (or_shipquant*or_price)))
    = '0', 'Gain',

    if((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2019'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2019'}>}
    (or_shipquant*or_price)))
    <
    (Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2018'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2018'}>}
    (or_shipquant*or_price))) , 'Decrease',

    if((Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2019'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2019'}>}
    (or_shipquant*or_price)))
    >
    (Sum({$<OrdStatus = {'Open'},[Fiscal Year] = {'2018'}>}
    (or_ordquant*or_price))
    +
    Sum({$<OrdStatus = {'Invoiced','Shipped Non Invoiced'},[Fiscal Year] = {'2018'}>}
    (or_shipquant*or_price))),
    'Increase','OK')))))),bi_name))

     

     

    Thanks




    Show Less
  • Qlik Sense Deployment & Management

    Create new Qlik Sense Users by consuming API endpoint

    Hi thereI was wondering whether it is possible to populate Qlik Sense Users by reading a REST API endpoint? We have an application in which we have us... Show More

    Hi there

    I was wondering whether it is possible to populate Qlik Sense Users by reading a REST API endpoint? We have an application in which we have users, but we would like to give some of the users access to Qlik Sense. We can expose the user details (ID, Name and Attributes) using a REST API endpoint, but I am not sure if we will be able to create those users in Qlik Sense? The plan is to use the application together with a certificate to get tickets for these users, but I assume that we need to have the users available in Qlik Sense first (we want to use certain rules based on attributes).

    The alternative we are considering is to have a Qlik Sense App consume that REST API and then writing the details to an Excel file which is the source of a Qlik Sense UD connector, but we would like to cut out the QS app and Excel file if possible (seems like we are creating unnecessary steps in the process).

    Please let me know if anyone has done something like this or if you have any suggestions.

    Regards,

    Mauritz

    Update: My Excel plan won't work as I cannot write/store data into an Excel file. Now I REALLY need suggestions 😉

    @LeviTurner @Gysbert_Wassenaar @rwunderlich 

    Show Less
  • New to Qlik Sense

    Question about comparison operators

    Can someone please tell me when to use -= for "not equal to" and when to use <> instead?  I keep getting this mixed up. Is there a cheat sh... Show More

    Can someone please tell me when to use -= for "not equal to" and when to use <> instead?  I keep getting this mixed up. Is there a cheat sheet for these types of syntax snafus?

    Thanks!!

    Show Less
  • New to Qlik Sense

    Force showing all values on x-axis

    Hi,I have loaded two tables into qlik sense and linked these: one with a calendar that contains (among others) a column for the date and the year/mont... Show More

    Hi,

    I have loaded two tables into qlik sense and linked these: one with a calendar that contains (among others) a column for the date and the year/month combination, and one with orders, containing columns for 'shipping date', 'customer', 'product' and 'quantity'.

    Not every customer orders every product every month, and when I make a bar chart that groups sales by year/month on the x-axis, only the months in which there were sales are displayed (for example, if a certain customer only ordered a certain product in April and June of this year, and I filter down to this combination, it will remove all months except for these two from the x-axis, which does not look very good). I have tried switching on the 'show null values' option, but this does not work. I guess this is because in the source data these really aren't entries with null values, but rather no data exists at all.

    My question is: is there any way to force the chart to conistently show all months on the x-axis (or more ideally, only all months from the first to the last month in which there were sales), regardless of the customer and product I select, and regardless of whether any data exists for that month? In other words, all non existing data should simply show up as months with 0 sales.

    I have found some other threads on the forum asking for essentially the same thing (for example here), but unfortunately I have not been able to apply the solutions offered in these to my problem with any success.

    Thanks for the help!

    Show Less
  • Qlik Sense App Development

    Exporting Data in qliksense cloud to excel

    Hi everyone, I have a problem where I have to show "Filters used", timestamp of export" while exporting data from qliksense table to an excel.I m... Show More

    Hi everyone,

     

    I have a problem where I have to show "Filters used", timestamp of export" while exporting data from qliksense table to an excel.

    I mean exported excel should show what are filters applied before exporting and when was data exported.

    Please help

    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
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

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
Show help for this page