Hi,

I have a requirement to show the sales for Group, ItemCategory wise monthly data in pivot table.

I could easily do for the actual sales. Where as  i have to calculate for feature year month's  based on Last fiscal yea's value (2025/03).

In the above figure i have to consider the value of 2025/05 for the Year month 2027/04.

Is there any feasibility to get the value of previous Year Months data 

I know i can use Before(Column(index)), But i need a solution without Column(Index).Because i need to show the correct value even the user selects any year month ,If i use column index it wont work.

Thanks,

John.

We are currently facing an issue with the Area Map in Qlik Sense. We have checked both the Area Map and Point Map functionalities:

• The Point Map is working as expected.
• The Area Map is not working.

This issue is occurring both in Qlik Sense Desktop and Qlik Sense hub.

Since the Area Map is required, could you please check and share the RCA from your side at your convenience?

Please let us know if you need any additional information from our side.

Hello,

I'm no set analysis expert and I'm struggling to find a solution to this problem, so here I am!

I have a dataset with duplicate values. My dataset has a PersonId and a RelationshipType, each PersonId can have multiple, different RelationshipTypes. Let's say my table is as follows:

I want a visualisation to return these results - i.e., only counting each person once and excluding duplicates, returning the first RelationshipType, sorted on PersonId:

I'm more than comfortable with Count (DISTINCT PersonId), which returns the unique count of PersonId, so the total displays the correct number when combined with RelationshipType, however, understandably, I currently get this:

Is there some set analysis statement to achieve this? I've tried so many combinations of functions and syntax but with no luck and I'm starting to feel like I'm banging my head up against a brick wall!

PS - my dataset is around 400,000 records per month and contains over 50 variables, but this is a simplified version! I also need the duplicates for every other visualisation in my app, so I can't remove them in the data load.

Thanks in advance!
Jen

We work with Qliksense On Preim in the three-tier model (Load data, schema, application)
How do you implement in the cloud?
As I understand it, there are 3 types of spaces:
Shared, managed, data

Shared – development environment

Managed – publishing to customers

Data – data creation and storage

Personal – personal environment, parallel to work

Our architecture:
load data - shared space
Schema – shared space
Qvd files, excels and all data files – data space
Applications – managed spaces

Is this the right way?
And do you create shared, Data and managed spaces for each environment (dev, test, prod)

i have put properties "spark.driver.extraJavaOptions", "spark.executor.extraJavaOptions" and JVM Arguments with this 

--add-opens=java.base/java.nio=ALL-UNNAMED
--add-opens=java.base/java.lang=ALL-UNNAMED
--add-opens=java.base/java.util=ALL-UNNAMED
--add-opens=java.base/java.lang.invoke=ALL-UNNAMED
--add-opens java.base/java.net=ALL-UNNAMED
--add-opens=java.base/sun.nio.ch=ALL-UNNAMED

but job still error

Hello All,

I am looking to run stored procedure script(DB Impala) from Qlik Sense On-Prem environment using Shell Script or Bat file or any other mode and post that show the data in Qlik Sense UI. 

Is there any way or solution to achieve this? 

#!/bin/bash

# -----------------------------

# Impala Connection Details

# -----------------------------

#IMPALA_HOST="impala-hostname"

#IMPALA_PORT="21000"

DATABASE="kan_adhoc"

impala_cli="impala-shell -i kancdhdatap6.kanhadoopprd.net -d default -k --ssl"

# -----------------------------

# Impala CREATE TABLE

# -----------------------------

SQL_QUERY1="DROP TABLE IF EXISTS ${DATABASE}.aca_type;"

SQL_QUERY="CREATE TABLE IF NOT EXISTS ${DATABASE}.aca_type as select * from kan_ref.aca_type ;"

# -----------------------------

# Execute Query

# -----------------------------

#impala-shell \  -i ${IMPALA_HOST}:${IMPALA_PORT} \  -q "${SQL_QUERY}"

  $impala_cli -q "${SQL_QUERY1}"

  $impala_cli -q "${SQL_QUERY}"

# -----------------------------

# Status Check

# -----------------------------

if [ $? -eq 0 ]; then

  echo "✅ Table created successfully in Impala."

else

  echo "❌ Failed to create table in Impala."

  exit 1

fi

Hi team,

I tried to set up this LLM but currently, to make the test with Swagger on Power Automate to authorize the OAuth session, it indicates that the redirect URI is not registered, and I made this in the before steps.

Some have the same problem or know other steps to work with Qlik Cloud MCP and Copilot.

Thanks