Hello,

I've tried to generate a mail with 6 reports (using the Reporting option in Qlik Cloud working with the Excel Add-in).

When I send it to one users, the number of reports is incremented +6 (which seems OK)

When I send it to 4 users (including an external user), the number increment +12. I don't understand it 🙂 
Can someone explains me how it works ? 

Regards

Hello Qlik Community,

I am fairly new to utilizing Qlik and this is my second posting. I will do my best to ask my question. 

We have developed a stacked bar chart:

The Stack Dimension = "Admission Program"

The Bars Dimension = "Progress Note (New).Language in which service was provided Value"

The Alternative Dimension = "Progress Note (New).If patients preferred language is NOT English, we Value"

And the Length of Bars Measure = "Count([Progress Note (New).ID])"

The percentage that the stacked bar is showing is the percentage of a particular language chosen in a progress note for an Admission Program against the total number of progress notes for all Admission Programs. (e.g. 3 progress notes had Chinese chosen as the language for Recovery Inc and the total progress notes for ALL providers is 100 the percentage shown for Recovery Inc is 3/100)

However, we want the denominator NOT to be the total number of progress notes, but rather the total # of progress notes only for that particular Admission Program (e.g. 3 progress notes had Chinese chosen as the language for Recovery Inc and the total progress notes for Recovery Inc is 25 then we want the percentage shown to be 3/25)

I have found a way to do this by choosing Modifier, Selection Scope, Current Selection

Is there any way to do this by hard coding it (e.g. putting something into the Length of Bars Measure expression "Count([Progress Note (New).ID])") so the user doesn't have to choose an Admission program to make the stacked bar chart show the percentages we want?

In other words, is there way to have the stacked bar chart show percentages of progress notes with a particular chosen language hard coded by Admission Program not by the total of all Admission Programs?

Thank you.

For each of the following NPrinting vulnerabilities, can you please advise if you recognise the vulnerability and if it has been remediated and if so in which release. If not, would you please advise if/when you plan to release the fix/upgrade.

1. Spreadsheet Formula Injection

The application allows users to import report templates as spreadsheets in XLSX format, but fails to adequately sanitise the contents. By supplying spreadsheet data beginning with '=','@', '-' or '+', attackers could inject malicious formulae which will execute when the resulting file is opened. Using a maliciously crafted formula, an attacker could inject a Dynamic Data Exchange (DDE) formula that compromises the computer of anyone who views it in Microsoft Excel. This attack triggers a warning message from Excel, but users may trust that documents created using the application are safe to handle.

2. Overly Permissive Cross-Origin Resource Sharing Configuration

The application is configured to allow HTML5 Cross-Origin Resource Sharing (CORS) requests from any domain, as it returns an "Access-Control-Allow-Origin" header containing the value of the "Origin" header sent in the request. By default, web browsers implement a "same-origin" policy, meaning client-side content, such as JavaScript can only interact with the domain on which it is running. A CORS policy is used to allow fine-grained control of whether and how content on other domains can interact with the domain that publishes it. Permitting arbitrary origins to interact with the application effectively disables the same-origin policy, allowing two-way interaction by third-party websites; which could allow an attacker to proxy malicious web requests via user's web browsers, masking the origin of an attack. As the application also specifies the "Access-Control-Allow-Credentials: true" header, third-party sites may be able to carry out privileged actions and retrieve sensitive information.

3. End-of-Life JavaScript Library in Use

The application uses a third-party JavaScript library (bootstrap v3.4.1) which is no longer supported. Libraries which are no longer supported or maintained do not receive security patches. Therefore, it will not be possible to resolve vulnerabilities that are identified after the discontinuation date. There are currently no known vulnerabilities for the identified library version.

Hi everyone,

I'm building charts for Month over Month data, but I'm having some issues getting it to work right. Below are snippets of my chart, the first is the default appearance, the second is when I select the month of March. It should show me March 2025 and Feb 2025, but it won't. Below the images is the current set analysis I have in my expressions:

Default, shows current month and previous monthWhen I select March, it does not show me current (selected) month and previous month

Current Year, Current Month: (works fine)
{$<Year={$(=If(GetSelectedCount(Year) > 0, Concat(DISTINCT Year, ','), year(date(today()))))},
Month={$(=If(GetSelectedCount(Month) > 0, Concat(DISTINCT Month, ','), month(date(today()))))}

Current Year, Previous Month: (Works on default, but not when filtered/selected)
{$<Year={$(=If(GetSelectedCount(Year) > 0, Concat(DISTINCT Year, ','), year(date(AddMonths(today(), -1)))))},
Month={$(=If(GetSelectedCount(Month) > 0, Concat(DISTINCT Month, ','), month(date(AddMonths(today(), -1)))))}

Any help would be greatly appreciated! Thanks in advance!!

Hi,

I have few sheets in my test app. I have selected Organization name xyz  or ABC and navigating to next sheet the sheet label is coming down. Previously, have May 2022 version don't see any issue.

Before - Correct one

After upgrade - There is any extra space in the header and the sheet label is going down.

Our client has requested to change security on data to include multiple levels - which corresponds to the fields in Product Dimension.

Product Dimension has multiple fields, including ID1,ID2,ID3. Our current security is on ID1 only. The request is to change it so different combinations of access based on these 3 columns can be done. For instance:

1. client A should have access to ID1 = 100 and all ID values within ID2 and ID3
2. client B should have access to ID1 = 100 and ID2 = 200 and all ID3 values
3. client C should have access to ID1 = 100 and ID2 = 200 and ID3 = 300

I have created section access table that looks like below and tried testing ClientC access, but getting Access Denied message. Is there a limitation in Qlik that section access cannot be created on multiple fields w/n the same dimension (except only when those multiple fields are concatenated into 1 field)

In our process, we only get ID (or IDS) to be used for security. For instance, Client A was provided with ID1 = 100, which implied that all values available under ID2 and ID3 need to be accessible.

These IDs (especially ID2 and ID3) are not static and new IDs can be added at any time. How do I account for such setup to ensure that access is granted on different combinations of these IDs?

In my previous Post I asked and was given support (thank you so much for that) on how to move our QSR database over to the new PostgreSQL 16 version, but I it still didn't seem to am unsure how to move the other 3 databases...

1. Should I back up and import the "SenseServices" database also? (It sounds like - based on what it is - I should do)
   
   
2. Do I need to do anything with the "Licenses" database? (because it's on the same server, it doesn't look like I do)
   
   
3. Do I need to do anything to the "QSMQ" database? (as it doesn't hold anything that would need to be historically referenced, it doesn't look like I do)

Thank you very much

I have a simple table that has 4 dimensions and a Rank function that is simply "Rank(TOTAL MASTER_MEASURE)". How do I get QLIK to show me the top 5 records only? 

Sample output table: 

Dim1  Dim2 Dim3 Dim4 Dim5 Rank

Record 1   x x x x          1                                     

Record 2   x x x x          2                                     

Record 2   x x x x          3                                     

Record 2   x x x x          4

Record 2   x x x x          5