Discover

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on Analytics App Development.

Questions:

• 01:16 - How to troubleshoot expressions that affect performance?
• 02:15 - How to troubleshoot corrupt direct query time formats?
• 03:32 - How does Anonymous Access work with IdP?
• 04:41 - What are the latest features of Qlik Cloud?
• 07:44 - Can we develop themes like in Sense?
• 09:23 - When will the nav bar be available in Qlik Sense on-prem?
• 09:55 - Can the Cloud session timeout setting be changed?
• 11:11 - Can an app be opened in different tabs with different selections?
• 14:09 - What chart for showing a timeline with parallel timelines?
• 15:06 - How to entitle Analyzer Capacity by default?
• 16:24 - What chart for density distributions?
• 19:39 - Entitlement Management details
• 20:11 - When will new features be release for Qlik Sense on Windows?
• 21:04 - How to adjust existing Reload permissions for Sense on Windows?
• 22:24 - Any plans for adding Gantt chart as an available chart type?
• 23:01 - Can charts in a layout container be full screen?
• 24:20 - How to avoid synthetic keys?
• 25:57 - Can a table be stored in a SharePoint folder?
• 28:53 - Can triggers be set based on selections made?
• 30:31 - How to build expression so that dates are not filtered out?
• 32:41 - Are there any planned changes with how Apply Map works?
• 34:37 - How to embed videos in apps?
• 36:04 - Can images be displayed via URL in apps?
• 37:13 - How to modify the date format in an app?
• 38:48 - Can web pages be embedded in an app?
• 39:41 - Are mapping indicators still required?
• 40:05 - Can a parent file attribute be seen when loading an XML file?
• 41:05 - How to connect to Python script in Cloud?
• 42:06 - Our expression is creating locking issues, suggestions?
• 43:31 - Can a 3D warehouse model be used in Qlik Sense?
• 44:27 - Can tenant "home" pages be customized with logos?
• 45:10 - Will App Automation connectors use the Data Gateway?
• 46:17 - How to restrict data based on the user?
• 47:13 - How to possibly rebrand an OEM tenant
• 47:44 - How to automatically trigger a reload after a failure?
• 49:12 - What is a Technical Preview?
• 50:27 - Can Chat GPT be integrated with Qlik Sense?
• 51:47 - How to apply a them to a mashup?
• 53:27 - Can the sorting for dimensions and measures in a pivot table be reorganized?
• 54:22 - Can the column names reflect the app names in the monitoring apps?

Resources:

• Qlik Anonymous Access
• Qlik Ideation
• What is the default user session timeout in Qlik Cloud?
• Managing user entitlements
• Let’s Make New Charts with Qlik Sense
• Understanding Set Analysis
• Application Automation connectors
• How to brand an OEM Tenant
• Qlik Cloud ErrorMode variable

Did we answer your question? Let us know by clicking the like button!

@Ola_Roxendal 

@Patrik_Lundblad 

As we kick off November, we’re excited to showcase one of Qlik Community’s brightest new talents, Valentin! Though he’s only been with us for a few months, Valentin has already become a go-to member, jumping in to help wherever he can and making a real difference. With seven years of experience implementing Qlik Sense, QlikView, and NPrinting—and a passion for training users to reach their full potential—Valentin brings both expertise and fresh energy to our Community. Let’s hear more about Valentin’s journey in his own words!

"I've learned so much from the Qlik Community over the years, so giving back feels like a natural next step. It’s an honor to help others unlock the potential of Qlik solutions and see the difference they make in real-time."

Beyond his Qlik contributions, Valentin stays active with swimming and volleyball and enjoys watching Formula 1. His dedication, both in and out of the Qlik Community, is truly inspiring.

Please join us in congratulating Valentin on his fantastic start in the Qlik Community! Let’s show our support by leaving a comment and hitting that like button. Thank you, Valentin, for being a part of our Community and sharing your expertise! @VBD @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa

