Boa tarde comunidade!

Eu realizei um 'IF' que foi realizado corretamente, mas ele me apresentou alguns valores nulos.
Como poderia fazer para remover esses valores?

Muito Obrigado pela atenção.

Hi All,

How to sort data based on leading zeros and not the actual number in qlik

Below is my example

The data should be sorted based on number of zeros at the start in ascending order.

My final output should be like the below table

Note : This is just an example . I have more that 30000 item numbers like this and i want to sort based on number of leading zeros

Hello.  I'm sorry as I'm sure this question is asked a lot but I wanted to get everyone's opinion on the best way to learn Qlik Sense. Here are the questions I have:

1) Data Transformations - I'm used to performing data transformations using Power Query which visualizes the data and has a drag and drop interface.  From my limited research, it looks like Qlik uses a scripting language to transform data prior to integrating it into a data model.  This seems like it will require a good amount of time to learn.  Is it better to spend that time learning the QLIK Scripting language or should I just learn how to do it in SQL and then bring in the data?  I am sure there are pros and cons to both but in the short-term I'm probably only going to bother learning one and I wanted to know what is preferred among Qlik Users?

2) Training - What courses have people used to learn Qlik Sense?  Are there known youtubers?  I saw Qlik Sense has a free business analyst video set.  I watched a few introduction videos and most of it is pretty intuitive.  

The two areas I'm struggle with is understanding how filtering works in Qlik Sense but I think I just need more practice playing with data.  The big area of focus is to understand the lexicon (what functions are available in Qlik Sense, how they work) and the syntax in Qlik Sense so I can write functions/play around with it.   

Thank you for your time!  

April Fools' Day is the favorite holiday of which animal? The silly goose! Happy April, everyone!

This month, we spotlight a Qlik Community member using the platform for 17 years. The statistics I'm about to share began in 2020 when he created a new profile. Since then, he has made almost 1,000 posts, solved hundreds of problems, and given and received countless likes. He's not only active in the forums, but he also belongs to like-minded Community groups. You may know him as QFabian. It's my pleasure to introduce our featured member for April, valued customer and Specialist III, Fabian Quezada. Here is his remarkable Qlik story in his own words.

During my free time, I like to observe the stars and planets within my reach and enjoy discovering the rings of Saturn and the colors of Jupiter. Then, I see all the data that is used and generated before and during the observation. With Qlik, everything is prepared for observation and discovery. Data and business rules are obtained and processed, and the results are graphed for analysis and discovery.

Qlik is an effective and proven way to deliver reliable data for decision-making in a friendly and intuitive interface in memory, and Qlik has been doing it for many years. Qlik's associative engine is unique and extraordinary. Whether you choose cloud, local, or hybrid, Qlik always delivers.

I have been a fan of the Qlik community for a long time. My current account isn't that old. I created the first one in 2007, but I lost it. Although many companies have community sites, Qlik is a pioneer in this regard, and the collaboration between Qlik personnel and the rest of the Community membership is impressive. Being part of the Community allows me to keep challenging my mind. I always try to provide quick and effective answers with detailed explanations and practical examples, just as I would like all cases I review to be when I seek to understand new concepts or encounter script challenges.

It's also important to note that being a member of the Qlik community makes me feel like I am part of something big. 

Let's show Fabian how much we appreciate his contributions to the Qlik Community by commenting and hitting that like button. @QFabian @Sue_Macaluso @Melissa_Potvin @nicole_ulloa @Jamie_Gregory 

Hi guys! Long time lurker and I do post now and again (I think). My company has just picked up Qlik Sense as a way to remove the need for us to email our reports to our clients. Instead, they will be able to access their reports on Qlik and we will not need to produce the reports in Excel as the app will do this for us.

It is the first week in and I am really really struggling with using Qlik. Many of the questions I have googled I am struggling to find an answer to as there doesn't seem to be many people using it. I have had a look for any sort of fully comprehensive course on youtube but have failed to find one. Would any of you guys be able to recommend any tutorial courses that are available for free??

Thanks for the help in advance.

Hi everyone,

Hope you can help me. I want to change my mail of this account, little context, my boss was fired and l need to change the email and password of this Qlik account to another of the company, how can l change the mail? 
But with no lossing any of my app's

l dont know exactly how can l change it

Best Regards

Hi all,

Hope you can help me, this is a urgent message, my main hosting that provide my mail service was hack and all my information with this domain is vulnerable here in Qlik Sense, thats why l would like to know how can l change my mail to another provitional meanwhile this is fixed

Hope you can help me, sorry for the delay, how can l assist you with solving this problem urgently

Regards,

Instead of using MySQL native master-slave replica setup, can I use Qlik Replicate to replicate tables from source to target endpoint? Both endpoints are running MySQL 8.0

Any performance task settings guidlines or tips that I could follow?

Thank you.

Desmond

Hi,

is here some option how to set for analyzer capacity license user different Session inactivity timeout (10 min) than for user with professional license (default 30 min)?

Explanation:

I need it for our case when app is reloaded each 15 min and app reload extend session inactivity timeout. If I left the capacity license to reload for 30 minutes, the license would be used up if the user did not log out. Reload is considered as a user activity.

Is here some way how to deal with it?

User with professional license doesn´t want to be logged out every 10 minutes.

Thank you for ideas