We are planning to upgrade our Qlikview.

The new server will be a separate server.

The current version is 12.0 and the new version is 12.8.

We will set up 12.8 on the new server and migrate from the current version 12.0 to 12.8.

We are organizing the folders and files to be migrated.
We would like to confirm the following about the target folders and files.

(1)
Is the idea that the target folder for migration is the following folder correct?
　C:\ProgramData\QlikTech\ManagementService\QVPR
　C:\ProgramData\QlikTech\Documents
　C:\ProgramData\QlikTech\SourceDocuments

(2)
If (1) is correct, is it safe to assume that all files in the folder are to be migrated?
If not, please tell us about the files to be migrated.

(3)
Are users and tasks included in the migration?
If not, please let us know if there is a way to migrate them without manual intervention.

(4)
We are looking into how to upgrade according to the following document.
　・How to Upgrade or Migrate QlikView 11.20 and later versions 
We would like to know if there are any other considerations other than the above in the transition.

Your prompt reply would be greatly appreciated.

Hi, I need a help in comples set analysis.

For the below data, we have multiple Products and Error ID. Error IDs are related to few Products. The requirement is to get the Sum of Volume for Error IDs but the twist is that for the given date we need to find the related Products and for those products we need to find the sum of Volume. So the output of the below data should be:

I have written the below set analysis but its not working:

SUM({<Product=p({<Error_ID=p(Error_ID)>}Product)>}Volume)

Could you please help me to acheive this output.

Thanks in advance.

The load statement of the sample data is as below:

load * Inline[
Date, Product, Error_ID, Volume
1/10/2023, P1 ,, 23
1/10/2023, P1 ,,24
1/10/2023, P1, , 25
1/10/2023, P1, ERR_1, 26
1/10/2023, P2 ,, 27
1/10/2023, P2,, 28
1/10/2023, P2 ,ERR_1, 29
1/10/2023, P3 ,, 30
1/10/2023, P3 ,, 31
1/10/2023, P3 ,, 32
1/10/2023, P3 ,, 33
1/10/2023, P3 ,, 34
1/10/2023, P3 ,ERR_1, 35
1/10/2023, P4 ,, 36
1/10/2023, P4 ,, 37
1/10/2023, P4 ,, 38
1/10/2023, P4 ,ERR_1, 39
1/10/2023, P4 ,, 40
1/10/2023, P4 ,, 41
1/10/2023, P5 ,, 23
2/10/2023, P5 ,, 24
2/10/2023, P5 ,, 25
2/10/2023, P5 ,ERR_2, 26
2/10/2023, P6 ,, 27
2/10/2023, P6 ,, 28
2/10/2023, P6 ,ERR_2, 29
2/10/2023, P7 ,, 30
2/10/2023, P7 ,, 31
2/10/2023, P7 ,, 32
2/10/2023, P7 ,, 33
2/10/2023, P7 ,, 34
2/10/2023, P7 ,ERR_2, 35
2/10/2023, P8 ,, 36
2/10/2023, P8 ,, 37
2/10/2023, P8 ,, 38
2/10/2023, P8 ,ERR_2, 39
2/10/2023, P8 ,, 40
2/10/2023, P8 ,, 100

];

Buen día, alguien que me pueda ayudar.

Quisiera obtener una tabla de ventas donde pueda ver la venta del mes que corresponde y la venta del mes anterior.

En el ajunto dejo un archivo con el resultado que tuve y con el resultado que espero tener.

Hi,

Based on the month condition, I need to populate the value from one row to another. If the CP data has lower terr counts, we must incorporate the ORG terr counts (CP < ORG) in the script.

Kindly help me out.

Expected Output:

Thanks in advance.

@sunny_talwar @MayilVahanan 

Hi community,

i need help in creating an expression to use for coloring groups of values with different colors  in a line graph.

In this graph, I represent a variabile that should be between two limits.

I would like to evidence (by coloring in red the points) all those points outside the limits for AT LEAST 5 CONSECUTIVE TIMES.

In this way I can avoid to highlights all those points that can be considered as outliers.

I'm trying to use a combination of RangeSum and Above but I don't find the correct formula.

