Exception in component tGPGDecrypt_1 (JOB_NAME) java.io.IOException: Cannot run program \"D:/GnuPG/bin/gpg\": CreateProcess error\u003d193, %1 is not a valid Win32 application"

We'd updated the private/public keypair in our keyring - restarted servers and we're no longer able to decrypt files.

Any tips or tricks on how to troubleshoot?

I'm able to decrypt from the command line using the new key successfully - need some help.

Hi,

I want to know if there is a way to calculate how many care-episodes that are ongoing for each year month.

A Commitment is ongoin if it starts or ends during the timeperiod or if it starts before the period and the end date is null (i.e has not been ended.)

Each commitment has a start date and an end date.

The following set expression gives the right total and can be used in a KPI visualisation:

={<Year=,
"Year-Month"=,
Date=
>} Count (

{
<
CommitmentStart= {"<=$(=Maxstring(Date))"},
CommitmentEnd={">=$(=minstring(Date)) "}
>
+
<CommitmentStart= {"<=$(=Maxstring(Date))"},
%CommitmentKey = E({<CommitmentStart={"*"}>})
>
}

%CommitmentKey)

I want to put this in a barchart or a line chart and that means that the max date and min date for the period is dependent on the year-month(or time period) in the chart. I have tried to wrapp it in an aggr function but as I understand it, an aggr function is only evalueted once and there for dose not give me the desired result.

If I try to calculate this in the script and assign an "on-going date" to each day the commitment is ongoing I need to create at lot of extra data with uniqe values wich takes up a lot of hard drive and memory. Sure its possble to calculate each commitment as ongoing for each year month but some times the users need to se ongoing per week or day.

What I suspect is needed to be done in order for this to work is to itterate the calculation for each year month(time period in the chart), is this possible? I have looked in to chart scripting but the documentation is quite lean and it is almost like learning a new language.

Antother workaround i have tried is to creat a measure for each time period but that is no really a great option (even thou the performace is really good).

Any one who have had similar issuse and been able to solve this without using the load-script? (chart scripting or something else)

Best regards

Hi everybody,

I came accross thi security issue that affects the bundled Postgre included into Qlik Sense May 2024.(version 14.8)

CVE-2024-10979

I'd like to know if a security patch will be released to fix the issue or if there is any suggestion to face the problem.

The only idea I have is to unbundle the database and upgrade it to the last patch. 

Thanks for the support

Regards

Hello,

Following simple question: 

In a pivot table with multiple dimensions, I want to show Actuals, as well as 12-Month Averages. So my question is for a chart function.

While I got it working for the main Category using following formula (consistently 1000 in below sample), I have difficulties to get the same by Sub Category.

This is the formula that does the overall Average:
Sum(TOTAL{$<[Link_Table.Theme] = {'link_table'}, [Events.event_name] *={event1},[MasterCalendar.MonthYear]={">=$(=Date(AddMonths(today(),-12),'MMM-YYYY')) <=$(=Date(AddMonths(today(),-1),'MMM-YYYY'))"} > }[Events.event_count])/12.

Can you help in getting the 12 month average even by Sub Category (and potentially for even more Categories beyond)?

Thank you!

I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

Hi all. Could someone please help me to clarify why my calculation doesn't work for all cases I tested.
What I need to do:
1. I need to calculate the list of dates that are included in the period selected by the user. The user can select in the fields Year, Quarter, Month, Week, Day. Like period from 25/10/2024 to 22/10/2024.

2. Than I need to calculate the number of days that are included in the selected period. For period from 25/10/2024 to 22/10/2024 it is gonna be 4 days.

3. I need to count previous day before earliest date in the period. It gonna be 21/10/2024 - max date of the new calculated period

4. Then I subtract 4 days from the 21/10/2024 and calculate the last date of the new period. It will be 18/10/2024.

Here how result looks like

