Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,275 members
  • 5,618 online
  • 1,991,563 posts
  • 149,197 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Analyzer-app for our Users

    Can one configure certain apps, such as demo apps and sample data, to not be tracked by Qlik. I have diagram and i want to see the flop 10 apps, but w... Show More

    Can one configure certain apps, such as demo apps and sample data, to not be tracked by Qlik. I have diagram and i want to see the flop 10 apps, but we have demo apps and data too. I could expand my diagramm to 30 to see the other flop apps, but that does not look good. So in which space do i need to put those demo or data apps ? 

     

    Show Less
  • forum

    New to Qlik Analytics

    Expression going to zero

    i have a table - i only want to include where the 'Team' field contains 'GB' - at the moment i do: =[Team] like '*GB*' and the values go to 0 and -1 w... Show More

    i have a table - i only want to include where the 'Team' field contains 'GB' - at the moment i do:

    =[Team] like '*GB*'

    and the values go to 0 and -1

    what is the correct way of doing this

    Show Less
  • forum

    Design and Development

    How to load external tJasperReportExec component?

    Hi everyone,   I wonder how I can load this tJasperReportExec component? I unzipped all files into a folder but  when I go Preferences --> Talend --> ... Show More

    Hi everyone,

     

    I wonder how I can load this tJasperReportExec component? I unzipped all files into a folder

    but  when I go Preferences --> Talend --> Components and select the folder which contains the files

    and click on apply. I don't find tJasperReportExec even when I restart Talend.

    Did I something wrong?

     

    pawe84_0-1711614419790.png

     

    Thanks in advance for any help.

    Show Less
  • forum

    App Development

    Sheet Navigation Back/Forward buttons/arrows in UI Moved?

    Is there any way to revert their location within settings, of via theme? For usability this feels like a bit of a blunder, as if you have scrolling sh... Show More

    Is there any way to revert their location within settings, of via theme?

    For usability this feels like a bit of a blunder, as if you have scrolling sheets, you now lose the arrows when you scroll.

    On open :

    110_0-1687561143019.png

    Start scrolling ,lose the nav buttons for back/forward.

    110_2-1687561369485.png

     

     

     

    Show Less
  • forum

    Integration, Extension & APIs

    Integrate Qlik SaaS to ReactJS web application

    Dear Qlik developers, I want to make a website that shows a visualization. I already tried to embed the visualization on a react.js app and it works w... Show More

    Dear Qlik developers,

    I want to make a website that shows a visualization. I already tried to embed the visualization on a react.js app and it works wonderfully. However this approach makes user has to login twice (first to the website and one more login to Qlik)

    What is the best approach to show a visualization on website without requiring user to login twice? Can I impersonate my user to access the visualization stored in Qlik? I have Qlik user with developer access and can generate API Keys

    Thanks in advance for the answer

    Show Less
  • forum

    App Development

    Why is the include variable executed?

    Dear All The include variable is located behind the exit clause.This script is not interrupted in the exit clause.Why is the include variable executed... Show More

    Dear All

    The include variable is located behind the exit clause.

    This script is not interrupted in the exit clause.

    Why is the include variable executed?

     

    *********** Script  new *****

    vServername = ComputerName() ;
    trace $(vServername);
    if '$(vServername)' = 'QlikDev' then 
    trace '------1';
    else
    trace '------2';
    end if
     
    exit script;
     
    vTargetPath_qvs = 'lib://File_Folder ;
    $(Must_Include=[$(vTargetPath_qvs)/AUTH/Authorization.qvs]);
     
    exit script;

     

    *************** Script end

     

    Qlik Sense Version : Nov 2023 patch 7

     

    Best Regard

    Hanna.choi

    Show Less
  • forum

    App Development

    Matching in Script, based on count()

    Hi everyone, i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set anal... Show More

    Hi everyone,

    i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set analysis, but this is not working as expected when i want to filter, based on this result field.

    So, consider having the following Table:

    CreditorNr | Type | BankNr

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345100

    010001     | 100   | 12345100

    Using the following formula, i obtained the following MatchField:

    =aggr(If(
    Count(Distinct Type ) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear'), CreditorNr , BankNr)

    i get following results, that are also correct:

    CreditorNr | Type | BankNr       | MatchField

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear

     

    Anyway, when trying to implement this in the Script, i dont get the correct result. In the Script i use the following code:

    TEMP:
    NoConcatenate
    Load CreditorNr,
    If(Count(Distinct Type) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear') as ScriptMatch
    Resident BankTab
    Group by CreditorNr, BankNr;

    And i get the following result:

    CreditorNr | Type | BankNr       | MatchField                        | ScriptMatch

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    So it basically goes through every BankNr and duplicates the data, once bank is clear, and once bank is not clear... 

    Can anyone please give me a hint on what im i doing wrong in the script?


    Thank you for the support. 🙂

    Show Less
  • forum

    App Development

    Default Max Date selection in Filter pane when app opens

    When I open my app, I wanted to see my max date selection in my Date field. Some one can help me on this.
  • forum

    New to Qlik Analytics

    Script error: Invalid expression

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employ... Show More

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.

    I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.

    Load
    count(if(status='Current',"EmpName")) as JanExisting,

    count(if(status='Current',"EmpName"))
    +count(if(status='New' and Month='Jan',"EmpName")) -
    count(if(status='Exit' and Month='Jan',"EmpName"))
    as JanFinal
    Resident MyTable;

    Load
    JanFinal +
    count(if(status='New' and Month='Feb', "EmpName", null())) -
    count(if(status='Exit' and Month='Feb', "EmpName", null()))
    as FebFinal

    Resident MyTable;

    Load
    FebFinal +
    count(if(status='New' and Month='Mar', "EmpName", null())) -
    count(if(status='Exit' and Month='Mar', "EmpName", null()))
    as MarFinal
    Resident MyTable;

    Show Less
  • forum

    App Development

    Creating Timeline hart on Qlik Sense

    I have a list of different projects with their planned start/ finish date .Can any one help me to crate timeline chart in dash board ?
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!