Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 216,710 members
  • 3,548 online
  • 1,993,878 posts
  • 149,402 Solutions
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Integration, Extension & APIs

    qlik app eval: how to filter data

    Reading the documentation https://qlik.dev/toolkits/qlik-cli/app/app-eval/ I was able to query the monitoring app Entitle ANalyzer qlik app eval "sum(... Show More

    Reading the documentation https://qlik.dev/toolkits/qlik-cli/app/app-eval/ I was able to query the monitoring app Entitle ANalyzer

    qlik app eval "sum(duration)" "min(endTime)" "max(endTime)" "sum(capacityUsed)" "count(userSubject)" by userSubject Entitlement_Assigned  -a $APPID

     

    but I did not find how to filter data, for example extracting data after a specific date...

    Is it possibile using qlik cli?

     

    Thanks in advance

    Matteo

    Show Less
  • forum

    New to Qlik Analytics

    frist row

    Hi, I need to show only the firtst row of each property code in the below table. Logic used: avg({<L_D_TYPE={'Current'}>+<P_D_TYPE={'Current'}>+<LRR_D... Show More

    Hi,

    I need to show only the firtst row of each property code in the below table.

    Logic used:

    avg({<L_D_TYPE={'Current'}>+<P_D_TYPE={'Current'}>+<LRR_D_TYPE={'Current'}>+<SL_D_TYPE={"Current"}>+<SLRR_D_TYPE={"Current"}>}[Property Code])

    Krish2459_58_1-1713112830995.png

     

     

    Show Less
  • forum

    Featured Members

    How to publish a Qlikview report to website

    Hello, How can i get the urls of qlikview? thanks  
  • forum

    Qlik NPrinting

    Reports queuing in Running Status until Qlik NPrinting Engine restarted

    Hi, We have around 10 tasks which are triggered at the same time. I notice that after few tasks completed successfully, one of the task stuck at 50%pr... Show More

    Hi,

    We have around 10 tasks which are triggered at the same time. I notice that after few tasks completed successfully, one of the task stuck at 50%progress(in Running status) even after generating the excel reports in output folder. So this and rest of the tasks stays in the queue for hours until i restart the 'Qlik NPrinting Engine'.

    Any suggestions, please

     

    Show Less
  • forum

    App Development

    Adding Values to Mapping Load

    Hi, Excuse me if I am using wrong terminology in this post.   I have used the Data Manager to create an Autogenerated load script and as part of this ... Show More

    Hi, Excuse me if I am using wrong terminology in this post.

     

    I have used the Data Manager to create an Autogenerated load script and as part of this I have changed some field values, which show in the Mapping Load section of the script (see below).  I am only able to do this through the Data Manager with values that are populated, but the data I am changing does not currently include a possible option 'vunlikely'.

     

    I know that I can unlock the autogenerated scrip and add manually, but is there a way to do the Mapping Load as a separate load section so that I can still auto generate later ? - I am afraid that if I unlock the auto generated I may need to autogenerate again at a later date and then lose these changes.

     

     

    MAPPING LOAD * INLINE
    [
    Breach LikelihoodMapping-FROM,Breach LikelihoodMapping-TO
    neutral,Neutral
    unlikely,Unlikely
    likely,Likely
    vlikely,Very Likely
    ];

    Show Less
  • forum

    New to Qlik Analytics

    Dataloading and synthetic keys

    I have multiple qvds uploaded in my data load editor with each qvd containing a few datapoints that have similar data but different column names. I cr... Show More

    I have multiple qvds uploaded in my data load editor with each qvd containing a few datapoints that have similar data but different column names. I created aliases for each to join each other but that created multiple synthetic keys. I want to join these tables so that these common fields can become filters on the dahboard. I can not concatenate the tables since the names are not the same in each table. Adding an example of data below. 

    Table 1: 
    Load
    ProductName
    Sales
    Cost
    Projects
    City
    From[Source]

    Table 2:
    Load
    Products
    Profit
    Cost
    SKU
    ProjectName
    CityName

    Table3: 
    Product
    PersonID
    PersonName
    CityEnName
    Project

    The filters that I want to create are Product Names, Project Names & City Name. 
    Please suggest how. I also tried creating joins but creating multiple joins for more than 20 tables doesn't work either. 

    Show Less
  • forum

    New to Qlik Analytics

    Set Analysis

    Hi All, I wanted to calculate the sum of 'rdays' field when 'Date' is equal $vmaxdate
  • forum

    Qlik Replicate

    How to add Azure Blob Storage as Source End-Point in Qlik Replicate ??

    I am able to see Azure blob as Target end point but not as a source end point. But my requirement is to fetch the files from Azure Blob (to use it as ... Show More

    I am able to see Azure blob as Target end point but not as a source end point. But my requirement is to fetch the files from Azure Blob (to use it as a source). Could anyone please assist me with this query!!

    Show Less
  • forum

    Connectivity & Data Prep

    Data loading and synthetic keys

    I have multiple qvds uploaded in my data load editor with each qvd containing a few datapoints that have similar data but different column names. I cr... Show More

    I have multiple qvds uploaded in my data load editor with each qvd containing a few datapoints that have similar data but different column names. I created aliases for each to join each other but that created multiple synthetic keys. I want to join these tables so that these common fields can become filters on the dahboard. I can not concatenate the tables since the names are not the same in each table. Adding an example of data below. 

    Table 1: 
    Load
    ProductName
    Sales
    Cost
    Projects
    City
    From[Source]

    Table 2:
    Load
    Products
    Profit
    Cost
    SKU
    ProjectName
    CityName

    Table3: 
    Product
    PersonID
    PersonName
    CityEnName
    Project

    The filters that I want to create are Product Names, Project Names & City Name. 
    Please suggest how. I also tried creating joins but creating multiple joins for more than 20 tables doesn't work either. 

    Show Less
  • forum

    Qlik Gold Client

    Data type with client en key

    Hello,  I tried to import Data Type CA -Text into our training instance from our production. The data was loaded, but is unusable because the client n... Show More

    Hello,  I tried to import Data Type CA -Text into our training instance from our production.

    The data was loaded, but is unusable because the client number is part of the key field in table STXL and STXH (field tdname).

    Is there a conversion or transformation for this data type ?

    The client number in production is 400 and in training is 200.

    According to the best practice guide we should'nt modify this data on our own.

    Please provide a solution.

     

    Regards 

    Michel Godin

    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!