The company I work for recently installed Replicate and I am trying to figure out why it quits processing the changes after a few hours of running.  We are replicating the data from an iSeries with journaling to SQL Server.  I reload all tables within the task successfully and the task is in run status.  It picks up changes for a few hours during the day but then all of a sudden stops.  The logs don't show anything unusual happening and basically just state the task is running every 10 minutes.

Bonjour à tous,

J'aimerais trouver une formule qui me permettrait de faire apparaître uniquement les chiffres dont j'ai besoin.

Si l'unité de conditionnement est au kilo me faire apparaitre uniquement le kilo (ne rien mettre en pièce) et si c'est pièce ou colis me faire apparaitre pièce (ne rien mettre dans kilo).

Attention Unité de conditionnement = pièce

Ci-joint un exemple : 

Dimensions : 

FAMILLE_PRODUIT

SOUS_FAMILLE_PRODUIT

UNITE_CONDITIONNEMENT_AC

Mesures

Sum([LIGNES_ARRIVAGE.POIDS_NET])

Sum([LIGNES_ARRIVAGE.QTE_PIECE])

Merci pour votre aide 😉

Hi, I am working on Qlik Sense Desktop and currently developing a Ad-Hoc combo chart with VizLib combo chart extension and users can select the dimension(s) and measure(s) to be displayed on the combo chart. I have 2 filter panes, one is for dimension and one is for measure. In order to filter out unselected dimension(s) or measure(s), I used calculated conditions in the data section. I have both integer values (in millions) and percentage values for the measures, thus, I used the primary y-axis for the integer values and secondary y-axis for the percentage values. The combo chart displays the bars and lines correctly when I have both measures from primary and secondary axis selected or just measures from the secondary axis (which are the percentage values). When I only have measures from the primary axis selected, weirdly, the values in the primary axis alongside the lines or bars will be displayed too high and are not visible within the chart. The range of the values on the primary axis are all off, it will only work if I set the Min/Max values manually but its not practical. I set all the formatting to auto for all the measures and the problem still persist. Is there a way to make the chart's axis display the values range dynamically or is there some settings that I missed from VizLib combo chart? Any help would be greatly appreciated. 

Hi,

I have a situation where null values are created by another dimension, not true null. I can give these a value by using a count, the return will be 0, then i use if the count = 0 give a value. This is now selectable in the table. Great!

if(aggr(count([Standard Name]),[Production Facility])=0,'No Standards')

However, i now need a button to filter these values and i am struggling to get this. I have tried a few thing with non working. Like using Select values matching search criteria and the value 'No Standards' But i guess this is not a real value!

Does anyone know how i can use a button to filter the created 'No Standards' in the field Standard Name?

Thank you in advance.

Daniel

Hi ,

Can you give some example how to gives access group level qlik sense section access.

I have some requirement like below:

let's we have Total 6 user: They are divided into 2 Group.

How to Give access 2 group different level country access.

ex: 1st group need IND,USA access 

     2nd  group need UK,AUS access

I have provided the Data below

Sales:
Load * inline

[

Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300

2019, USA, 120
2020, USA, 220
2021, USA, 500

2019, UK, 350
2020, UK, 650
2021, UK, 150

2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];

Hello

I have problem with synth keys. Im trying to solve it by preparing key but it won't work.

Here's my data:

LOAD
ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
RESULTS1

RESULTS2

RESULTS3 ...

2nd table

ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
DIF_RESULTS1

DIF_RESULTS2

DIF_RESULTS3 ...

How to prepare a key which will connect PTT and PROD_ORDER_NO without syth key, so that i will still be able to use PTT or PROD_ORDER_NO filter?