Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,790 members
  • 7,420 online
  • 1,997,270 posts
  • 149,730 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Application Automation

    Do reload

    Hi, how can i do a reload evry 30 min from 06:00 to 08:00. evry day? Br John
  • forum

    New to Qlik Analytics

    Use a Button to navigate to a Chart on a Sheet in another App

    Hi Community Is it possible to use a button to navigate to a chart on another sheet in another app? If yes, how? 🙂 Thanks Pesche
  • forum

    Qlik Enterprise Manager

    How to upgrade Qliksense to the latest version 2024

    Qliksense2022.2 version, upgraded to version 2024.
  • forum

    App Development

    Find latest row for each "Kenteken" and only import those

    Hi there.   I have a problem and I can't seem to fix it in my load editor I want to import only the values of the latest row found for each Kenteken. ... Show More

    Hi there.

     

    I have a problem and I can't seem to fix it in my load editor I want to import only the values of the latest row found for each Kenteken. So for instance a Kenteken xx-00-xx can be on row 12000 and the same one xx-00-xx can be on 14000. I only want to import the latest row with that particular kenteken and other fields in order to get rid off duplicates. I want it to be done in the load editor and not in the front-end.

     

    Unfortunately I can't do anything with dates because they can be similar and there are too many variances.

     

    This is the script:

    feit_Boekwaardelijst:
    Load DISTINCT
         Kenteken,
        "Boekwaarde bedrag",
        "Boekwaarde datum",
    "Boekwaarde bedrag BTW",
    "Restwaarde bedrag",
        "Restwaarde datum",
    "Afschrijving termijnen",
    "Afschrijving KM",
      "Afschrijving schade",
    "Afschrijving kosten",
    "Afschrijving corr. rente",
    Verkoopbedrag,
    "Kostprijs verkoop",
    "Verkoop resultaat",
    Investering,
      "Verkoopprijs incl. BTW",
      Capitalize("Debiteur verkoop") as  "Debiteur verkoop",
      '-' & "Debiteur verkoop" as Handelaren,
        "Verkoop soort",
      Num("Inname stand", '#.##0') as "Inname stand"
    FROM [lib://IC Files - Company/Stream - ML - Algemeen/App - Verkooprapportage/Boekwaardelijst 2018 - 2023.xlsx]
    (ooxml, embedded labels, table is Tabelle1;
     
     
     
     
    Thanks a lot.

     

    Show Less
  • forum

    Design and Development

    Need Information on qlik sense data encryption methodology

    Hi I just have one query.Could anyone please clarify the methodology employed by Qlik for encryption? Specifically, we are interested in understanding... Show More

    Hi

    I just have one query.
    Could anyone please clarify the methodology employed by Qlik for encryption? Specifically, we are interested in understanding whether encryption occurs ON-OPEN, ON, or AT REST Methodology. And retrieval of data in front end after data encryption

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    How to reduce the Qliksense QVD size

    Hi every one, I want to import one QVD file, but it Give me error that the filesize exceed more than 50 MB.is there any idea how I could reduce the QV... Show More

    Hi every one,

    I want to import one QVD file, but it Give me error that the filesize exceed more than 50 MB.
    is there any idea how I could reduce the QVD filesize?

     

    Thanks in Advanced

    Samaneh

    Show Less
  • forum

    Connectivity & Data Prep

    What are IP Ranges in PostgreSQL Config

    I'm working on creating a command to silently upgrade PostgreSQL using Qlik PostgreSQL Installer. One of the arguments that are mentioned in Silently ... Show More

    I'm working on creating a command to silently upgrade PostgreSQL using Qlik PostgreSQL Installer. One of the arguments that are mentioned in Silently installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer documentation is iprange.

    Does anyone know IP addresses of which devices in a network should be populated for iprange argument?

    Show Less
  • forum

    New to Qlik Analytics

    Trouble with Incremental Data Loading into QVD File

    Hello community, I'm having trouble adding incremental data into a QVD file named YH1.qvd. Here's the code I'm using: TableYH1:Load *FROM [lib://DataF... Show More

    Hello community,

    I'm having trouble adding incremental data into a QVD file named YH1.qvd. Here's the code I'm using:

    TableYH1:
    Load *
    FROM [lib://DataFiles/YH2.qvd]
    (qvd);

    concatenate

    LOAD
    *
    FROM [lib://DataFiles/YH1.qvd]
    (qvd);

    store TableYH1 into [lib://DataFiles/YH1.qvd] (QVD);

     

    The issue is that I'm unable to change YH1.qvd. Can someone help me understand what's wrong?

    Regards
    Bhavya

     

    Show Less
  • forum

    New to Qlik Analytics

    Simplifying a table structure

    I have a spreadsheet to load into Qlik in the following format: Order ID Org1 OrgType1 Amount1 Org2 OrgType2 Amount2 Org3 OrgType3 Amount3 1000... Show More

    I have a spreadsheet to load into Qlik in the following format:

    Order ID Org1 OrgType1 Amount1 Org2 OrgType2 Amount2 Org3 OrgType3 Amount3
    10001 AAA Internal 1000 BBB Internal 300 CCC External 600
    10002 DDD Internal 1500 AAA Internal 200 EEE External 900
    10003 EEE External 800 FFF Internal 700 AAA Internal 1200

    ...and so on.

    But what I really want to work with in Qlik is a table like this:

    Order ID Org OrgType Amount
    10001 AAA Internal 1000
    10001 BBB Internal 300
    10001 CCC External 600
    10002 DDD Internal 1500
    10002 AAA Internal 200
    10002 EEE External 900
    10003 EEE External 800
    10003 FFF Internal 700
    10003 AAA Internal 1200

     

    Can anyone tell me how to get my data into that format?

    Thanks in advance,
    Dan

    Show Less
  • forum

    QlikView App Dev

    settings for 'Send to excel'

    I have a developing server and a production server.I noticed now that when I click in a chart the "Send to excel"- icon on the developing server I get... Show More

    I have a developing server and a production server.
    I noticed now that when I click in a chart the "Send to excel"- icon on the developing server I get options like this image

    curiousfellow_0-1711453857635.png

    However when I try the same on the production server I get this message :

    curiousfellow_1-1711454018564.png

    Excel is not installed on one of the servers, so I assume that it must be a setting, but I don't know where to find it.
    What setting do I have to change ?

    We are using Qlikview May 2021 SR1

     

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!