Hello Friends and Experts, 

                         I need some help on the following:

I have been trying to develop an app where I need to make different comparisons between different column values.

The input  table is as follows:

EXPECTED OUTPUT

Here the BOND_ID is the key and prev_curr_flag is a column which is populated based on my previous period= 01st Dec, 2020 and current period=31st Mar, 2021.

Now, I need to make some comparison like,

1. as for first 2 rows BOND_ID are same for 2 different period, but Type is different then I need to highlight TYPE column for those 2 rows or mention in a separate column "REASON", i.e. the type has changed

2. for row 3, as the BOND_ID does not exist for current period and we can see that it's matured (maturity_date) before current period, hence need to highlight the maturity date column for this row or or mention in a separate column "REASON", i.e. the BOND has matured

2. for row 4, as the BOND_ID does not exist for previous period and we can see that it's purchased (purchase_date) after previous period, hence need to highlight the purchase date column for this row or mention in a separate column "REASON", i.e. the BOND is newly purchased.

I have attached an excel for the input table and expected result. Could you please help how this can be achieved? in case you have any other question please let me know.

Hello April! There are hints of spring in many parts of the world and that brings feelings of hope after such a difficult year. Hope makes us want to celebrate and acknowledge the many great things taking flight. This month we celebrate a Qlik employee. You can find her in many parts of the Community, but mainly you will see her in the Ideation forum, governing the Ideation process, answering questions, and ensuring all Ideas are reviewed and moved throughout the ideation stages. Qlik’s Strategic Marketing Operations Specialist, Meghann MacDonald is an absolute pleasure to work with and is incredibly intelligent.

Meghann grew up in the United States and attended Northeastern University in Boston, where she earned her Bachelors in International Business and Marketing at the D’Amore McKim School of Business. It was there that she had the opportunity to work for Qlik during a 6-month internship at the Newton office within the Product Marketing organization. She fell in love with Qlik and working with data and kept up connections after going back to school to complete her degree.

After graduating, she started at Qlik full-time in the Global Products organization, working with projects and people from all areas of the company. She has built multiple Qlik Sense apps to help with the QlikWorld breakout sessions, QlikWorld session guides, content management, asset discovery, Ideation, and other Product Marketing programs. Meghann works with our G2 partners to gather reviews for Qlik Sense and Qlik Replicate, working with content creators across Qlik to manage and synchronize our assets. She is now the Ideation Moderator and enjoys engaging with and learning more about our customers and Community users.

Meghann is in the process of transferring to the UK where she will live and work. After living in Shanghai for 6 months and Indonesia for 7 months, this will be her 4th country of residence. Meghann loves outdoor activities such as rock climbing, hiking, and camping. She likes to attend concerts and see all different genres of live music. Meghann also loves to play video games and read. We’re impressed!

We are so pleased to work with Meghann. Please join us and recognize her with a “Round of Applause” by leaving a comment and giving a Like to show Meghann how much we appreciate her!  @Meghann_MacDonald @Katie_Abbott @Melissa_Potvin 

 Hey Everyone. Did you know that QlikWorld registration is open? This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics. It's going to be great and it's free! There will be a virtual booth for Qlik Communities and we hope you'll all stop by. Register from this link today. 

 March 2021, a year after the world forever changed. It’s so hard to believe it’s been a year already, yet at the same time, it feels like a lifetime. This year we relied more heavily on digital communication than ever before and there was no shortage of communicating in the Qlik Community. One member that stood out to us -- standing by to help, sharing his expertise, and leading by example -- is Qlik Community MVP Lech Miszkiewicz. That is why he is our featured member this month! Lech is in the Community almost every day. He has posted over 4K times, provided countless solutions, and received close to 2K likes.

Lech was born in Poland and lived there most of his life. He earned a Master of Engineering in Commodity Science at the University of Economics and separately a Bachelor of Corporate Management. Lech is married and lives in Sydney Australia. He loves watching Formula 1 and is a big fan of Cirque du Soleil. Lech plays guitar and keyboard. He loves to travel, take photos, and collects wristwatches. If you can believe it, he also runs half marathons and swims! So cool!

Lech began his professional career at Solaris Bus & Coach where he learned QlikView. He later became a QlikView consultant and started working for Hogart Business Intelligence – a Polish Qlik partner. This is where his passion for Qlik started.

In 2015 he was hired by Australian Qlik Elite partner InsideInfo Pty Ltd. and moved to Australia. Lech is still there today and strives to provide good service to InsideInfo’s clients. Lech would like to give a shout-out to his bosses Phil and Stuart!