December 12, 2024 10:00:00 AM||This Techspert Talks session will explore Qlik Cloud Analytics navigation, new developments for better flow and tips for moving around quicker.||December 12, 2024|| || 10 AM ET ||https://pages.qlik.com/GBL_STT_December.html

Join the Qlik Meetup Northwest community at The Redd in Portland for an in-person event focusing on how Qlik’s platform is evolving with AI. We’ll dive into Qlik StAIge, the AI toolkit that integrates seamlessly with the Qlik platform, and Insight Advisor, which uses natural language to transform data into clear insights, the new Qlik Answers, and more.

Discover how Qlik integrates with top LLM platforms like ChatGPT and AWS Bedrock to push the boundaries of data analytics. You’ll also get an deep dive to Qlik Answers, the platform’s new LLM AI Assistant and Chat Bot, designed to turn unstructured data into actionable knowledge—all within the Qlik ecosystem.

Food and drinks will be provided, making this not only a great opportunity to learn but also to network with fellow data professionals and AI enthusiasts in the Qlik community.

This is the perfect event for those who want to see firsthand how Qlik is leading the way in combining AI with powerful data analytics.

Event Details:
1140 SE 7th Avenue, Suite 150
Portland, OR 97214

Dec 03rd 2024 - 05:30pm - 07:30pm

Link for registration:

https://www.meetup.com/qlik-meetup-northwest/events/304329903

Hey Qlik enthusiasts! Ready to mix business with pleasure? Join us on December 1st for an unforgettable evening at the United Center. We’ve snagged a Penthouse Suite for the Chicago Blackhawks game, complete with food, drinks, and great company!

Event Details: 📅 Date: December 1, 2024 🕕 Time: 2:00 PM
📍 Location: United Center

Why You Should Join:
👉Watch the Blackhawks in action from a luxurious suite
👉Network with fellow Qlik users in a fun, relaxed setting
👉Enjoy complimentary food and drinks throughout the game

Don’t miss out on this perfect blend of networking and entertainment. RSVP as soon as possible, as spots are extremely limited.

Let’s make this a night to remember!

👉 RSVP via our #QlikMeetup Chicago group here: Chicago Meetup Group Registration 

Hey Qlik Fam! A few exciting updates for Q4.  We are getting social.

The former Chicago Talend User Group has been flipped over to a Qlik Meetup Group! We are in the midst of planning our first Meetup event for early December. 

• Link to join group: https://www.meetup.com/chicago-qlik-group/

A brand new Qlik Meetup is launching for Kansas City.  Please expect an event there this year as well. 

• Link to join group: https://www.meetup.com/kc-qlik-group/

The Denver Qlik Meetup has its first Virtual Meet and Greet in September! We also have in-person events now scheduled for 11/6 and 12/5!

• Link to join group: https://www.meetup.com/denver-qlik-group/
• Link for November Meetup event: https://pages.qlik.com/GenAIAtDenverNuggets.html (this one is being hosted by Qlik corporate)
• Link for December Meetup event: https://www.meetup.com/denver-qlik-group/events/304045919

Disclaimer: Qlik Meetups are free from any selling or marketing – from Qlik or its partners. These are supportive networking spaces where Qlik users share challenges and successes in order to create value.

Get social with us! 

Cheers,

Colette

Discover how to personalize your Qlik Community profile by updating your avatar! Follow this quick guide to make your profile uniquely yours.

(Click the YouTube link for a transcript of the video. If you need closed captions, please let us know here!)

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on Qlik Cloud Analytics Administration.

Questions:

