Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 180,698 members
  • 2,292 online
  • 1,803,189 posts
  • 138,140 Solutions
Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!

Welcome to Qlik Community

Recent Discussions

  • forum

    QlikView Administration

    Qlikview 12.8 Migration

    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 se... Show More

    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.

    Show Less
  • forum

    New to Qlik Sense

    iSSUE WITH SET ANALYSIS

    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 requ... Show More

    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:

    DATE ERROR_ID TOTAL_VOLUME
    1/10/2023 ERR_1 608
    2/10/2023 ERR_2 667

     

    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

    ];

     

    Show Less
  • forum

    New to Qlik Sense

    Tabla de ventas

    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 anteri... Show More

    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.

     

    Show Less
  • forum

    Deployment & Management

    Get the value from one row to another row based on the condition in the script

    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 ... Show More

    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.

    dineshm030_0-1701582884934.png

    Expected Output:

    CP_Team_Flag Sales_District TerrCount
    CP IN1001 1
    ORG IN1001 1
    CP IN1028 2
    ORG IN1028 2
    CP IN5002 4
    ORG IN5002 1

     

    Thanks in advance.

    @sunny_talwar @MayilVahanan 

    Show Less
  • forum

    New to Qlik Sense

    Expression in coloring the points into a line graph

    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 repr... Show More

    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

    Show Less
  • forum

    New to Qlik Sense

    How to display data from a date field between two dates in a large dataset with ...

    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 fo... Show More

    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

     

    MColeman1999_0-1701134388175.png

     

    Show Less
  • forum

    New to Qlik Sense

    Ignore selection in Aggr rank statement

    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.  ... Show More

    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.

    Screenshot 2023-11-09 114936.png

    Show Less
  • forum

    New to Qlik Sense

    How to set up Dynamic yaxis in control charts especially in Line chart

    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... Show More

    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])))
    ))

    Show Less
  • forum

    App Development

    Qlikview text format to date format

    Hi all Qlikview users, I want to convert [YearMonth] field to Date format. I have tried this function in Qlikview object dimension "=Date(Date#([YearM... Show More

    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!

    Show Less
  • forum

    Qlik Replicate

    QlikRepliate v2023.11: Test Connect to Teradata fails with check_async_command_c...

    I am running into an issue while setting Teradata endpoint in QlikRepliate v2023.11 While configuring connection properties, I complete required infor... Show More

    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

    Show Less
Leaderboard

Customer Story

New Data Integration Customer Story + Video

Real-time Responses Delight Burgan Bank's Customers.

Customer Story

Talking Analytics to the Frontier

Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!