Hola a todos.

Necesito su ayuda con un problema que estoy presentando en mi servidor de Qlik Sense.

En varios momentos, el servidor llega a utilizar hasta el 99% de la memoria RAM, lo que afecta el rendimiento de la plataforma. Sin embargo, al revisar las tareas, no hay ninguna recarga de aplicaciones en ejecución que justifique ese consumo de memoria.
Ya revisé el QMC y no encuentro procesos de recarga activos en ese momento. ¿Alguien ha tenido un caso similar? ¿Qué servicios, procesos o registros me recomiendan revisar para identificar qué está consumiendo la memoria?

Cualquier sugerencia o experiencia será de gran ayuda.

¡Muchas gracias!

Hi,

I am facing a weird issue. One of my apps produces very high CPU usage and is almost not usable anymore. I found that this issue is often related to a broken *.tshared file. I deleted that file and everything runs smooth again.

My problem is, that this only lasts for a +- a day. Then the problem is back and I can solve it again by deleting *.tshared.

Is this a known issue? Is there a solution for this? We have already updated to the latest QlikView version.

1. Hi all,

   I have a Qlik Replicate task (Full Load only, Oracle → BigQuery) on 2 tables (Table A and Table B). I want to filter only "yesterday's" data on a date column.

   Attempt 1: filter as an expression

    

   date($DAT_RIFERIMENTO) = date('now', 'localtime', '-1 day')

   This doesn't push down to Oracle (stays on the transformation side), so it scans the whole table (billions of rows) and after a few hours crashes with:

    

   ORA-08103: object no longer exists

   Attempt 2: rewrote it as a range

    

   $DAT_RIFERIMENTO >= date('now', 'localtime', '-1 day') AND $DAT_RIFERIMENTO < date('now', 'localtime')

   This time it does push down, but the generated query toward Oracle is wrong:

    

   sql

   WHERE ("DAT_RIFERIMENTO" = TO_DATE('0000-00-00','YYYY-MM-DD')) OR ... (repeated 3 times)

   → ORA-01843: not a valid month

   Questions:

   1. Has anyone hit this translation bug with date('now',...) in the source filter pushdown toward Oracle?
   2. What's the correct way to write a relative date filter that translates properly into TO_DATE()?
      
      

   Thanks!

Hi everyone,

I'm new to this community, so I hope this is the right place to ask.

I'm currently learning programming and am looking for a reliable AI coding assistant that can help me write, understand, and debug code. Since I'm still a beginner, I'd prefer a tool that's easy to use and can explain concepts, suggest code improvements, and help fix errors.

If you've used any AI coding assistants that you'd recommend, I'd really appreciate your suggestions and experiences.

Thank you in advance!

Hi ,

Can anyone please share the following:

White Paper - QlikView Metadata Management.pdf  or any information regarding Metadata

Regards,

Gargi                                       

Hello Everyone, 
I am working through the Qlik Learn for Talend. I am on the very first lesson / lab and I am just not being able to make progress. I am getting an error concerning Escape Sequences. I am not sure how to fix this. I have tried EVERYTHING I can think of. Please help! 

I have the full error below. I have the screenshot of my settings below that. Thank you for the advice - 

Preview Error!
Null value will be used for context parameter Number: For input string: ""
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )

at dibasics.preview_data.Preview_Data.tFileInputDelimited_1Process(Preview_Data.java:1772)
at dibasics.preview_data.Preview_Data.runJobInTOS(Preview_Data.java:3243)
at dibasics.preview_data.Preview_Data.main(Preview_Data.java:2913)

Null value will be used for context parameter Number: For input string: ""
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )

at dibasics.preview_data.Preview_Data.tFileInputFullRow_1Process(Preview_Data.java:1071)
at dibasics.preview_data.Preview_Data.runJobInTOS(Preview_Data.java:2190)
at dibasics.preview_data.Preview_Data.main(Preview_Data.java:1860)

