I am unable to establish connection from Qliksense to Amazon Redshift. 

We see that firewall is also relaxed open between our nodes to Amazon Redshift for port 5439. 

Attached is screenshot. 

Bonjour à tous,

J’essaye de faire des déclencheurs à l’ouverture de ma feuille, mais lorsque je tente de faire une sélection sur le mois précédent le mois courant, je n’y parviens pas.

Voici comment j’ai fait :

D’abord j’ai créé une variable nommée « moisCourant1 » permettant de récupérer le mois :

=Gauche(NomMois(DébutMois(AjoutMois(Aujourd’hui(), -1))), Len(NomMois(DébutMois(AjoutMois(Aujourd’hui(), -1)))) - 5)

J’obtiens donc « avr. »

Ensuite, je crée ensuite mon déclencheur « sélectionner les valeurs dans un champs », auquel j’ajoute ma variable : =moisCourant1

mais Cela ne marche pas. j’ai tenté aussi de rentrer directement la formule dans mon déclencheur mais ça ne marche pas non plus. Pourtant, j’ai fait exactement le même procédé pour sélectionner l’année en cours, et ça à bien fonctionné.

Pourriez vous m’aider s’il vous plaît ?

Merci par avance et bonne journée !

Marie

Hi,

Im getting the below error when a job in a schedule is running:

"error access violation at address 01B48B4A in module Nprinting.exe. Read of address 000000000"

picture of error attached as well

Any idea what could be causing this?

Thanks

Malcolm

In source we have the data coming correct where as in target the array coulumns are occing as one column.

For example:

we have source columns as abc1,abc2, abc3, abc4, abc5 with values 19,0,0,2,4 in target data is loaded as abc with value 19;0;0;2;4.

For splitting each column I used below functions. please review.

abc1 : substr($abc1,1, instr($abc1,';')-1) = returns 1st value

abc2: SUBSTR($abc2, INSTR($abc2, ';') + 1 , INSTR($abc2, ';')-1) = doesnt return 2nd value instead returns 0;

Please help us in resolving this issue in qlik replicate.

Thanks in advance.

Hello All, I want to create same like below in Qlik sense
Data Detailed report is Heading and 4 links at right are hyperlinks, instead of hyperlink I created button
I want show exactly like in picture

Plese help
Thanks!

Hello,

I'm working on a Qlik nPrinting migration on a new server which have the May 2023 SR2 release installed.

Can you tell me how to deactivate the license of my old server to activate it on the new one ? In the activation panel, i don't have access to a desactivation option.

Thanks,

Emmanuel

Tried to Stop and Resume the task, but when we stopped, task is stopping for hours and still loading. I am not able to resume the task back. Still loading

Hi,all

i have a connection to sharepoint and the file got new date evryday.

So is there a function in script to take the Filename_*.xlsx

I know i can doit when the file is on Cloud, but it's not seems to work from shares.

Hi,

we have users with the full level authorization, so they can create their own charts.

In our data model we have two fact tables (say purchases and sales) and sometimes the users will create charts picking dimensions and measures from both tables.

This creates a spike in the server RAM, because the specific combination of dimensions and measures creates a cross join.

Can we use a preemptive control to avoid this situation? It would be nice to put a memory limit on the specific charts or, even better, to prohibit specific dimensions and measures combinations.

Thanks

Fabiano