Hello, i have built a LastMonthFlag and it correctly grabs April, but i only want it to grab April of the current year.  How do i achieve this? It is currently grabbing April for every year in my dataset. My code is below.

IF(Month(datefield) = Month(now())-1,1,0) as LastMonthFlag

Please help me achieve this, thank you!

Hello May! We are halfway through 2024. This month's focus is on a rising star. A member who joined the Qlik Community not seven months ago has already posted over one hundred times. You can see him on the monthly leaderboard. Many of the answers he’s provided are marked as accepted solutions. He shows his appreciation regularly by liking others' posts. This May, we are featuring a Qlik Partner and a Community member with a rank of Creator II, Maxime Piquet, AKA mpc.

Check out our rising stars story:

Allow me to introduce myself; I'm Maxime. As a seasoned data consultant, I've been harnessing the power of Qlik tools since 2016. My journey began with QlikView 11.2, followed by Qlik Sense in June 2017, and then Qlik Cloud. I've honed my skills in various areas, including app development, optimization, architecture, administration, upgrade, and migration. I'm proud to say that I'm newly certified.

When I embarked on my Qlik journey, the Community became my guiding light. It was my go-to for knowledge enhancement and assistance. Today, I'm privileged to give back and support my fellow Qlik Community members. Sharing and helping are not just values I hold dear but also ones that my company cherishes.

I like to eat, drink, and repeat. I enjoy strength training and climbing. I love cooking, mechanical work, and sports. In addition, I enjoy DIY projects and the watchmaking industry. I’m curious, and I love to discover new things! Share with me your hobbies!

Please show Maxime how much we appreciate his contributions to the Qlik Community. He is an inspiring example of a rising star. Like and comment, and, as Maxime said, share your hobbies.

Thank you, Maxime, for being our May featured member. @Jamie_Gregory @calebjlee @nicole_ulloa @Melissa_Potvin @mpc 

Hello, 

I have an app where i want to change the data value based on the user input from the dashboard. Say i have the following table below. How would i go about setting up a dashboard to where they can filter on the ID and Attribute to change the Value and I cant utilize a QVD (company reasons) or vizlib writeback functionality. My initial thought is a variable input and partial reload but any guidance is appreciated. 

If i select ID =1, Attribute = Color, Value change to Green then i want the table to read

Hello.  I am looking to be able to search for null/empty values in the web view.

*string* works for everything, but I cannot figure out a way to search for nulls.

I want to filter to the values equal to dash/hyphen/null

Any help would be great

When you see a new member with the "Community Manager" rank, it is our summer Intern, Caleb Lee! You will see him in many areas of the Qlik Community.  

Caleb, entering his final year at Northeastern University, brings diverse skills and interests to our team. He is majoring in Business Administration with a concentration in Marketing Analytics and a minor in Computer Science and Film Studies. Beyond academics, Caleb is a big food enthusiast, enjoys working on small film projects with friends, and loves biking around Boston. A fun fact about Caleb is that the last show he binge-watched was Severance, which he highly recommends! Feel free to reach out; he loves meeting new people!

Please welcome Caleb to our team!

@calebjlee @Melissa_Potvin @Jamie_Gregory @nicole_ulloa 

Hello,

I have a issue with these data, i need to create Cumple? field, the rules is with the same id_vehiculo, with different CodTransito and PuntoCobro, the difference between fechahora(1) and fechahora(2) is <= 20 minutes

How can i do these?

From UI, it is easy to select all tables.

However, if I manually input a json task file, is there a way to define migrating all tables? Instead of adding a list of tables to "explicit_included_tables"?

Hello,

Just wondering if this "works as designed" or if it's a bug. In Qlik Sense Enterprise, when you go into an app's settings and select Disable Sheet Header, the nav icons "<>" are no longer present. This may seem obvious, but I was told by someone that in Qlik Sense Cloud, they appear in a different location.  So I was wondering if that claim was true and if they should also be visible in Qlik Sense client-managed as well. 

Thank you

Steve