Hi, 

I'm trying to use section access on more than one table, with one table requiring row-level filtering and the other requiring column-level. Both work well independently, but when I have both section access statements in my script, they seem to interact and I see synthetic keys being created on fields like ACCESS, USER.EMAIL, and GROUP during the load. My understanding was that the section access tables don't persist after the section application is loaded, but they definitely seem to be interacting in some way. Does anyone have suggestions? A bit of sample code is below:

SECTION ACCESS;
Load * INLINE [
ACCESS, USER.EMAIL, GROUP, REDUCTION
ADMIN, xx@xx.com, *, *
USER, *, a, a ];


Section Application;
[Table1]:
LOAD * from [table1.qvd](qvd);

SECTION ACCESS;
Load * INLINE [
ACCESS, USER.EMAIL, GROUP, REDUCTION, OMIT
ADMIN, xx@xx.com, *, *,
USER, *, a, *, b];

Section Application;
[Table2]:
LOAD * from [table2.qvd](qvd);

Hi Everyone,

I am facing a behavior difference in a Qlik Sense stacked bar chart and would like to understand whether this is expected behavior or if there is a better way to handle it.

Scenario:

I have a stacked bar chart where percentages are calculated by judgement categories (〇 / △ / × / ★).

For example, in one H2 bar:

〇 = 38%
△ = 13%
× = 25%
★ = 25%

Case 1:
When I select ★ from the straight table (Month data), the bar chart still shows ★ as 25%.

Case 2:
When I select the ★ stack directly from the bar chart, the chart shows ★ as 100%.

The product count remains the same in both cases, but the percentage displayed is different.

Current data model:

- H2 / Annual / Recent3 bars are calculated from a Period dataset.
- The straight table is built from a Month dataset.
- The chart percentage is calculated as:

My questions are:

1. Is this difference expected because the table selection and chart stack selection are applied differently in Qlik Sense?
2. When selecting a judgement from a table, should the denominator normally remain the total H2 population, resulting in 25%?
3. If users expect the selected category to become 100% regardless of whether the selection comes from the table or the chart, what would be the recommended approach?

Hi Everyone

I have an app with two feedback datasets — teacher feedback (TeachersResponse) and student feedback (StudentsResponse). The requirement is to restrict educators to see only their own feedback data across both sheets. Below is my data model

The teacher feedback uses T_InstructorName and student feedback uses S_InstructorName — both contain the same educator name values but are intentionally kept separate as they serve different sheets.

Since Section Access only supports one reduction field, I created SA_INSTRUCTORNAME (uppercase as required) and placed it in TeachersRatingBridge which associates to TeachersResponse via T_InstructorName:

Section Access;
LOAD * INLINE [
ACCESS, USERID, SA_INSTRUCTORNAME
ADMIN, DOMAIN\ADMIN, *
USER, DOMAIN\EDUCATOR1, 20_MR_LI
];
Section Application;

// SA_INSTRUCTORNAME added to TeachersRatingBridge only
TeachersRatingBridge:
LOAD
T_InstructorName,
UPPER(T_InstructorName) AS SA_INSTRUCTORNAME,
...
Resident TeachersRatingTable;

The reduction is not cascading. The restricted user still sees all 22 distinct T_InstructorName values and 23 distinct SA_INSTRUCTORNAME values — confirming no filtering is applied at all.

Placing SA_INSTRUCTORNAME in both RatingBridge and TeachersRatingBridge causes a circular reference. Placing it in LinkTable (which bridges both tables via Student_TeacherKey) does not filter the fact tables. Placing it directly in TeachersResponse and StudentsResponse causes synthetic keys.

What is the correct placement of the reduction field SA_INSTRUCTORNAME in this data model to ensure Section Access filters both TeachersResponse and StudentsResponse without causing circular references or synthetic keys?

Any guidance is appreciated. Thanks.

Qlik Sense Enterprise on Windows