• 01:39 - How is Qlik using AI?
• 02:47 - Is there a Cloud version of the Operations Monitor app?
• 04:01 - How to import Cloud admin apps?
• 05:53 - How can Active Directory be setup with Azure?
• 07:18 - Can engine creation be automated through Terraform?
• 08:47 - How to change sheet ownership?
• 11:53 - Do we have an Operations Monitor for SaaS?
• 12:50 - Why move from QlikView to Cloud?
• 15:43 - Are there recommended App Backup systems?
• 18:13 - How to assign user entitlements using automation?
• 19:39 - What if we don't have the hardware to follow best practices?
• 24:47 - Can bookmarks be made public to Spaces?
• 27:18 - Any tools for bulk user assignment?
• 29:21 - Will there be any native versioning control?
• 30:21 - Can developers work on the same app in the same space?
• 31:33 - Best practices for changing ownership of Automations and schedules?
• 34:10 - Can multiple IdPs be setup in a tenant?
• 35:55 - Does Cloud check the data model against best practices?
• 37:43 - What are best practices for large app capacity in spaces?
• 39:49 - How can you see what reloads are queuing?
• 41:08 - Will storytelling be available between apps in a space?
• 41:58 - Can reloads be triggered from a managed app without using Automation?
• 43:10 - Are platform SDKs for Python reference being maintained?
• 43:57 - Is chaining reload task possible without automation?
• 45:06 - In there a QMC in Cloud like in QlikView?
• 46:35 - How to limit the permissions of who can see specific apps?
• 50:00 - Any NPrinting alternatives for Qlik Cloud?
• 50:41 - Can users be managed without having the Tenant Admin role?
• 51:30 - Are there Automation templates for writing to Excel from visual table data?
• 52:15 - Can data from Talend Cloud be used with Qlik Cloud Analytics?
• 53:23 - How to get around Webhook triggers 15 minute timeout limit?

Resources:

• The Qlik Sense Monitoring Applications for Cloud and On Premise
• Qlik Ideation
• How To: Configure Qlik Sense Enterprise SaaS to use Azure AD as an IdP. Now with Groups
• Managing personal and private content
• Tutorial - change app object owner
• Migrating QlikView to Qlik Cloud
• CI/CD pipelines for Qlik Sense apps with automations and Github
• Video Demonstration of version control with automation
• Configuring Qlik Cloud for SCIM
• How to: Use Qlik Application Automation to manage users
• Qlik Cloud Administration 101
• App performance evaluation
• Qlik Cloud Reporting Evolution
• How to load Qlik Talend Data into Qlik Cloud

Did we answer your question? Let us know by clicking the like button!

@Vinay_B 

@Daniele_Purrone 

@Umberto 

Hi Team, 

Is it possible to get the Open Source Code of Qlik NPrinting?

I mean there are  developers around the world who might help in improving the quality of the product by adding new features and publish it on git.

Kindly share if possible, It will help to save lot of time if more people will allowed to improve the quality of this product.

Thanks 

November 20, 2024 ||Discuss how AI and automation can simplify data management, reduce manual work, and accelerate your path to insights.||November 20, 2024|| || Choose a session ||https://pages.qlik.com/InsiderWebinarNov.html?utm_campaign=&utm_medium=webinar&utm_source=QlikCommunity&utm_team=GPR&utm_content=DataQlikInsiderNov

November 13, 2024 ||Learn how to upgrade your BI with flexible, automated reporting — and get a sneak peek at our brand-new reporting capability.||November 13, 2024|| || Choose a session ||https://pages.qlik.com/QlikInsiderReporting.html?utm_campaign=701R500000DR8hyIAD&utm_medium=qlik-internal&utm_source=QlikCommunity&utm_team=GPR

Good day Qlik Community,

I usually write articles and record videos about AI and Statistics in the realm of the Qlik Platform. Today I am doing something different, and that is why I am publishing here at the Water Cooler section. I know this is not related to Qlik but I feel that this community is more than just work. I made friends here that I bring to my personal life.

Having said that, today's article is a bit more personal, and it was away to put into paper a topic that I have been thinking for the past months.

This is the link to the article. It is very short. I just a provocative hypothesis I am presenting:

Does Autism Make You Better at "Talking" to AI?

