Dear Experts,

We are planning to create our own theme for our all the dashboards so we need to create our own KPI logo's, sheet background images, charts background images, text box images, icons etc.

Is there any standard dimensions of the pictures, images, icons, logos we need to consider so that our designer department will consider them while creating..

Hi Team,

I have Qlik sense app Home Page. Here different navigation buttons are there. 

Some users are not visible to some navigation buttons.

Ex: I have 10 navigation buttons. 

2 Users are only visible 2 Navigation button, remaining buttons are grade out and, If click the that grade buttons it won't navigate.

How will you do this one. Please help me.

Thanks Advance.

Regards,

Ram 

Hi all,

all my data in my system database are stored in the UTC format. When I import it to Qlik I can use convert to local time function, but on top of this I need to shift the time by few hours as the customer expects the "daily" reports from 8am to 8am next day. Is there a function to shift it by hours? 

Hello,

I wanted to ask here if you also have the problem that during an online backup, no data is saved in CDC mode with activated "Batch optimized apply" from the "Change Processing Tuning" Tasksettings (#Change Processing Tuning #Change Processing Tuning | Qlik Replicate Help)

I think the problem is that when truncating the temporary table, since a truncate and online backup are mutually exclusive in Db2 LUW. (https://www.ibm.com/docs/en/db2/11.5?topic=backup-compatibility-online-other-utilities)

So I only see the use of "Transactional apply" to get consistently the replicated data or have you an other idea?

00001816: 2025-02-20T11:56:45 [TASK_MANAGER    ]I:  Subtask #1 ended  (replicationtask_util.c:591)
00003868: 2025-02-20T11:58:43 [TARGET_APPLY    ]I:  Net Changes table name for the task is 'attrep_changesE4DE529EF38FB2E7'  (bulk_apply.c:3783)
00003868: 2025-02-20T12:00:45 [TARGET_APPLY    ]I:  Failed (retcode -1) to execute statement: TRUNCATE TABLE "CDC_QLIK"."attrep_changesE4DE529EF38FB2E7" IMMEDIATE [1022502]  (ar_odbc_stmt.c:5082)
00003868: 2025-02-20T12:00:45 [TARGET_APPLY    ]I:  RetCode: SQL_ERROR  SqlState: HY008 NativeError: -952 Message: [IBM][CLI Driver][DB2/LINUXX8664] SQL0952N  Verarbeitung aufgrund eines Interrupts abgebrochen.  SQLSTATE=57014 [1022502]  (ar_odbc_stmt.c:5090)
00003868: 2025-02-20T12:00:45 [TARGET_APPLY    ]I:  RetCode: SQL_ERROR  SqlState: HY008 NativeError: -952 Message: [IBM][CLI Driver][DB2/LINUXX8664] SQL0952N  Verarbeitung aufgrund eines Interrupts abgebrochen.  SQLSTATE=57014 [1022502]  (ar_odbc_stmt.c:5090)
00003868: 2025-02-20T12:00:45 [TARGET_APPLY    ]I:  Execute truncate net changes table failed. 'TRUNCATE TABLE "CDC_QLIK"."attrep_changesE4DE529EF38FB2E7" IMMEDIATE' [1022502]  (odbc_bulk.c:803)
00003868: 2025-02-20T12:00:45 [TARGET_APPLY    ]I:  Failed to truncate net changes table [1022502]  (odbc_bulk.c:901)
00003868: 2025-02-20T12:00:45 [TARGET_APPLY    ]I:  Error executing command [1022502]  (streamcomponent.c:1987)
00003868: 2025-02-20T12:00:45 [TASK_MANAGER    ]I:  Stream component failed at subtask 0, component st_0_DB2LUW-T-DTSDH  [1022502]  (subtask.c:1474)
00003868: 2025-02-20T12:00:45 [TARGET_APPLY    ]I:  Target component st_0_DB2LUW-T-DTSDH was detached because of recoverable error. Will try to reattach  (subtask.c:1589)
00003868: 2025-02-20T12:00:50 [STREAM_COMPONEN ]I:  Target last committed record id from the previous run is '141'  (streamcomponent.c:1693)

Thanks in Advice,

Michael

初めて投稿するため、不手際があれば何でもお教えいただきたいです。

あるユーザの役割を、下記の２つのみになるよう更新しました。

Automl Deployment Contributor

Automl Experiment Contributor

しかし、一晩経って翌日になると、下記の５つに戻っています。

Automl Deployment Contributor

Automl Experiment Contributor

Data Services Contributor

Private Analytics Content Creator

Shared Space Creator

上記の5つは初期設定時のものになります。

なぜ1晩経つと強制的に戻されるか、ご存知の方お教えいただきたいです。

Hi All,

I am facing issue while working one requirement from Business.

Scenerio:

I have a companyname having 100 companies and these are owned by 20 Executives. Each executive have different company. Now they want separate email for each owned company. Suppose P1 has 20 companies , then he must get 20 email corresponding to each different company.

I have tried with filtering but unable to generate 20 different email for each user. Even report filtering will provide all excel in Zip format but i want emails separately.

How can I configure NPrinting to send individual emails per company?

Any help or suggestions would be appreciated!

I have attached dummy file with all details. Please have a look into it.

Thanks in advance.

Qlik NPrinting @Lech_Miszkiewicz 

I have a column in my report, Tracking Status, that can have a value of Active, Pending, Canceled, or Rejected. Is there a way to, for example, only count the Active statuses?

I have tried creating a measure with the following formulas, none of them worked.

aggr(Count(TRACKING_STATUS), TRACKING_STATUS = 'Active')

If(Count(distinct TRACKING_STATUS = 'ACTIVE')=1,TRACKING_STATUS,1)

Count(IF(TRACKING_STATUS,'Active'))

Count(Distinct TRACKING_STATUS='Active')

is there a way to change the font size of axis labels and value labels in the charts (e.g. bar chart), without going down the customized theme route ? this is crucial for my use case since the dashboard users need to export the report to PDF. the default font size is way too small.