I have a pivot table. I have two Dimensions: one Row (Adjustments by Code), and one Column (Post Date Fiscal Quarter). I have two Measures (Values) : Count of Adjustments and $ of Adjustments. I am displaying two Fiscal Quarters at a time. I would like it to sort by the $ of Adjustments in the most recent Fiscal Quarter column, lowest to highest. I have tried a number of old suggestions from this community and none of them work for me. Anyone have any new suggestions? 

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