Qlik have introduced the Cyclic group to Qlik Sense Cloud, Which is a fantastic addition for you to dynamically change the dimension based on the cyclic group.. This opens the doors to dynamically use the the Cyclic group in Aggregation function in a calculation.

• Create a Cyclic group with the required Dimension values . EG Locations.
• Create a Variable in the script to get the label of the group dimension created above (Note the single quotes and the = inside , very important for the $ expand to compute the values from the cyclic field name selected

set vLocations = '=GroupDimensionLabel(Locations)';

• Use the variable inside your formula

Aggr(Rank(1-count({<[somefield]={'somevalue'}>}some_number)/count(some_number)),$(vLocations))

Dear Community 🙂

Here the "challenge":

I want to link a table that has three fields: "Product ID", "Supplier No" and "is_DefaultSupplier" as this table shows the Default Supplier every product with the Supplier No.

In the DataModel (attached), I have a table "ProductDim" with the field "Product ID" and a table "Supplier" with "Supplier No". 

How can I link my new table? 🙂 Do I have to go via the LinkTable?

Thanks a lot and greetings from Switzerland!

Pesche

repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp. 

D:\bin>repctl getcheckpoint "TASK_INGCDC_02"

command getcheckpoint response:

{

        "checkpoint":   "checkpoint:V1#33512#1271;638506460899807820;20240120221751514712#0#0#*#0#137"

}

[getcheckpoint command] Succeeded

Regards

Dipankar

Hello,

I have a set of data which contains dates reaching from 01-03-2024 to 30-03-2024 and various dates in 2023.

Now I need to get the first date out of my data set but out if this year. This would be 01-03-2024.

When I use min(), minstring(), makedate() the result is either 01-01-2024 or the first date in the data which is some day in 2023.

Is it possible somehow to get the desired 01-03-2024?

Hello All, 
I have two variables in my Include file

LET vNumOfYears = 4;
LET vStartDate = date(Yearstart(AddYears(Today(),-$(vNumOfYears))),'YYYY-MM-DD');

Currently I am taking last 4 years of data, but now I just want to show Current Quarter+ last 4 Quarters of data
I want to remove taht 4 in NumOfYears and add my new condition there (4 quarters before + current quarter )

I need to show that in above variables

Please help to get this

thanks!!

I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the PostgreSQL 9.6 database. So I want to use the Qlik PostgreSQL Installer to upgrade and unbundle the PostgreSQL database.

I used version 1.3 instead of 1.4 of the QPI tool as my folder where Qlik is installed is not the default "C:\program files\qlik\sense" folder.

After a few minutes the QPI returns an error and refers to the log folder. Within this log folder in the install-postgresql.log file, the following lines are included:

-----------------------------------

Called ClearAcl (C:\Program Files\PostgreSQL\14\data)...
Executing batch file 'rad811EC.bat'...
C:\Program Files\PostgreSQL\14\data NT SERVICE\TrustedInstaller:(I)(F)
NT SERVICE\TrustedInstaller:(I)(CI)(IO)(F)
NT AUTHORITY\SYSTEM:(I)(F)
NT AUTHORITY\SYSTEM:(I)(OI)(CI)(IO)(F)
BUILTIN\Administrators:(I)(F)
BUILTIN\Administrators:(I)(OI)(CI)(IO)(F)
BUILTIN\Users:(I)(RX)
BUILTIN\Users:(I)(OI)(CI)(IO)(GR,GE)
CREATOR OWNER:(I)(OI)(CI)(IO)(F)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)

Successfully processed 1 files; Failed processing 0 files

Removing inherited ACLs on (C:\Program Files\PostgreSQL\14\data)
Called Die(Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data))...
Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data)

Script stderr:
Program ended with an error exit code

-----------------------------------

I'm an admin and I run the tool as administrator. Also I disabled UAC, but without any success. Please help.