Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to split the following table into a more readable format in the load statement.
From this
Area | Post Sectors |
A | ['PE33 0', 'PE33 9', 'PE34 3'] |
B | ['NG13 0', 'NG13 9', 'NG23 5', 'NG24 4'] |
To this
Area | Post Sectors |
A | PE33 0 |
A | PE33 9 |
A | PE34 3 |
B | NG13 0 |
B | NG13 9 |
B | NG23 5 |
B | NG24 4 |
Any ideas please?
Hello everyone.
I have a question.
is it possible to sort the view on the start page of the QMC.
When I open the QMC i always need to scroll down to open a tasks (see picture).
I want to know if it is possible to sort this view, so the most interested views are always o top top of the list.
I 've tried to use special caracters for the name (like #, _) but this doesn't helps.
Anyone know if this is possible or not?
Greetings!
I just saw this article about a supposed ransomware security risk in QliK Sense and would like to receive instructions on what to do (if true):
https://www.arcticwolf.com/resources/blog/qlik-sense-exploited-in-cactus-ransomware-campaign/
Customers are asking us about it, but I can't find anything related to this issue in the community. Please advise and referer to @diagonjope in your note, so that I can get a notification.
Cheers,
++José
Hi, this has been driving me nuts and wondered if anyone would be able to help.
So I have 2 tables, the first is in a table chart on a sheet, and I need to retrieve 2 fields from the 2nd one using set analysis:
Field 1 | Field 2 | Field 3 | Analysis 1 | Analysis 2 |
1 | A | V | ||
2 | B | W | ||
3 | C | X | ||
4 | D | Y | ||
5 | E | Z |
Field 1 | Field 4 | Field 5 | Field 6 |
1 | AAA | 01/01/2024 | Op1 |
1 | BBB | 01/02/2024 | Op2 |
1 | AAA | 01/03/2024 | Op2 |
2 | BBB | 01/04/2024 | Op1 |
2 | AAA | 01/05/2024 | Op3 |
2 | BBB | 01/06/2024 | Op4 |
In the first table for Analysis 1, I have the following at it works great to retrieve the max date value:
=MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))
In Analysis 2, I need the corresponding Field 6 that matches the Max Date.
My latest attempt was to use this as a nested set analysis without aggregation, but it returns blanks for all records:
ONLY( {$< [Field 5] = {"MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))"}>} [Field 6])
Hi all,
1. I created a sheet with a one table object
2. End users have bookmarks with "Save layout" checked on top of that sheet with reordered fields in table and some filters applied
3. I added a new field to that table and published it
4. When they apply bookmark, filters and the sorting of fields is applied correctly, but what I see as a problem is that the newly added field disappears from the table.
In other words, end users see a new field in the table until mentioned bookmark is applied. I tried this also on the cloud, where it is the same. Is this intended behavior or a bug? Thanks in advance for the answer.
I am trying to download data from hubspot
loop is not getting all only first set
every time i need to pass output value to URL using this variable (vRowCount)
i test with postman
Hello NPrinting Community!
Please check out this Blog post and article as soon as possible if you are considering upgrading QlikView to 12. 8 track.
Kind regards...
Hi All.
Having done some research I suspect I cannot get to what I want to achieve here, but this community has been great at helping so here goes.
I want to produce a table which is formatted in a more grouped manner (similar to a Pivot Table maybe), but rather than showing measures in the columns I need to show Dimensions - see example:
Category & Control | In Scope | Implemented | Evidenced | Evidence Description |
Asset Management | ||||
- Asset Ownership | Y | Y | Y | Policy Document |
- Return of Assets | Y | N | ||
- Inventory of Assets | N | |||
People Controls | ||||
- Employee Screening | Y | Y | Y | HR File Records |
In my ideal output rows would be grouped by the Category with the 'Controls' grouped by category (e.g. - Asset Ownership).
Is there functionality in Qlik to do this, or if not are you aware of a extention which might help?
Thanks once again.
Mark.
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"
]
}
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!