Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics.
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.
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Participate in Qlik Technical Previews, submit ideas, and review documentation.
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.
Hear directly from Qlik employees in our ten unique blogs.
Get started, find How-To documents, and join general non-product related discussions.
Here you will find a list of all the Qlik Community forums.
May 26, 2021: Choose the session of your choice
May 20, 2021 at 2PM EDT/11AM PDT
There is a brand-new area of the Qlik website designed to be your one-stop place for all information related to our product innovation and direction.
Be sure to visit and bookmark QLIK.COM/ROADMAP to stay informed about what’s new and what’s coming and learn more about our vision and strategic direction.
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:
'$(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:
Who can help me with this?
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
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.
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... 😁
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.
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
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:
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!
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.
I have a data set:
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:
date(StartDate+IterNo()-1) as ActiveDate
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.
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.
Our featured member for May 2021
Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
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.
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!’
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.