All issues starts when I use selection only for several filters. Lets say I I select Year = 2024, Quarter = Q4, Month = October. In this case list of dates from selected period will be from 31/10/2024 to 01/10/2024. Amount of days for this period is 31. So I expected to get results for calculated period 30/09/2024 to 31/08/2024. But in fact I received nothing

As far as I see, it happens because 31/08/2024 is relate to Q3. And till I have Q4 selected I will receive empty results. But I excluded possible field selections in set analysis for calculated period and I don't understand why it does not work. 
My formula is 
=Concat({<Day=, Week= ,Month =, Quater =, Year =, OrderDateKey={">$(=$(vComparedDateMin))<=$(=$(vComparedDateMax))"}>}OrderDate, ' ')

OrderDateKey - is field that contained numeric value of date
vComparedDateMin - earliest date in a new periods set
vComparedDateMax - latest date  in a new periods set
OrderDate - formated date values

I also add .qvf file (created in QlikView so I'm not sure if Qlik Sense will work correctly with it)
I'll be very appreciate for any help or hint

I've got a table / grid widget placed on my sheet.

The hover menu is enabled. On Chrome and Firefox, the hover menu is clearly visible and usable on shared and managed spaces. But on Edge browser not.

Are there any tricks, to convince Edge displaying the hover menu?

Bonjour la communauté,

Cela fait quelques minutes que je tente de trouver l'information sur le forum mais rien de probant. 

Je vous expose mon problème :

Je possède deux valeurs à comparer dans un stock sur des lignes identifiées :

Dans ce tableau j'ai ajouté une colonne avec un master item "ECART" :

=IF([STOCK A]<>[STOCK B], 'OUI','')

Cela me permet d'indiquer les lignes qui ont des écarts entre les deux stocks 

A présent je voudrais avoir un affichage dans un KPI du nombre de ligne en écart (Ici 2). 

Je n'ai pas trouvé la solution après avoir testé :

COUNT(=IF([STOCK A]<>[STOCK B], 'OUI',''))

SUM(=IF([STOCK A]<>[STOCK B], 'OUI',''))

SUM(IF([ECART]='OUI',1,0) ==> Incorrect car ne repère pas [ECART] comme master item.

J'ai tenter mais les valeurs indiquées ne différencie pas que la ligne soit "Oui" ou Vide.

L'objectif final est de différencier les lignes puis ensuite d'indiquer à l'utilisateur sur un tableau de bord :

"3 Absence du stock A / 2 Absence du stock B / 1 Ecart Quantité "  Donc potentiellement en se basant sur le résultat du master Item à chaque fois.

Y-a-t'il une solution que je n'ai pas encore découverte pour ce type de problème ? 

Je vous remercie,

Avie

Hi, 

I have the following data:

[Mappings]: *THIS TABLE SHOWS EVERY ID THAT HAS A TEAM MAPPING*

LOAD

[ID],

[TEAM],

from [MAPPING TABLE]

[Table1]
NoConcatenate
LOAD
"Official ID" as [People ID]
FROM [SHEET 1]

[ID has link]:
NoConcatenate
LOAD
[ID] as [Linked ID]
resident [Mappings];

Concatenate ([Mappings])

LOAD
[People ID] as [ID],
'No Team' as [TEAM],
'Unmapped ID' as [Responsibility]
resident [Table1]
where not exists ([Linked ID],[People ID]);

Drop table [ID has link];
Drop table [Table1];

LOAD *THIS LOAD PULLS EVERY ID IN REGARDLESS OF A MAPPING AND TIES MORE INFO LIKE COUNTRY AND ID CODE ASSOCIATING TO THE MAPPING TABLE WITH [ID]*

[Official ID] as [ID],

[ID CODE],

[COUNTRY]

FROM [TABLE 2]

THE QUESTION: every ID will be aligned to a unique [ID CODE] and multiple [ID] can belong to a [ID CODE]....i want to add another tagging similar to the above but for [ID CODE] to essentially see the [ID CODE] does not appear in the MAPPING TABLE....once the [ID] field is associated. 

i keep getting a synthetic key....if someone could help that would be great!