Hello everyone,

I have a question: Is there a way to move qvd from on prem to qlik cloud ?

I assume there are several options but not sure :

1. QLik CLI : Is it possible and how ?
2. QLik Data Transfert : It can only move raw data from data sources and transform them to qvd ? But it is possible to move transformed qvd ?
3. API Request ?

Thank you

Regards

Hi everyone.

I have a straight table with columns from the dimensions tab as well as the expressions tab. There is one column at the end (dimension column) that will not move to a different position when I drag it. I played around by adding other dimensions after it and they too refuse to move.

Please help / advise.

Thank you.

Regards,

Ashley.

Hello Qlik Community,

We're thrilled to introduce our featured member for the month of June: Théo Atragie! Théo joined our Community in October 2023, and since then, he's been shining bright as one of our rising stars. As a data consultant at ACSSI, a leading French digital service company, Théo has quickly established himself as a key player in the Qlik ecosystem. With a keen focus on Qlik Sense, he dedicates his time to mastering the intricacies of data analytics and visualization.

What sets Théo apart is not just his expertise but also his unwavering commitment to helping others. Despite being a relatively new member, Théo is constantly engaged and active in our Community. He consistently stays on top of the leaderboards and is always ready to lend a helping hand to fellow Community members.

In his own words, Qlik isn't just a tool for me; it's a gateway to observation and discovery. Spending time in the Community is something I enjoy because it allows me to both receive and give knowledge, enriching my pedagogy.

In his life outside of data analytics, Théo enjoy participating in sports, particularly running. He recently completed the Paris Marathon, showcasing his determination and endurance. Based in Baisieux, France, Théo embodies the spirit of our global Community, bridging geographical boundaries to connect with fellow Qlik enthusiasts worldwide.

Please join us in congratulating Théo for his outstanding contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Théo, for inspiring us with your dedication and passion. @Sue_Macaluso @Melissa_Potvin @nicole_ulloa @Jamie_Gregory @theoat 

Hello,

I have a table with data for each day. But I only ever need the last day of the month. That's why I added the field "MonthEnd(MyDate) as ypA_MonthEnd" to the table.

Now I would like to always see the value of the last day of the month.

To do this I wanted to use the formula:

SUM({$<MyDate = {"=$(=ypA_MonthEnd)"}>}Sales)

But unfortunately I don't get any result. What did i do wrong?

Hi all.

I am working with a Julian Calendar which is built via a 3rd party using SQL. I use that same SQL script in Qlik Sense to store it as a QVD with only the current and previous calendar year.

I have a date field that contains the dates for the current and previous year and then also a DayNum field to whichs numbers the days of the year.

To start off with an example

My Client wants to be able to select a date in the latest financial year only and that should link up with the corresponding date based on the day number in order to do a CYTD vs PYTD calculations.

Just to add an example. Once we get to Fin Year 2027 and 2028, my year will start with 2026/06/29 for fin 2027 and the fin year 2028 will start on 2028/07/05 

Would this be something that I do in the front end or the back end and also, how would I go about it? 

I have a table with peoples presence at certain dates. Of course, sometimes people are not available and they are missing in the input table.

I want to create an overview, showing when people were present or not with the specific dates in the columns and as values either "v" (when present) or "x" when absent.

I thought I learned how to do so in the Udemy Qlik Sense course, but apparently, I haven't been paying enough attention or I am applying it in the wrong way.

So can someone help me with the right approach?

In the source table, presence is noted like below:

So for every single person, the presence is noted per date. People who were not present are no noted for that date.

I created the pivot like this:

On the left are the names and registration numbers of the people.

I created a new measure for the pivot with this expression:

if(count(appel_datum)>0,'v','x')

But as you can see only the dates when people are present are in the pivot. When people were not present, there is only the dash sign.

I also used tried this expression:

if(isnull(appel_datum)<>-1,'v','x') (unchecked 'show nulls').

How can I get Qlik Sense to show an "x" for the date a person was not present (and therefore is not in the source table)?

I am using Qlik sense version Aug 2022

I want to change the background color of title in 1 pivot table 

The below code is changing the background color but it is changing the same in all the pivot tables

Even though I have written the object id , yet it is not working.

[tid="e79ce789-7fd1-49d0-a811-fd3101970b23"] .qv-object-table th {
background-color: #ff0000 !important;
color: #ffffff !important;
font-size: 15px !important;
}