As a Qlik consultant, Lech works with QlikView, Qlik Sense, NPrinting, and other Qlik products. He spends time in the Qlik Community consuming information from Support, NPrinting, Ideas, and the Tech Preview forums to keep up with the important things. He spends most of his time in the NPrinting forum and leaves the other forums to the likes of Sunny T, Vegar, and many other amazing contributors. Lech recognized that many members experienced the same NPrinting challenges, and so was born his NPrinting blog: https://nprintingadventures.com.

We are so happy and grateful that Lech is part of the Qlik Community. Please join us and recognize him with a “Round of Applause” by leaving a comment and giving a Like to show Lech how much we appreciate him. @Lech_Miszkiewicz @Melissa_Potvin 

Hey  All! I hope you are all doing well. I wanted to be sure you were aware of a new education course. Below are the details. @Bilge_Kara 

This intensive 15-week, blended learning course focuses on data analytics and data literacy, and the effective use in a Qlik Sense application. In addition, students will learn the fundamentals of building Qlik Sense apps, visualizations, and design best practices. Begins April 5 through July 16.  This is a blended learning course: Virtual Instructor-Led Training + self-paced learning (includes Full-access 12-month QCC Subscription). We are offering a 25% discount on registration.   Registration is open now!  https://inter.viewcentral.com/reg/qlik/ADAQS?soruceID1=communitycorner 

 Hello February! Our Featured Member this month is no stranger to Community. Anyone who is anyone in Qlik Community knows his name. There are even some posts labeled with his name! This high performer has contributed over 3,000 posts and replies, provided 700+ solutions, awarded nearly 1K likes, and received more than that. And he has consumed over 45,000 pieces of content. What a smart guy! It is with great pleasure that we announce this month’s Round of Applause recipient, the one and only Vegar, a valued Partner in the Qlik Community.

His given name is Vegar Lie Arntsen and he just turned 40 years old. Born and raised in the middle of Norway, Vegar has lived in Sweden with his wife and three children. In his spare time, he enjoys outdoor activities with family and friends. Fishing is Vegar’s favorite outdoor entertainment.

Vegar works as a Qlik consultant at our partner ViewBase in the city of Uppsala, an hour north of Stockholm. He has been working with Qlik products since 2010 and was a member of the Community from the start. Over the years, he has been a frequent reader and Community promotor. In his early years with QlikView, he found the Community to be a great source of knowledge. Even today as a Qlik developer and administrator, he still finds Community to be a valuable resource. Vegar appreciates the friendly atmosphere inside the Community. He finds everyone polite and friendly, where there is no such thing as a stupid question. 

A couple of years ago, Vegar started to put some effort into replying and helping others in the Community. He saw it as a good deed, a way to return the favor for all the help he received. He has since received other benefits from being an active member. He learns a lot by explaining things that he “knows” to others and said that there is a big difference between knowing and being able to explain it. Vegar benefits from the insights of reading other Community members' replies and alternative solutions on posts he participates in. He feels that participating in the Community is also good for the soul, it feels nice knowing that many of his small contributions have been of great help to others. Not long ago he received feedback from a member that his reply had solved their three-day-long struggle – WHAT A FEELING! 

We are honored to have Vegar as part of the Qlik Community. Please join us and recognize him with a “Round of Applause” by leaving a comment and giving a Like to show Vegar how much we value his contributions. @Vegar @Melissa_Potvin 

Participate in the 2021 Wisdom of Crowds® new-year research process and receive a complimentary report study findings. Again this year, Dresner Advisory Services is inviting all Business Intelligence (BI) and Analytical Data Infrastructure (ADI) users to participate in its annual examination of the state of the BI and analytics marketplace focusing on drivers, usage, and products.

The survey covers BI usage and trends around several technology areas including: Embedded BI, Big Data Analytics, Analytical Data Infrastructure, Data Preparation, Data Pipelines and Infrastructure, and Natural Language Analytics.    

Users in all roles and across all industries are welcome to contribute their insight via an online survey. The research will be published in a series across June, July, and August. Qualified survey participants will receive a complimentary copy of the findings.  

It's very brief and you only need to complete the survey sections relevant to you.  Click here to start the survey today! The deadline is March 31st. 

Not able to Hide a one sheet out of 14 from specific user groups,

I wrote this logic in Security rules ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read") and (((user.group!="QlikSense Stream ADS") and (resource.objecttype="Sheet") and (resource.name!="Day in Time")))) But still its not working.

Default Security rule is App*, If i put App_* it is not working .

How to achieve this Sheet Security in Qlik Sense.