Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,460 online
Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY

Welcome to Qlik Community

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

QlikWorld 2022

This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics.

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.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

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.

Qlik Academic Program

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    App Development

    How to identify last 3 values in qliksense pivot table and color it

    Hello, I am using total 4 fields. One field is for Pivot Dimension and 2 Fields as Columns and 1 field as Measure ( Sum(Sales)). If I expand one of th... Show More

    Hello,

    I am using total 4 fields. One field is for Pivot Dimension and 2 Fields as Columns and 1 field as Measure ( Sum(Sales)).

    If I expand one of the column, I will get 7 values as sum(sales) . Is there any way to identify last 3 values and  assign color for last 3 values. Can Someone please advise.

    -Karthick.

     

     

    Show Less
  • forum
  • forum

    Deployment & Management

    Qlik Cloud/Enterprise Saas - Changing O365 Tenant for IdP.

    Hi,   Our business is moving to a new O365 tenant in the coming months  (aligning all child companies under a single parent company) and we are curren... Show More

    Hi,

     

    Our business is moving to a new O365 tenant in the coming months  (aligning all child companies under a single parent company) and we are currently authentication users using Azure AD on our current tenant (specific to our company).

     

    What implications / setup requirements will be needed by us to be able to authenticate users on our new tenant when this becomes available?  Also how does it work with existing users, Tenant Admin, Ownerships etc.

     

    We are due to have a test build of our new tenant next week, are we able to have multiple IdP's  active at one time?

     

    I'm not and IT person by any means so if this is going to be a problem then we need to know sooner rather than later so we can engage external support.

     

    Thanks

    Show Less
  • forum

    QlikView Administration

    Windows 11 QlikView support

    I heard that Windows 11 is not officially supported by QlickView. Is it true? So if there is a problem while using Windows 11, can't I get support?
  • forum

    App Development

    Challenge. How can I read data from an stored copy of an SQL?

    Hi guys, I have some data in a copy of a sql database that I'd like to read directly from Qlik Sense. Is it possible? I know that I can import the SQL... Show More

    Hi guys,

    I have some data in a copy of a sql database that I'd like to read directly from Qlik Sense. Is it possible?

    I know that I can import the SQL data in a SQL environment and then read it with Qlik Sense, but the point is that I want to avoid this step.

    For this purpose I've attached a SQL Server sample database of bikes, in case any of you know how to do it, could show the community how is made the loading script :grinning_face_with_smiling_eyes:

    Kind regards, Marcel.

     

    Show Less
  • forum

    New to Qlik Sense

    How to show only last 5 days of data in Qlik Sense Pivot Table

    Hi, I have a pivot table that looks like the one below in Qlik Sense. 'Where first seen' and 'Date' are dimensions. The 'T/S', 'T/C', 'C', 'D/C' and ... Show More

    Hi, I have a pivot table that looks like the one below in Qlik Sense.

    mnev0003_1-1643320378948.png

    'Where first seen' and 'Date' are dimensions. The 'T/S', 'T/C', 'C', 'D/C' and 'D/S' are measured values that use the count function. I would like to show only the last 5 days of data in the table without the user having to touch anything.

    Only loading 5 days of data in the script isn't an option as we have multiple pivot tables showing different lengths of time on the same sheet (eg. 5 days of data, 10 days of data, 30 days of data). 

    Can anyone please help with this ? Thanks a lot! 

     

     

    Show Less
  • forum

    New to Qlik Sense

    qliksense

    Hi,   Is it possible to hide the sheets in app in qliksense. scenario: I have 6 sheets under app , in every sheet i created the six buttons on the top... Show More

    Hi,

     

    Is it possible to hide the sheets in app in qliksense.

    scenario: I have 6 sheets under app , in every sheet i created the six buttons on the top for navigation.so now i can see the 6 sheets in the app . is it possible to hide the sheets by keeping only one sheet in the app. 

    if we place only one sheet under app so  by clicking on the main sheet , a user can go through all sheets with the buttons inside sheet. my problem is that i want to hide remaining sheets , i want to see only one sheet under the app is that possible in qliksense.

    Show Less
  • forum

    App Development

    QlikView Expression to get Category of a Patient with Max Discharge Date at Pati...

    Hi, I have been struggling to make this expression work. I am trying to get Prior YTD count of distinct PatientIDs for each of these 3 categories by o... Show More

    Hi,

    I have been struggling to make this expression work. I am trying to get Prior YTD count of distinct PatientIDs for each of these 3 categories by only picking the category of Patient with Max Discharge DT.

    Dummy DataSet:

    PatientID     Category    DischargeDT

    Tom                 AZ                   1/31/2021

    Jerry               BZ                   1/21/2021

    Jerry               CZ                    2/8/2021

    Expected Object result:

    1. Count(distinct Patient ID) where Category AZ = 1

    2. Count(distinct Patient ID) where Category BZ = 0

    3. Count(distinct Patient ID) where Category CZ = 1

    The expression im using currently  for one of the category is 

    count({$<DischargeDT = {"=$(=Date(max(DischargeDT), 'YYYY-MM-DD'))"} , Category={"BZ"},

    PeriodType={"YTD"},AsOfPeriod={"202102"}>}distinct PatientID)

    which Im expecting to give me an output of 0 instead it gives me 1 for all these categories. I dont care about BZ, I only want to count the category of Patient with most recent Discharge DT.

     

    Please let me know what Im doing wrong in the expression.

     

    Thanks

    Show Less
  • forum

    QlikView Administration

    How to do ajax mode in qlikview edge

    I am trying to use qlikview as an edge without using IE mode. How to use Ajax (Full Browser Client)? Please answer
  • forum

    QlikView Administration

    Using QlickView Edge.

    I use qlikview, and I am trying to use the windows 11 version of Edge without using IE mode.Is it possible?Please answer.

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