Hello Qlikers,

Since Adobe Flash is no longer supported in 2021, and also GeoQlik requires Flash in the QlikView Access Point, Is there still a way to display GeoQlik objects in the Qlikview Access Point? Does GeoAnalytics have the same problem?

Thanks in advance!

Hi,

I have data similar to below table and I'm trying to implement section access based on multiple columns

Ex:

1. a person can have access to EU region and also CN13 country

2. A person can have access to only US region data.

3. A person who is a manager (ex:M6) then he/she should see only data where Manager=M6

4. A person need to access only department  D6 and Region EU then all the items in region EU for D6 data should only be shown

Basically I need to filter data on multiple columns or single column to restrict data. Can anyone help me how to achieve this? I was able to do it on only one column.

Regards,

Harish

Hi Experts,

I have the script mentioned below. Can anyone explain its working please, i am  little confused. 

if Len(Trim('$ (vStartDate)'))=0 then
Let vStartDate = Date(Today());
EndIf

if Len(Trim('$ (vEndDate)'))=0 then
Let vEndDate = Date(Today()+1);
EndIf

Let vStartDate = Date('1/1/2021');

Let vEndDate= Date('30/1/2021');

Thanks in Advance 

Help!

Happy May everyone! Believe it or not, this month is our 12^th edition of Round of Applause! Even though it’s a cool name, we wanted an even cooler name for our featured members so from here on in we are going with High Five! This Community member has over 20K posts, received more than 8k likes, answered over 4K questions, and is a well-known leader in the Qlik Community. Today’s High Five goes to no other than Community MVP, Gysbert Wassenaar.

Gysbert joined the Qlik Community in September 2012. He had been visiting for a while, looking for answers to Qlik challenges he encountered in his job. He was already impressed by the quality of the answers he saw and by Community members who gave great solutions and advice. Gysbert was also impressed that Qlik employees participated actively. The day he decided to join the Community was when he saw a question from a community member and thought: "Hey, I think I know the answer to that." It was then he started participating, and he became hooked! Gysbert said he’s never learned so much so quickly about a product. Every question posted was another opportunity to expand his knowledge and Qlik skills.  Three months later, he was a Top 5 contributor. He recalls passing Stefan Wühl as top contributor about a year after he joined. The feedback from other community members, and especially from Qlik Community legends like Deepak Vadithala,  Stefan Wühl, John Witherspoon, Miguel Angel Baeyens, Henric Cronström,  Rob Wunderlich, Marcus Sommer and so many more, was awesome and a big motivating factor to keep coming back to the Qlik Community.

In his personal life, Gysbert is very fortunate to be living in a small beautiful medieval city in the Netherlands. He likes reading, taking walks in the countryside, learning about new technologies, and learning new tricks he can apply in his job.

Let’s give a big “High Five” to Gysbert with a like and a comment to show how much we appreciate his collaboration in the Qlik Community. @Gysbert_Wassenaar @Melissa_Potvin @marcus_sommer @rwunderlich @Henric_Cronström@Miguel_Angel_Baeyens @swuehl @johnw @IAMDV 

Hello Everyone

I have some experience in power BI , but I am new to Qlik. can I kindly ask if someone could help me out here, I am stucking with this question for many days :(.

I have a table on left with forecast and sales ,  how could I get an index (YOY) on all years( without filter the year), and pick the latest forecast version if there is not forecast_version is selected?

I tried below to calculate the index , but it is not correct.

(sum({<year={$(=max(year))},year_week={">=$(=max(forecast_version))"}>}forecast) +

sum({<year={$(=max(year)},year_week={"<$(=max(forecast_version))"}>}sales))

/

(sum({<year={$(=max(year)-1)},year_week={">=$(=max(forecast_version))"}>}forecast) +
sum({<year={$(=max(year)-1)},year_week={"<$(=max(forecast_version))"}>}sales))*100

Hi,

I recently started to use gitoqlik (https://gitoqlik.com/) for version control of my Qlik Sense applications. I've always been quite surprised by not finding version control in the Qlik roadmap. To me it's a basic functionality for development and I liked to see there are options online.

So far it seems to be working pretty well. Do you have any experience using it for a long time? Is it working for you? Did you find any inconvenient to it? Do you implement version control with a different tool?

I'm curious about the experience from other users in the Qlik Community. 

Thanks,

Juan

Hi, I have custom ranges created off of a margin % column. For example 0-15 % , 15-30% ,30-45, 45-60 and more than 60%.

I am trying to aggregate $ amt in each range by quarter .

How would one approach this in the front end.

Thanks in advance.