I hope someone could help me.

Thanks,

Andrea

I have a large data set with multiple sources pulling data in and an employee table with start and stop dates as well as the current business title for those dates. I am using interval match to bring back data when employees are a certain business title. I now have a another table with just employee id's start and stop dates and what type of trying the employees are in. How can I integrate this table into the rest of the data to do the same as with the business titles? Can I do another interval match? See Below for Data model view

I have a heatmap where I am displaying customers sales per week where it ignores the week selection and displays for example every week in the year. 

This part is working fine, however I want to colour by a measure which ranks the sales per customer per week and colours depending on this. I have done this previously on another app, but this time I don't want the users to manually have to select all weeks for the colours to display properly.

I have tried something like this, but not having any luck:

={1<Week = P(${Week})>}Aggr(RANK({1<Week = P(${Week})>}aggr((sum({1<Week = P(${Week})>}[Sales])*-1), [Customer Name]),0,0), [Customer Name])

The one I have on another app which works when they select the relevant weeks is:

Aggr(Rank(Aggr((SUM([Sales])*-1), [Customer Name],[Week]), 0, 0), [Customer Name],[Week])

Below shows the issue where the user has selected week 8 and therefore it is the only coloured cell.

I have Line chart which reports official values (Y Axis) based on Reporting year on (x Axis).
Below is the expression for eOfficial 

Only({<[CRS Version]=, Flg_National={0}>} [Report Year Percent]).

I have two variables tAxis = 1 Traditional and tAxis =2 for varying. The yaxis in the line chart has to be changed dynamically based on the selection made in the variable 

Here is the expression setup for axes but varying is not changing and showing flat line. Could you please help me with the min and max expression for axis and how this vary.

if (
Pick($(tAxis),
$2(Aggr(Only({<[CRS Version]=>} [Report Year Percent]),[Area Name])),
if('$2'='Min', $2(Aggr(
Only({<[Area Name]={'$(=$(vArea_Pick($1)))'},[CRS Version]=>} [Report Year Percent]), [CRS Reporting Year])),
$2(Aggr(
Only({<[Area Name]={'$(=$(vArea_Pick($1)))'},[CRS Version]=>} [Report Year Percent]), [CRS Reporting Year]))))
<0, 0,
Pick($(tAxis),
$2(Aggr(Only({<[CRS Version]=>} [Report Year Percent]),[Area Name])),
if('$2'='Min', $2(Aggr(
Only({<[Area Name]={'$(=$(vArea_Pick($1)))'},[CRS Version]=>} [Report Year Percent]), [CRS Reporting Year])),
$2(Aggr(
Only({<[Area Name]={'$(=$(vArea_Pick($1)))'},[CRS Version]=>} [Report Year Percent]), [CRS Reporting Year])))
))

Hi all Qlikview users,

I want to convert [YearMonth] field to Date format.

I have tried this function in Qlikview object dimension "=Date(Date#([YearMonth], 'YYYY-MM'), 'MMM YYYY')".

The result showed Nov 2023, it look correct. However when the trigger email to user, the date column in excel file is

in Text data type.  Can anyone advise me how should I do in order to let the date column show in date format instead

when Qlikview trigger email.

Thanks everyone!

I am running into an issue while setting Teradata endpoint in QlikRepliate v2023.11

While configuring connection properties, I complete required information like server name and authentification information, and click "Test Connection", then following errors occur.

ERROR: check_async_command_complete failed
ERROR: Cancel async command failed.

Rarely the error below displayed on the screen.
no rest handler for url </attunityreplicate/rest/servers/local/commands/?action=check_async_complete&task=null>

Environment:
- QlikReplicate : v2023.11 on Linux
Teradata ODBC 17.20
TeradataToolsAndUtilitiesBase 17.20

- Target database : Teradate 17.20

ODBC connection to the database is fine.
During the Test Connection, repctl process seems to end abnormally. So it seems to be a issue of Qlik replicate.

Are there any workarounds for this issue?

I will attach repserv.log.
If some more information is required, could you let me know?

Regards,
Kyoko Tajima