This October, we're absolutely buzzing to turn the spotlight on a member who's been making waves with his enthusiasm and unstoppable spirit for knowledge-sharing! Say hello to Matheus, a rising star in the Qlik Community whose journey kicked off in 2021 but has already made an unforgettable impact. With a true passion for data and an unwavering commitment to helping others, Matheus has quickly become a go-to expert and inspiration in our forums.

His infectious energy for learning and dedication to giving back set him apart. But don’t just take our word for it—hear it straight from Matheus himself:

“My journey with Qlik began in 2021, and with it, the quest for knowledge and learning. The Community was one of those sources of knowledge. This collaboration, the interaction among users, was what encouraged me to contribute and share the learning I acquired throughout this journey because as it was beneficial to me, I hope it can also help many others. I believe that whenever we teach, we are also learning.”

When he's not immersed in Qlik, Matheus enjoys staying active with a workout, unwinding with his favorite series, and embarking on gaming adventures.

Join us in giving Matheus a well-deserved shoutout for his amazing contributions! Drop a comment or hit that like button to show your appreciation. Thank you, Matheus, for lighting up the Qlik Community with your passion and knowledge! @MatheusC @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa

This Techspert Talks session covers:

• Exploring Cloud Reporting Capabilities
• Using the Excel Add-in
• Glimpsing the future of reporting

Chapters:

• 01:41 - Reporting capabilities: past, present, future
• 02:32 - Enterprise Use-Case capabilities
• 04:17 - Report Task Management
• 05:04 - Cycling in-task settings
• 06:14 - Task history
• 07:22 - Filters and Recipients
• 08:32 - On-Demand reports
• 09:09 - Tabular report Qlik Add-in for Excel
• 11:09 - Uploading templates
• 11:48 - Pixel-Perfect templates
• 14:51 - Cloud subscriptions for reporting
• 15:31 - Pixel-Perfect example
• 17:40 - Q&A: Can Report Filters be loaded?
• 18:09 - Q&A: Can you edit the email body?
• 18:57 - Q&A: What is the future of NPrinting?
• 19:35 - Q&A: When will Pixel-Perfect be released?
• 20:00 - Q&A: Hurdles for migrating to Qlik Cloud?
• 20:58 - Q&A: Where is info about Qlik Add-in for Excel?
• 21:15 - Q&A: Can reports be embedded in emails?
• 21:29 - Q&A: How many reports can be sent for free?
• 21:55 - Q&A: How do I see how many reports I've run?
• 22:25 - Q&A: Can reports be sent to groups?
• 23:00 - Q&A: Can reports be created on-demand?
• 23:24 - Q&A: How to troubleshoot a failed to send error?
• 23:54 - Q&A: Can selections be made in Excel with the Add-in?
• 24:37 - Q&A: Where can we learn about making Pixel-Perfect reports?

Resources:

• Reporting from Qlik Cloud Analytics
• Using the Qlik add-in for Microsoft Excel
• The Qlik Sense Monitoring Applications for Cloud and On Premise
• Understanding PixelPerfect features
• Using Qlik Application Automation to create and distribute Excel reports in Office 365
• Creating a report using Qlik Application Automation

• Migrating QlikView to Qlik Cloud

@Andrew_Kruger 

I need help with this expression. The goal is to calculate within set analysis the field ProductLastEntryDateSite + 45 days forward. This calculation needs to be done for each product where the field is ProductCode. In other words, each product has a date in the field ProductLastEntryDateSite. However, in the table, the result will only be displayed based on the field ProductLastEntryDateSite. Therefore, I need to create a virtual table using the Aggr function to get this result.

The problem is that when I include the dimension ProductCode in the table, the information appears, and the result is correct. But when I remove the ProductCode dimension and leave only ProductLastEntryDateSite, the result becomes null. How can I apply date filters within the Aggr function?

Expression:

