I am trying to create sales info for a customizable "Current Period" and "Prior Period" setup similar to what is in our company's ERP.

I used the same field INVOICE_DATE.autocalendar.YearMonth and created two filters with alternate states for each period.

While that does work on the surface, it feels really limiting because I cannot seem to filter down any dimension field. I am using a pivot table format, and I cannot seem to filter down to one specific customer or product family or sales rep or anything. 

Is there a way around this, or is this just inherent to Alt States in QLIK?

THX! 

Using Qlik Cloud and want to be able to globally change the default variable (not have to change it in every load script) for

Set DateFormat that auto populates the MAIN section in the Data Load Editor when creating new APPs.

Currently

SET DateFormat='D/MM/YYYY'

Preferred it to be

SET DateFormat='DD/MM/YYYY'

Also would prefer to change the FirstWeekDay 

Currently we have to change this for every new APP that is created, but if one of our APP builders forget to change this we get different formats and first day of week in different APPs that impacts our users.

Hi Support,

We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
"[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "

We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.

Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.

This instance of Enterprise Manager is v2023.11.0.259

Thanks,

Nak

How do I keep two tables separately when uploaded?  Each table is a separate Excel file (Feb.xls and March.xls).  Row heading and columns are the same on both files except data are different (production numbers).  I created a new App.  Then uploaded two separate files.  But both gets combined into one table once uploaded.  Instead of seeing two Bubbles, I see one Bubble in Data manager (as shown below). I would like to see each table separately with two Bubbles in a Data Manager. One for Feb and one for March.  Thank you.   

Hi qlik community,

Could you please confirm whether we need separate licenses for configuring the high availability environments for Qlik Replicate, Talend (TAC + Job Server), and Qlik NPrinting?

Regards,

Nilesh

Hello...

I'm trying to publish an app from a shared space to a managed space.

Using, Rest, Qlik CLI, and Qlik SDK I'm getting the same 404 error. I created an automation and that worked okay.

When I go to the URL for the app its fine, I return the json. Same if I look at /scripts, that works fine too

However when I look at 

https://xxxxxxx.us.qlikcloud.com/api/v1/apps/73b24e00-bf66-4228-8065-44d55eb5ba7b/publish

I get a 404 error, which is the same error all the API are returning.

Everything else seems to be working fine, does anyone know why there's a 404 on this page?

qlik app publish create 73b24e00-bf66-4228-8065-44d55eb5ba7b --spaceId="66311b85b13342805b11e332" -v

Response time: 643ms
Status: 404 Not Found
Error: 404 - Not Found (empty response)

Space details:

"createdAt": "2024-04-30T16:25:41.937Z",
"createdBy": "6580520ea968030de1483f82",
"description": "",
"id": "66311b85b13342805b11e332",
"meta": {
"actions": [
"change_owner",
"create",
"delete",
"read",
"update"
],
"assignableRoles": [
"basicconsumer",
"consumer",
"contributor",
"dataconsumer",
"facilitator",
"operator",
"publisher"
],
"roles": []
},
"name": "Managed",
"ownerId": "6580520ea968030de1483f82",
"tenantId": "xxxxxxxxxxxxxxxxxxxxxxxx",
"type": "managed",
"updatedAt": "2024-04-30T16:25:41.937Z"
}

Application details

{
"attributes": {
"_resourcetype": "app",
"createdDate": "2024-04-30T15:57:28.367Z",
"custom": {},
"description": "XXXXX",
"dynamicColor": "",
"encrypted": true,
"hasSectionAccess": false,
"id": "73b24e00-bf66-4228-8065-44d55eb5ba7b",
"isDirectQueryMode": false,
"lastReloadTime": "2024-04-30T17:03:42.230Z",
"modifiedDate": "2024-04-30T17:03:43.153Z",
"name": "Data Gateway",
"originAppId": "",
"owner": "",
"ownerId": "6580520ea968030de1483f82",
"publishTime": "",
"published": false,
"spaceId": "66311ae57c1e52122254af4d",
"thumbnail": "",
"usage": "ANALYTICS"
},
"create": [
{
"canCreate": true,
"resource": "sheet"
},
{
"canCreate": true,
"resource": "bookmark"
},
{
"canCreate": true,
"resource": "snapshot"
},
{
"canCreate": true,
"resource": "story"
},
{
"canCreate": true,
"resource": "dimension"
},
{
"canCreate": true,
"resource": "measure"
},
{
"canCreate": true,
"resource": "masterobject"
},
{
"canCreate": true,
"resource": "variable"
}
],
"privileges": [
"read",
"update",
"delete",
"export",
"change_owner",
"export_reduced"
]
}