Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
895 online
Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW

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

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

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.

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.

Qlik Resources

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

Events

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    QlikView App Dev

    GeoQlik Flash Player 2021

    Hello Qlikers,Since Adobe Flash is no longer supported in 2021, and also GeoQlik requires Flash in the QlikView Access Point, Is there still a way to ... Show More

    Hello Qlikers,

    Since Adobe Flash is no longer supported in 2021, and also GeoQlik requires Flash in the QlikView Access Point, Is there still a way to display GeoQlik objects in the Qlikview Access Point? Does GeoAnalytics have the same problem?

    Thanks in advance!

    Show Less
  • forum

    New to Qlik Sense

    section access based on multiple columns

    Hi,I have data similar to below table and I'm trying to implement section access based on multiple columnsC1C2C3C4RegionCountryManager (userId)Departm... Show More

    Hi,

    I have data similar to below table and I'm trying to implement section access based on multiple columns

    C1C2C3C4RegionCountryManager (userId)Department
    D1D1D1D1EUCN1M1D1
    D2D2D2D2EUCN2M2D1
    D3D3D3D3EUCN3M1D2
    D4D4D4D4EUCN4M3D3
    D5D5D5D5AMCN5M1D2
    D6D6D6D6AMCN6M2D4
    D7D7D7D7AMCN7M4D4
    D8D8D8D8AMCN8M3D3
    D9D9D9D9AMCN9M8D5
    D10D10D10D10USCN10M5D1
    D11D11D11D11USCN11M6D1
    D12D12D12D12USCN12M7D6
    D13D13D13D13USCN13M8D3

     

    Ex:

    1. a person can have access to EU region and also CN13 country

    2. A person can have access to only US region data.

    3. A person who is a manager (ex:M6) then he/she should see only data where Manager=M6

    4. A person need to access only department  D6 and Region EU then all the items in region EU for D6 data should only be shown

    Basically I need to filter data on multiple columns or single column to restrict data. Can anyone help me how to achieve this? I was able to do it on only one column.

    Regards,

    Harish

     

    Show Less
  • forum

    New to Qlik Sense

    Script Function

    Hi Experts,I have the script mentioned below. Can anyone explain its working please, i am  little confused. if Len(Trim('$ (vStartDate)'))=0 thenLet v... Show More

    Hi Experts,

    I have the script mentioned below. Can anyone explain its working please, i am  little confused. 

    if Len(Trim('$ (vStartDate)'))=0 then
    Let vStartDate = Date(Today());
    EndIf

    if Len(Trim('$ (vEndDate)'))=0 then
    Let vEndDate = Date(Today()+1);
    EndIf

    Let vStartDate = Date('1/1/2021');

    Let vEndDate= Date('30/1/2021');

    Thanks in Advance 

    Help!

    Show Less
  • forum

    Community Corner

    Round of Applause - May 2021, Gysbert Wassenaar

    Happy May everyone! Believe it or not, this month is our 12th edition of Round of Applause! Even though it’s a cool name, we wanted an even cooler nam... Show More

    gysbert.pngHappy May everyone! Believe it or not, this month is our 12th edition of Round of Applause! Even though it’s a cool name, we wanted an even cooler name for our featured members so from here on in we are going with High Five! This Community member has over 20K posts, received more than 8k likes, answered over 4K questions, and is a well-known leader in the Qlik Community. Today’s High Five goes to no other than Community MVP, Gysbert Wassenaar.

    Gysbert joined the Qlik Community in September 2012. He had been visiting for a while, looking for answers to Qlik challenges he encountered in his job. He was already impressed by the quality of the answers he saw and by Community members who gave great solutions and advice. Gysbert was also impressed that Qlik employees participated actively. The day he decided to join the Community was when he saw a question from a community member and thought: "Hey, I think I know the answer to that." It was then he started participating, and he became hooked! Gysbert said he’s never learned so much so quickly about a product. Every question posted was another opportunity to expand his knowledge and Qlik skills.  Three months later, he was a Top 5 contributor. He recalls passing Stefan Wühl as top contributor about a year after he joined. The feedback from other community members, and especially from Qlik Community legends like Deepak Vadithala,  Stefan WühlJohn WitherspoonMiguel Angel BaeyensHenric Cronström,  Rob WunderlichMarcus Sommer and so many more, was awesome and a big motivating factor to keep coming back to the Qlik Community.

    In his personal life, Gysbert is very fortunate to be living in a small beautiful medieval city in the Netherlands. He likes reading, taking walks in the countryside, learning about new technologies, and learning new tricks he can apply in his job.

    Let’s give a big “High Five” to Gysbert with a like and a comment to show how much we appreciate his collaboration in the Qlik Community. @Gysbert_Wassenaar @Melissa_Potvin @marcus_sommer @rwunderlich @Henric_Cronström@Miguel_Angel_Baeyens @swuehl @johnw @IAMDV 

     

     

    Show Less
  • forum

    New to Qlik Sense

    calculate index on all years

    Hello EveryoneI have some experience in power BI , but I am new to Qlik. can I kindly ask if someone could help me out here, I am stucking with this q... Show More

    Hello Everyone

    I have some experience in power BI , but I am new to Qlik. can I kindly ask if someone could help me out here, I am stucking with this question for many days :(.

    I have a table on left with forecast and sales ,  how could I get an index (YOY) on all years( without filter the year), and pick the latest forecast version if there is not forecast_version is selected?

    I tried below to calculate the index , but it is not correct.

    (sum({<year={$(=max(year))},year_week={">=$(=max(forecast_version))"}>}forecast) +

    sum({<year={$(=max(year)},year_week={"<$(=max(forecast_version))"}>}sales))

    /

    (sum({<year={$(=max(year)-1)},year_week={">=$(=max(forecast_version))"}>}forecast) +
    sum({<year={$(=max(year)-1)},year_week={"<$(=max(forecast_version))"}>}sales))*100

     

     

     

    Captain_Jack_0-1620511965216.png

     

    Show Less
  • forum

    New to Qlik Sense

    Loading direct table vs Joining Tables

    Does performing joins in Database and bringing direct table, improve visual loading time when Qlik Sense app open ?
  • forum

    App Development

    Version Control in Qlik Sense (gitoqlik)

    Hi,I recently started to use gitoqlik (https://gitoqlik.com/) for version control of my Qlik Sense applications. I've always been quite surprised by n... Show More

    Hi,

    I recently started to use gitoqlik (https://gitoqlik.com/) for version control of my Qlik Sense applications. I've always been quite surprised by not finding version control in the Qlik roadmap. To me it's a basic functionality for development and I liked to see there are options online.

    So far it seems to be working pretty well. Do you have any experience using it for a long time? Is it working for you? Did you find any inconvenient to it? Do you implement version control with a different tool?

    I'm curious about the experience from other users in the Qlik Community. 

    Thanks,

    Juan

     

    Show Less
  • forum

    New to Qlik Sense

    Masters calender

    Hi,Here default selection is weekend dates(sat,sun) .when I was deselected  invoice year filter all the dates are showing (holidays,non holidays) .my ... Show More

    Hi,

    Here default selection is weekend dates(sat,sun) .when I was deselected  invoice year filter all the dates are showing (holidays,non holidays) .my requirement is when i was selected defualt filter invoice year data showing in all the dates.(now my defualt Selection is weekend dates)

    Can you please help me on this.

    Thanks,

    Bnsuresh.

     

     

    Show Less
  • forum

    QlikView App Dev

    Aggr data within custom ranges by Quarter

    Hi, I have custom ranges created off of a margin % column. For example 0-15 % , 15-30% ,30-45, 45-60 and more than 60%.I am trying to aggregate $ amt ... Show More

    Hi, I have custom ranges created off of a margin % column. For example 0-15 % , 15-30% ,30-45, 45-60 and more than 60%.

    I am trying to aggregate $ amt in each range by quarter .

    How would one approach this in the front end.

    Thanks in advance.

     

     

    Show Less
  • forum

    New to Qlik Sense

    sum according to dimension value

    Hello ,I am new to Qlik and Qlik sense ,  I am stucking in sum the value based on another value in the dimension(category)hope someone could help me o... Show More

    Hello ,

    I am new to Qlik and Qlik sense ,  I am stucking in sum the value based on another value in the dimension(category)

    hope someone could help me out here. thanks!

    I have a table on the left , and I want to sum the value where year_week = snapshot_week per snapshot,

    which means I would like to get on snapshot_week 202112 = 100 ,  snapshot 202113 =101, snapshot 202114 = 200.

     

    and also sum value where year_week < snapshot_week per snapshot.

    meaning Snapshot 202112 = 200 ,  snapshot 202113 =303, snapshot 202114 = 800.

    and I used   sum({<year_week={"<(=Min(Snapshot_week))"}>}Sales) , it does not work.

    what is the difference when I put a $(=Min(Snapshot_week) ?

    Captain_Jack_0-1620421280927.png

     

     

     

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

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.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

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

750+ Members

Events

Register for QlikWorld Today

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand