Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,184 online
Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today

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

    Google maps api key not working anymore

    Hi all, I'm using the google maps api key a few years now. This was working fine. Only since this week It isn't working anymore.This is the script:LOA... Show More

    Hi all,

     

    I'm using the google maps api key a few years now. This was working fine. Only since this week It isn't working anymore.

    This is the script:

    LOAD
    '$(vStation)' as STNR,
    '$(vStationsnaam)' as Stationsnaam,
    '$(vStationsnaamlang)' as Stationsnaamlang,
    '$(vCustomer)' as Customer,
    '$(address)' as Address,
    '$(vCountry)' as Country,
    [result/geometry/location/lat] as latitude,
    [result/geometry/location/lng] as longitude
    FROM [https://maps.googleapis.com/maps/api/geocode/xml?address=$(address)&key=MyKey] (XmlSimple, Table is [GeocodeResponse]);

     

    If I put the created url in the webbrowser I'm returning this message:

    kris_vliegen_0-1620798867035.png

    Who can help me with this?

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    nprinting license

    I have a client that is switching to  the Qlik AMP licensing.   The are still running nprinting 16 and need to continue to do so because of some compl... Show More

    I have a client that is switching to  the Qlik AMP licensing.   The are still running nprinting 16 and need to continue to do so because of some complex report distribution processes.    Is the any implications related to the nprinting 16 when switching the servers over to AMP based signed license keys?

     

    Thanks in advance

    Show Less
  • forum

    QlikView Administration

    Impact of Password Encryption

    Hi, what is the impact of password encryption for the ID which is used in login of QlikView services. Same ID is ADMIN and is used for development of ... Show More
    Hi, what is the impact of password encryption for the ID which is used in login of QlikView services. Same ID is ADMIN and is used for development of QlikView report and QMC Login
    Show Less
  • forum

    App Development

    Set Analysis Expression Help

    Team,Now suppose if I make any selection in Year Month or Plant, Figure not affected in Pivot Table. So need expression for the same. Please find the ... Show More

    Team,

    Now suppose if I make any selection in Year Month or Plant, Figure not affected in Pivot Table. So need expression for the same. Please find the attached QVW for more reference.

    Thanks

    Show Less
  • forum

    QlikView App Dev

    Set different color depending on the variable's value

    Hello guys,I created a variable called vAirComp1, with the following expression in order to collect the first item selected on the field called NCIA.=... Show More

    Hello guys,

    I created a variable called vAirComp1, with the following expression in order to collect the first item selected on the field called NCIA.

    =SubField(GetFieldSelections(NCIA, ' - ', 5),' - ',1)

     

    And once the user can select as many NCIAs as possible, I'm using the following background color expression in order to color my chart line based on the user's selection (vAirComp1 value).

    if(vAirComp1='AZU',RGB(14,43,88),
    if(vAirComp1='GLO',RGB(255,112,32),
    if(vAirComp1='PTB',rgb(255,213,3),
    if(vAirComp1='ARG',rgb(0,173,239),
    if(vAirComp1='SKU',rgb(89,35,127),
    if(vAirComp1='VVC',rgb(255,219,0),
    if(vAirComp1='EFY',rgb(254,118,17),
    if(vAirComp1='BOV',rgb(13,42,98),
    if(vAirComp1='BWA',rgb(175,38,120),
    if(vAirComp1='RPB',rgb(103,51,205),
    if(vAirComp1='NSE',rgb(211,52,53),
    if(vAirComp1='SRU',rgb(74,90,97),
    if(vAirComp1='FBZ',rgb(254,190,16),
    if(vAirComp1='THT',rgb(45,204,211),
    if(vAirComp1='VTA',rgb(223,0,43),
    if(vAirComp1='ECO',rgb(0,173,238),
    if(vAirComp1='ACL',rgb(108,18,64),
    if(vAirComp1='VCV',rgb(239,126,42),
    if(vAirComp1='DAP',rgb(45,45,46),
    if(vAirComp1='ROR',rgb(253,230,0),
    if(vAirComp1='RYL',rgb(11,70,150),
    if(vAirComp1='SRC',rgb(38,73,110),
    if(vAirComp1='TGY',rgb(0,35,93),
    if(vAirComp1='SID',rgb(47,57,117),
    if(vAirComp1='MWM',rgb(147,200,70),
    if(vAirComp1='JAT',rgb(158,32,45),
    if(vAirComp1='WAY',rgb(103,51,205),
    if(vAirComp1='AZN' or vAirComp1='AZP',rgb(0,166,81),
    if(vAirComp1='AVA' or vAirComp1='TPA',rgb(2219,19,25),
    if(vAirComp1='LAN' or vAirComp1='LCO',rgb(230,51,88),
    ))))))))))))))))))))))))))))))

     

    But as you can see, there are lots of IFs statements...

    Is there any better way of doing this?
    I'm pretty sure I'm not using the smartest solution... 😁

    Any ideas?

     

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    What is the meaning of FoTF in this sentence?

    Dear I don't understand it.Sentence recorded in the Qlik Sense release note.What is the meaning of FoTF in this sentence?"Some FoTF in SetExp not alwa... Show More

    Dear 

    I don't understand it.

    Sentence recorded in the Qlik Sense release note.

    What is the meaning of FoTF in this sentence?

    "Some FoTF in SetExp not always evaluated correct"

    Please explain it.

    Show Less
  • forum

    New to Qlik Sense

    Link table help

    Hi team,I need to create a link table and unsure how to approach this.  My model has 4 separate fact tables:EmployeeData: //that contains identifiers ... Show More

    Hi team,

    I need to create a link table and unsure how to approach this.  My model has 4 separate fact tables:

    EmployeeData: //that contains identifiers for an individual
    PID,
    PAN

    LeaveTaken:  //that contains the leave an employee has taken and importantly, the type of leave they have taken, this connects to the employee data table at the PAN level
    LeaveTaken.WBPAN as PAN,//this is an employees identifier
    LeaveTaken.LeaveType as TypeOfLeave

    LeaveBalances: //that contains leave balance data and importantly, the type of leave balance it is, this connects to the the employee data table at the PID level
    [LeaveBalances.Employee Code] as PID,
    [LeaveBalances.Leave Group] as TypeOfLeave

    FutureLeave: //because our systems suck, leave greater than 6 weeks into the future, comes as a separate file with a different file structure to the LeaveTaken file.  This also joins at the PAN level
    EMP_ID as PAN,
    LeaveTakenType as TypeOfLeave

    The outcome I am wanting in a link table, that joins the 4 tables "together", so when filtering the data, what leave balance an individual has what leave they have taken all connects.  Like this:

    LeaveLink:
    PID,
    PAN,
    TypeOfLeave,
    Plus additional keys to make the joins work properly.  Just stuck on getting all four table to combine together properly.

    How would I go about creating this? 

    Appreciate the guidance here!

    Thanks

    Carl

    Show Less
  • forum

    App Development

    Dynamic String Find in Field - Frontend Calculation

    I'm looking for a way to dynamically search a field on the front end to see if all the values have a shared sequence. I don't want to provide it to se... Show More

    I'm looking for a way to dynamically search a field on the front end to see if all the values have a shared sequence. I don't want to provide it to search but rather it is found dynamically. For example, if I had the below data and the application is filtered to 'A' on [Grp] it would return 'SMTH - ' but unfiltered it would return '' or Null().

     

    Grp | Text Value

      A   |  SMTH - 1E

      A   |  SMTH - 2W

      B  |   WPQV - 2A

      B  |  5N

      

    Thanks in advance for your help/thoughts.

    Show Less
  • forum

    New to Qlik Sense

    Bar Chart to show count between dates

    I have a data set:IDStartDateEndDateI want to create a bar chart with date on the x-axis and a count of active IDs on the y-axis but need to do it in ... Show More

    I have a data set:

    ID

    StartDate

    EndDate

    I want to create a bar chart with date on the x-axis and a count of active IDs on the y-axis but need to do it in the app not the loader.

     

    I know I can do this by creating a new table in the data load editor by doing:

    [ActiveDates]:
    noconcatenate LOAD
    ID,
    date(StartDate+IterNo()-1) as ActiveDate
    while date(StartDate+IterNo()-1)<=EndDate;
    load
    *
    resident DataTable;

     

    but there are approx 5 million IDs and each has something between 1 year and 5 years worth of dates to iterate over so this is not a  practical resolution.

    Show Less
  • forum

    New to Qlik Sense

    Automatically update data in Qlik Sense "Story Telling" charts

    Hi All,I am looking for a solution where I create a story once and every week the data should automatically get updated in the story.I understand that... Show More

    Hi All,

    I am looking for a solution where I create a story once and every week the data should automatically get updated in the story.

    I understand that we can use snapshots and the entire sheet itself within a story, However, is there a way which probably I am not aware of which can help me achieve a story where the data in those charts in the story has to update every week or so.

    FYI - I use Qlik Sense 3.2

    Thank you very much.

    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