Qlik Community Contest

Hi, I'm having a hard time trying to display a floor plan in a map object. Basically I want to show the floor plan and then build some shp or kml in QGIS to plot over the image and have selectable areas, etc.

The expected output would be something like this:

I'm just very lost. I found and followed multiple tutorials, but most of them is using Qlik Desktop and I'm on SaaS. They are also from 6-8 years ago, so it's probably different now, there are new connectors, etc.

My main struggle is showing the image. The image has 1920x1080px, so I've set it like this (saw it in a post):

I've set the map to use "none" as base and "user defined meters" as projection. I made it work a couple times, but I'm assuming the image is too small comparing to the "base" map. I guess I just lost the image in the map and the "home" button doesn't even click, it's just grayed out. I've managed to display it and then started trying to add the area layer, but the map then moves/zooms and I guess I lose the image somewhere.

I'm pretty sure this is possible I'm just getting crazy, please help.

How can I have a big enough image over the map so I don't "lose" it around?

How can I match the area layer coordinates to the image?

PS: I've attached the image and the KML in case an angel would be willing to share a qvf

Anyone have luck getting the Qlik Mobile App to generate a CSRF API call successfully? Seeing no issues using the call on desktop and mobile browser but when using the Qlik Mobile App, the CSRF call doesn't return a token. 

I submitted a support ticket but it was suggested to post here as well.

Buenas a todos,

Estoy intentando averiguar el codigo para conseguir el numero de repeticiones que hay para un valor desde el primer dia del año hasta el dia filtrado 

He utilizado este codigo 

Esto es para el dia seleccionado hasta final de año actual:

RangeSum(
    Above(
        Count(
            DISTINCT 
            {< 
                CanonicalDate = {">=$(=Only({[Canonical Date 1]} CanonicalDate)) <=$(=MakeDate(Year(Only({[Canonical Date 1]} CanonicalDate)), 12, 31))"},
                datetypeyear = {'leftyear'}
            >} 
            person_id
        ),
        0, RowNo()
    )
)

 Resultado 

Esto es desde el primer dia del año hasta la fecha seleccionada:

RangeSum(
    Above(
        Count(
            DISTINCT 
            {< 
                CanonicalDate = {">=$(=MakeDate(Year(Only({[Canonical Date 1]} CanonicalDate)), 1, 1)) <= $(=Only({[Canonical Date 1]} CanonicalDate))"},
                datetypeyear = {'leftyear'}
            >} 
            person_id
        ),
        0, RowNo()
    )
)

Este es el resultado: 

Como veis se pasa de los datos de termination, llegando a pasar el dia seleccionado 

Saludos y muchas gracias

Hey, We've just upgraded to Studio v8 and have republished all our existing jobs. They have all published and ran in the cloud successfully except for 1 job. For this job, the publish process completes with the success message but there is nothing in TMC or on the server so it hasn't worked, however, there are no errors or warnings anywhere. Furthermore this job runs fine locally in studio and i can do a build to my local machine again, without any errors so something is going wrong on the journey to the cloud.

Any ideas?

Studio 8 R2024-11v2

Thanks

Hi, I have Qlik Nprinting (May 2021 SR2 Version: 21.14.5.0)

I want to make a report per week, so each sheet has a separate week number, and in there is a pivot table with data for that week.

Sheet per week I make by levles -> its ok

after:

I make a pivot table based on a normal table from Qlik  -> its ok

My table is made like this, unfortunately after refreshing, it is not consistent with the expected result, I wanted the weekend number to be in B1.

How can I fix it?
before

after

Hi

How do I formulate the order I specified in the table below?

I have two REST API connections set up. In the first one, I retrieve a token, and in the second, I send a message. The issue is that the token is dynamic, and I haven't been able to create the second connection, even as a generic one, to modify it later in the code. In Python, it works fine because it's a single operation.

We have a schedule setting running fine in production. However in non production, we run the same setup under Server --> Schedule. The task never gets run at all even after 24 hours as we set it to run daily.

I noticed the server time is out of sync with our replicate server time. Is there a way to fix this?

Under edit schedule job screen, the server local time always appear as :03:36. It seem to stuck there.

Thank you.
Desmond