Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 173,906 members
  • 2,505 online
  • 1,794,002 posts
  • 137,217 Solutions
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    VLOOKUP with terms in Qlik

    I created a visual with the columns transport zone and departure day. These two columns both come from a different table but are linked by a field tha... Show More

    I created a visual with the columns transport zone and departure day.
    These two columns both come from a different table but are linked by a field that exists in both tables.

    I have a third table where each transport zone has the departure time. It may be that a transport zone has multiple departure days and therefore the transport zone must be matched with the departure day to get the correct departure time from the third table.

    Does anyone have an idea how I can set this up in Qlik?

    Thanks in advance for thinking with me.

    Show Less
  • forum

    App Development

    Set expression to compare the year and month of one date to the year and month o...

    I have a table with data based on the employee's work date (WorkYear, WorkMonth).  If there are employees who separated, I need to count them by their... Show More

    I have a table with data based on the employee's work date (WorkYear, WorkMonth).  If there are employees who separated, I need to count them by their TermDate, but the Year and Month of the TermDate should equal the WorkYear and WorkMonth to get an accurate count by WorkYear and WorkMonth.  I tried the following set expression but it doesn't work.  Any suggestions?

    aggr(sum({<WorkYear={"=Year(TermDate)"},WorkMonth={"=Month(TermDate)"}>}Separated),WorkYear,WorkMonth,HomeBusUnit)

    mikegrattan_0-1695926393622.png

     

     

    Show Less
  • forum

    New to Qlik Sense

    Set Default Value in a Qlik Sense Mult-select Filter

    How do I set the default value in a multi-select filter. Example: Filter Country has 30 countries but when you first load the app, you have it set to ... Show More

    How do I set the default value in a multi-select filter. Example: Filter Country has 30 countries but when you first load the app, you have it set to Canada, US, Mexico and that is what shows in the label inside the dropdown.

    Country

    US, Mexico, Canada

     

    Bookmarks is not something I am looking for!

    Show Less
  • forum

    App Development

    My Line Chart and scatter plot is very slow, how to improve that

    My Line Chart and scatter plot is very slow, How to improve those visuals performance. Iam attaching my qvf file, I have very less time. Immediate hel... Show More

    My Line Chart and scatter plot is very slow, How to improve those visuals performance. Iam attaching my qvf file,

    I have very less time. Immediate help is appreciated.

     

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense action button for selecting multiple values in a field

    Hi,I have found multiple posts for this but none have worked.I'm trying to create an action button for multiple values of a field.  It works fine for ... Show More

    Hi,

    I have found multiple posts for this but none have worked.

    I'm trying to create an action button for multiple values of a field.  It works fine for 1 value from the list below, but I cannot seem to get the syntax right for all 2 field values below.

     Action=set values in a field

    field =  ID 

    value = '3Z'   (this works okay - for any single value from below)

    bit I need all 2 below included??

    value = '3Z' and '60'  

    (I have tried with quotes, with ";" and without, pipe separators...etc...)

     

    Thanks by advance,

     

    Show Less
  • forum

    Catalog and Lineage

    NPrint reports

    Hi! Has anyone had any issues creating a NPrint report and all the dashboard inserted on the template come out looking too wide or on 2 pages? I’ve pl... Show More

    Hi! Has anyone had any issues creating a NPrint report and all the dashboard inserted on the template come out looking too wide or on 2 pages? I’ve played with resolution settings, but no luck. Any guidance would be helpful! ty

    Show Less
  • forum

    New to Qlik Sense

    Rank maior produto vendido

    Pessoal, Bom dia Dia. Tenho os campos, Qtd vendida, Tipo da venda(Fracionada,normal,multipla e Hibrida) e produto. quero fazer  4 KPIS onde o titulo s... Show More

    Pessoal, Bom dia Dia. Tenho os campos, Qtd vendida, Tipo da venda(Fracionada,normal,multipla e Hibrida) e produto. quero fazer  4 KPIS onde o titulo seria "Produto mais vendido Fracionado" ai dentro do kpi ficaria o produto com maior qtd de venda do tipo fracionado estou usando a extensão simpleKPI.

    Show Less
  • forum

    New to Qlik Sense

    Set analysis to compare data at two differents date

    Hello, I am a beginner in Qliksense and I have a question on the use of set analysis. My data are formatted like this : [Date] , [ID], [Contract], [av... Show More

    Hello,

    I am a beginner in Qliksense and I have a question on the use of set analysis.

    My data are formatted like this : [Date] , [ID], [Contract], [availability], it is a database that record everyday if employees are available and what is their contract (CDD, CDI)

    I would like to compare two different dates in order to know how many employees are CDI and how many are CDD

    I have 2 dates picker with 2 differents alternatives states : Date1 and Date2

    I don't manage to have the correct KPI corresponding to the selected date. 

    My expression is : =Count({<Contract={'CDI'}>}Distinct ID)

    And this KPI is affected by Alternative State "Date1"

    Could you please help me ? 

     

    Show Less
  • forum

    Qlik Enterprise Manager

    SSO in QlikSense

    Hi, how can I apply the SSO in QlikSense? Thanks. Manuela
  • forum

    New to Qlik Sense

    Need pervious values without nulls

    Hi All, Scenario is like I want all the "sales score" values in customer table and if the "sales score" is null it should pick pervious date "sales sc... Show More

    Hi All,

    Scenario is like I want all the "sales score" values in customer table and if the "sales score" is null it should pick pervious date "sales score" value without null. Here it should be order by CustomerID and Date.

    E.g.

    Image2.JPG

    Can anyone help me out here to achieve this.

    Thanks in advance!!!

    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!