Sum({<ProductYearMonthLastEntrySite>}
Aggr({<
Date = {">=$(=Date(Max(ProductLastEntryDateSite)+0))<=$(=Date(Max(ProductLastEntryDateSite)+45))"},
Year = {">=$(=Year(Max(ProductLastEntryDateSite)+0))<=$(=Year(Max(ProductLastEntryDateSite)+45))"},
YearMonth = {">=$(=MonthName(Max(ProductLastEntryDateSite)+0))<=$(=MonthName(Max(ProductLastEntryDateSite)+45))"}>}
Sum({<
TransactionType = {'Invoicing'},
BusinessTransaction = {'E-commerce'},
ProductLastEntryDateSite = {">=$(v.cutStartDate)"}
>}
OrderItemSaleQuantityInvoiced),ProductYearMonthLastEntrySite))

Preciso de uma ajuda com o esta expressão. Objetivo é calcular dentro do set anlysis o campo ProdutoDataÚltimaEntradaSite + 45 dias para frente, este calculo precisa ser obtido por Produto que o campo é ProdutoCódigo, ou seja, cada Produto tem uma data que se encontra no campo ProdutoDataÚltimaEntradaSite. Porém, na tabela o resultado será mostrado aberto somente pelo campo ProdutoDataÚltimaEntradaSite, ou seja, preciso criar uma tabela virtual com a função Aggr, para chegar neste resultado. O problema é que quando eu incluo na tabela a dimenssão ProdutoCódigo as informações aparecem e resultado fica coerente, mas quando retiro a dimenssão ProdutoCódigo e permanece somente ProdutoDataÚltimaEntradaSite, o resultado fica nulo. Como consigo fazer filtros com as variaveis de datas dentro da função Aggr?

expressão:

November 14, 2024 10:00:00 AM||This Techspert Talks session will include how to remotely manage Spaces, Apps, Users and Roles.||November 14, 2024|| || 10 AM ET ||https://pages.qlik.com/GBL_STT_November.html

Preciso de ajuda com essa expressão no QlikSense. O problema é que do jeito que estou fazendo, não está trazendo resultados para ItemOrderSaleQuantityInvoiced. Preciso que minha tabela seja aberta na linha por ProductLastEntryDateSite, e como medida trazer a quantidade de peças que estão no campo ItemOrderSaleQuantityInvoiced, com essa quantidade para cada ProductCode, considerando que cada ProductCode tem um ProductLastEntryDateSite e a partir dessa data considerar + 45 dias no futuro, que seria meu faturamento. Alguém tem ideia de como posso tratar minha medida para obter esse cenário citado?

Se(ProductLastEntryDateSite >= '$(v.CutStartDate)',
Sum(
Aggr(
Sum(
{<
//ProductCode,
Date = {">=$(=Data(Max(ProductLastEntryDateSite)))<=$(=Data(Max(ProductLastEntryDateSite)+45))"},
YearMonth = {">=$(=MonthName(Max(ProductLastEntryDateSite)))<=$(=MonthName(Max(ProductLastEntryDateSite)+45))"},
Year = {">=$(=Year(Max(ProductLastEntryDateSite)))<=$(=Year(Max(ProductLastEntryDateSite)+45))"}
TransactionType = {'Faturamento'},
BusinessTransaction = {'E-commerce'}
ProductCode =
>}
OrderItemSaleQuantityInvoiced
),
ProdutoAnoMêsÚltimaEntradaSite
)
), '')

Calling all Qlik enthusiasts! 💙 The Khoros Kudos 2024 awards are here, and Qlik is nominated for 'Best in Class Community'! You know why? Because YOU are the heartbeat of Qlik! 💓 Our vibrant Community keeps the lifeblood of innovation and collaboration pumping through every dashboard and data point. It's time to show the world our pulse is stronger than ever! Voting is as easy as a single click, but it echoes the rhythm of thousands of Qlik users. Let's amplify our collective beat and bring home the 'Best in Class Community' title! Ready to make some noise? Cast your vote, and let's turn up the volume on Qlik Community love! 🎵📊 Together, we're not just users – we're the life force of the Qlik Community! #QlikCommunityHeartbeat"

 https://community.khoros.com/idea/khoros-kudos-2024/qlik/766002

Thank you all!