Hello Qlik community,

I am struggling a bit with a data transformation I need to perform.

I have a table like this one

What I need to get is this table below with a new field Period 

I've tried something like that but it is not working as it is ignoring the change of division/service

LET vMaxDate =num(monthstart(today()));

LOAD distinct

start_date,
division,
service,
DATE(MonthStart(start_date+ IterNo() - 1),'YYYYMM') AS Period,
ID
FROM [lib://AttachedFiles/Classeur1.xlsx]
(ooxml, embedded labels, table is Feuil1)
WHILE start_date+ IterNo() - 1 < $(vMaxDate);

I am missing something here but can't figure it out.

Thanks for any help !

IndiaMatch would be favorable for fans who want to follow sports's up-to-the-second progressive updates but aren't always technologically able! You cant work, or commuting or millions of times access to match info I would be happy to be near customer onsite updates, mapping every ball from detailed accurate ball-by-ball coverage, with milestones and stats on all the notable moments. Fans can feel engaged with Team India's connectedness to a moment without it going up on a half-baked screen or on-demand media.

Hello,

In Qlik Cloud, how can I test the Access section with scope reduction?

Is it possible to simulate the display for a specific user? 

(I'd like to avoid app reload between each test)

Regards

Hi Folks,

Hope you're doing well !!

I came across one of the requiremnet where we need to show all measures value in descending order in pivot table of qliksense.

Is there a way to do customize sorting of pivot tables in Qlik sense so that measures should show in descending order, I have tried both sort by first measure and sort by expression but still lagging to get this.

Regards,

KK

Hi guys, we have a very special problem for the dedectives among us 🙂

We installed Qlik Sense Enterprise on a VM using the CNAME qlik-dev.ad.ourdomain.de. Everything lookes fine after installation. Services are running under the service account. Ports are open, Qliks certificates are correct.

When using localhost/qmc or hub, logged in with the service account, everything works fine but no authentication window appears.

When using qlik-dev.ad.ourdomain.de/qmc or hub or even localhost in incognito mode the windows authentication window appers but after entering the correct user/password the attached ERR_UNEXPECTED appears.

Has anyone of you experienced a problem like that?

Kind regards, Andy

Qlik Sense Enterprise on Windows 

Morning All,

I have the following table appearing on the preview page of my app. I've not deliberately generated this and it doesn't connect to my data in any way. It also appears to not be causing any problems.

• Has anyone seen this behaviour before?
• Does anyone have any ideas what's causing it and how to fix it?
• Am I right in thinking that there's no negative impact? (other than unsightliness / confusion)

The source is Snowflake. App is in Qlik Cloud Analytics.

Thanks in advance.

Hi! 

I have a straight table in QLik Sense and I built such table in QlikNprinting and then form it I wanted to built pivot table.
I changed headers to be blue but values columns does not keep that color:

but when data is added:

here are my settings:

keep source format also turned off for columns.
how can i make it work?

Qlik NPrinting February 2024 SR3

Version: 24.4.14.0

Qlik Sense Enterprise on Windows 

Is it safe to delete logs from this folder C:\ProgramData\Qlik\Sense\Log\CapabilityService 

Both old and new.

And why some logs are of 32 GBs 

@Damien_V @Bastien_Laugiero