Hi All,

I not familiar in Qliksense and need help on below logic.
basically i have populate 'Difference' column in table (not in report). To find the 'Sales difference' by calculating Today's 'Sales Amount' minus Yesterday's
'Sales Amount' to generate the column 'Difference' as attached in data table. and it has to be by
SaleID, Desc, Reported Date and Sale Date. for more details please find the attached sample data excel. where it has excel formula to populate 'Difference' column.

Thanks & Regards
Loga

Hello

I have NPriting and Qlik Sense OnPremise version Avril 2024

I can create onDemand report from my Qlik sense app. Excel file successfully created, link to export and delete appeared but these 2 buttons are inactive

My account has admin rights in Sense and NPrinting

Could you help me please ?

Regards

Hi, I am in the middle of a migration from Sense Enterprise to Saas, and I have a problem with the
max string length. The field contains on average 30K characters, reaching a peak of 66K, there is a solution for this.
I am using the Oracle connector, via wallet

Hello everyone,

Count({$<Date={'09/30/2019','09/30/2020','09/30/2021','09/30/2022','09/30/2023',"$(=Date(Date#(Today(),'M/DD/YYYY'),'MM/DD/YYYY'))"}>}distinct Sales)

I wrote this set analysis to resolve [show sale for past 5 years + running current year]

Is it possible to make past years dynamic as well so that on 30 Sept 2024 09/30/2023 -> becomes 09/30/2024 and other previous year respectively? Or should I put current year on another sheet?

FYI: My DIMENSION IS A "YEAR" FIELD.

If you have an idea please help. 

Thank you

Hi there,

I'm new to Automations and a novice Qlik developer - I'm looking to move data from a Straight Table I've built to an SFTP. I've got a test up, and can see data being moved, but I have two problems.

1. Instead of sending the full table, it's sending each row as its own file.

2. I'm using a comma to delimit things, but there's commas in the values of the table, and so it's splitting the values in an unusual way. 

I'm attaching an excel workbook with three tabs. The first has an image of the Automation flow I'm using. The second has an image of the (very simple) two row table. The next two tabs are the output in the SFTP.

Does anyone have any tips here? I'm sure the solution is fairly simple but I'm missing something. Screenshots below as well. We are using Qlik Cloud

Thanks,

David

We recently migrated QS to a new server and domain. It's running QS Feb 2024 r6. We installed a GoDaddy SSL cert, and everything was working fine. This morning, my browser said that the cert is revoked. GoDaddy's website shows that to be true. (In that situation, you can't bypass the warning and log in, so it's BAD.)

The only changes to the server yesterday:

1. I added an encryption key to Qlik for a SharePoint connector (using QvWebStorageProviderConnectorPackage.exe).

2. Windows installed security updates to the Microsoft Access Database driver.

I've uninstalled the security updates, and now my browser (on the network with Qlik) shows a valid cert and I can get into Qlik, but not from any other location! Not even on the Qlik server itself. 

What is going on??

Olá.
Venho pedir ajudar para apresentar em uma consulta, numa mesma tabela (mesmo grid), o cálculo de um percentual sendo os dados estruturados da seguinte forma:
Diretoria, Empregado, Salário do Empregado.

Cálculos Desejados, para serem apresentados no mesmo quadro:
Empregado, Salário do Empregado, Total geral, total por Diretoria, %Salario/Total Geral e %Empregado/Diretoria.
 

As June is coming to a close (or more like a grinding halt! Where did the time go??), I reflect on an amazing month of firsts, milestones, celebrations, and special events. I would like to share a few of them with you.

- Releasing my first book!
- Riding Kong and Velocicoaster with some of my WWQ favs!!
- All things related to the kickoff at Qlik Connect of #WomenWhoQlik. What an amazing job by all involved who brought this dream to life!
- Opportunity of a lifetime to work in Munich for the summer
- Dream vacation with my family to celebrate so many amazing milestones

I could go on and on, but suffice it to say that I am truly lucky and content with so many amazing memories from June. Grateful. Thankful. Blessed.

I would love to hear more stories from the #WWQ community. Could we even start with a simple introduction? Would you be willing to give a brief intro or share a few fun facts about yourself with the group?

I'll get us started...

1. I began working with QlikView 7 in 2007.
2. I bought a personal QV desktop license in 2011 so I could use QV at home/personally! (did I mention I bleed green??!!)
3. I built a personal use, registration and scoring system in QlikView to organize and score dance competitions.

I am looking forward to hearing your stories!

Best,
Gwen

Below is a picture of what is currently happening with my pivot table. I created a field called Week Start Date that I made with the calculation:

weekstart(report_date)

Is there a way to get that formula to work for just 2023 or just 2024 so that I can have the week start dates beside the week number column to indicate what the starting day for the week was in 2023 and in 2024 without creating two rows?