We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load is going success the job is failing with the error Failed to rename file repcmd.log to repcmd__240417043324.log .

Hello!

At my company we are seeing an issue with our QV applications where DocumentChaining will sometimes fail, returning a 'Failed to open document, file not found.'

When you go from APP1 to APP2, we use the transfer state option to transfer the value of the APP1 DocumentName() to APP2, so that the user can then return to APP1 with an Open Qlikview Document action.

The problem is, it seems this variable sometimes does not get transferred from APP1 to APP2, resulting in a null variable value in APP2.

Both apps have the variable stored in the variable editor and are in the same path. It also works flawlessy in Desktop Client.

We are using APRIL 2020 SR3 QV version, is anyone aware of any bug with this version causing variables not to be transferred via document chaining and transfer state option? Does anybody know of a workaround?

Instead of using MySQL native master-slave replica setup, can I use Qlik Replicate to replicate tables from source to target endpoint? Both endpoints are running MySQL 8.0

Any performance task settings guidlines or tips that I could follow?

Thank you.

Desmond

Hi,

I want to be able to find duplicated records within a table with around 100 fields.

I have a table with over 100 fields and i have a script that finds duplicated ID's but I want to know which field is responsible for the duplication.

Here is an example the ID is the same so as the cost but the number is different.

Any help ill be great.

Boa tarde comunidade!

Eu realizei um 'IF' que foi realizado corretamente, mas ele me apresentou alguns valores nulos.
Como poderia fazer para remover esses valores?

Muito Obrigado pela atenção.

There's a date field that has some inflated values like 8/15/57263 and similarly there are ~1000+ records. Along with these inflated values there's also values coming in format of MM/DD/YYYY. When taken a list box and exported this field to excel the values with 8/15/57263 comes as ########### and when hover over, it says 'Dates and times that are negative and too large are shown as ####### . On the table viewer this date field is integer. I want to change these inflated values to date format of 'MM/DD/YYYY' and also keep the other values too in the field. Any help is appreciated.

(Apologies, this was posted earlier but was my post was so full of flaws, I removed it).

I am trying to show a graph of tickets raised over a periiod of time.  In my data I have zero 'Open' tickets in October and as a result October does not show on my graph.

I have tried a 'Master Calendar' which works until a filter is applied.  -

I have also read about adding + sum({1}0) to my measure.

Count({<[Status]={'Open'}>}id) + sum({1}0)

and setting the Addons -> Data Handling -> Include zero values 

Any help would be appreciated

Hello.  I'm sorry as I'm sure this question is asked a lot but I wanted to get everyone's opinion on the best way to learn Qlik Sense. Here are the questions I have:

1) Data Transformations - I'm used to performing data transformations using Power Query which visualizes the data and has a drag and drop interface.  From my limited research, it looks like Qlik uses a scripting language to transform data prior to integrating it into a data model.  This seems like it will require a good amount of time to learn.  Is it better to spend that time learning the QLIK Scripting language or should I just learn how to do it in SQL and then bring in the data?  I am sure there are pros and cons to both but in the short-term I'm probably only going to bother learning one and I wanted to know what is preferred among Qlik Users?

2) Training - What courses have people used to learn Qlik Sense?  Are there known youtubers?  I saw Qlik Sense has a free business analyst video set.  I watched a few introduction videos and most of it is pretty intuitive.  

The two areas I'm struggle with is understanding how filtering works in Qlik Sense but I think I just need more practice playing with data.  The big area of focus is to understand the lexicon (what functions are available in Qlik Sense, how they work) and the syntax in Qlik Sense so I can write functions/play around with it.   

Thank you for your time!