Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,296 online
Announcements
Login changes complete, Login with email not username. READ DETAILS/WATCH VIDEO

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    QlikView App Dev

    Date manipulation in script

    Hi,I have this script and it is not working.tan:LOAD * INLINE [F1, F209/07/2021, ren09/05/2021, rte];tan1:load * Resident tanWhere F1 > date('09/06/20... Show More

    Hi,

    I have this script and it is not working.

    tan:
    LOAD * INLINE [
    F1, F2
    09/07/2021, ren
    09/05/2021, rte
    ];

    tan1:
    load * Resident tan
    Where F1 > date('09/06/2021', 'MM/DD/YYYY');

    DROP TABLE tan;

     

    I was expecting the table 'tan1' to have only the first row but tan1 is not even getting created.

    what is wrong with it?

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    Last business date

    Hi qlikssi have 2 dates : date, business datethis is separate qvd with 2 dates   date               business date5/8/2021.      5/7/20215/18/2021.    ... Show More

    Hi qlikss

    i have 2 dates : date, business date

    this is separate qvd with 2 dates   

    date               business date

    5/8/2021.      5/7/2021

    5/18/2021.    5/18/2021

    i have filter in my app that uses today’s date as overall filter on date field, but it has to pick up business date when todays date is not business date.  Suggest me.


    in my app

    Where date= date(today ());

    Show Less
  • forum

    Deployment & Management

    Update/Installation documentation

    Where is the documentation  to upgrade to the May update release?  Currently on June 2020
  • forum

    QlikView App Dev

    Transposing data in Qlikview

    Hi, I currently have an excel dataset and am trying to transpose the data as shown below but in Qlikview. Any ideas on how this can be achieved would ... Show More

    Hi, 

    I currently have an excel dataset and am trying to transpose the data as shown below but in Qlikview. Any ideas on how this can be achieved would be greatly appreciated!

    Before:

    NameGo KartingDate CompletedScuba DiveDate CompletedZip lineDate CompletedSkydiveDate Completed
    JohnYes18/05/2021No Yes23/10/2020No 
    LucyYes09/02/2019Yes23/09/2020No Yes23/04/2021
    DanielNo No No Yes15/09/2019
    SarahNo No No No 
    SamanthaNo Yes13/08/2019No Yes04/07/2021
    JamesNo Yes20/04/2020Yes13/12/2020Yes06/03/2019

     

    After:

    NameActivityDate completed
    JohnYes18/05/2021
    LucyYes09/02/2019
    DanielNo 
    SarahNo 
    SamanthaNo 
    JamesNo 
    JohnNo 
    LucyYes23/09/2020
    DanielNo 
    SarahNo 
    SamanthaYes13/08/2019
    JamesYes20/04/2020
    JohnYes23/10/2020
    LucyNo 
    DanielNo 
    SarahNo 
    SamanthaNo 
    JamesYes13/12/2020
    JohnNo 
    LucyYes23/04/2021
    DanielYes15/09/2019
    SarahNo 
    SamanthaYes04/07/2021
    JamesYes06/03/2019

     

    Many thanks

    Dilpreet 

    Show Less
  • forum

    QlikView App Dev

    Split a field

    Hi all,I have the following table of fields as an example:Field_1Field_2Field_3Field_4AA1... AA1  AA2  BB1  BB2  BB2  CC1  CC1  CC2 ... I want to spli... Show More

    Hi all,

    I have the following table of fields as an example:

    Field_1Field_2Field_3Field_4
    AA1... 
    AA1  
    AA2  
    BB1  
    BB2  
    BB2  
    CC1  
    CC1  
    CC2 ...

     

    I want to split Field_2  into subfields by values of Field_1, like:

    Field_A
    A1
    A2
    A3

     

    Field_B
    B1
    B2
    B3

     

    Field_C
    C1
    C2
    C3

     

    The end user can select from the new fields one value (as an example: A1,B1,C1).

    Field_2 should highlight A1,B1,C1 (should recognize the choosen values from its subfields).

    The end user can select now one or more than value from A1,B1,C1 in field_2.

     

    Any help please?

     

    Thanks in advance.

    Show Less
  • forum

    New to Qlik Sense

    Invalid Expression

    I'm getting an invalid expression error in this section, but I'm very new to this and don't know what I'm doing wrong. Please advise! ConcatenateLOAD ... Show More

    I'm getting an invalid expression error in this section, but I'm very new to this and don't know what I'm doing wrong. Please advise!

     

    Concatenate

    LOAD DISTINCT
    [!1],
    SPCode,
    PROD_CD_GRP AS RATE_SERIES_AC,
    PLAN_CODE,
    'XXXXXXXXXX' AS SORCE_POLCY_ID,
    AS_OF_DATE,
    WELLNESS_BENEFIT,
    PLAN_TYPE,
    PLAN_LEVEL,
    COMPANY,
    MARKET_SEGMENT,
    SEX,
    AVG(UNITS) AS UNITS,
    RIDER AS COVG_IND,
    '' as ISSUE_ST,
    AGE_AT_ENTRY,
    '$(vYear)' as ENTRY_YEAR,
    1 as ENTRY_MONTH,
    1 as ENTRY_DAY,
    ((avg(ANNUAL_PREM))/(avg(UNITS))) AS ANN_PREM_PU,
    'XXXXXXXX' AS ORG_BCN,
    'XXXXXXXX' AS CURR_BCN,
    12 AS PREM_FREQ,
    SUM(INIT_COV_COUNT) AS INIT_POLS_IF,
    IF(FAMILY_CD='0','1',FAMILY_CD) AS FAMILY_TYPE,
    5 AS GTEE_PER_Y,
    ACC_EP,
    SICK_EP,
    100 AS COVERAGE_TERM_AGE,
    (sum(WOP_BENFT_AMNT))/(sum(UNITS)) AS WOP_BENFT_AMNT_PU,
    MAX(GAAP_LKUP_ALR_MORBD),
    MAX(GAAP_LKUP_ALR_LAPSE),
    MAX(GAAP_LKUP_ALR_MRTLY),
    MAX(GAAP_LKUP_ALR_INT_RATE),
    MAX(STAT_LKUP_ALR_MORBD),
    MAX(STAT_LKUP_ALR_LAPSE),
    IF(DEFAULT = 'Y', '190001', MAX(STAT_LKUP_ALR_MRTLY)) AS STAT_LKUP_ALR_MRTLY,
    '' AS COHORT_CD,
    '' AS INIT_DAC_EXPNS_VOL,
    '' AS INIT_DAC_CMMSN_VOL
    RESIDENT ACCIDENT_STAT_MORT1
    WHERE (ISSDATE >= STAT_LKUP_ALR_MRTLY AND ISSDATE <= STAT_MAX_ALR_MRTLY) OR DEFAULT = 'Y'
    ORDER BY SPCode;

    Show Less
  • forum

    QlikView App Dev

    Multiple different of in set analysis

    Hello I learned by this forum that we could use -= to do an exclusion in set analysis but when i try to use it with a or to make 2/3 excluding that do... Show More

    Hello 

    I learned by this forum that we could use 

    -= to do an exclusion in set analysis but when i try to use it with a or to make 2/3 excluding that doesn't work 

    if Someone could make me learn how to make work multiple excluding in set analysis ? 😛 

     

    Thanks a lot for reading 😛

    Show Less
  • forum

    QlikView App Dev

    Table border not working in - nprinting edit report template

    Hi there,I am unable to border my excel report in nprinting edit report template.req is below : result: I used the border when creating edit report te... Show More

    Hi there,

    I am unable to border my excel report in nprinting edit report template.

    req is below :

    req1.PNG

     

    result:

    res1.PNG

     

    I used the border when creating edit report template.

    cre1.PNG

    Show Less
  • forum

    Deployment & Management

    How to edit table selection after created under DataTransfter?

    How to edit table selection after created under DataTransfter?
  • forum

    Qlik NPrinting Discussions

    Qlik Nprinting powerpoint color using master measure

    I am using master measures in Qlik Sense to create a bar chart and the master measure has a color applied. In Nprinting I am bringing this into a tabl... Show More

    I am using master measures in Qlik Sense to create a bar chart and the master measure has a color applied. In Nprinting I am bringing this into a table object. The "Keep source format" is checked, however the color set in the Qlik Sense chart is not seen in the Nprinting chart. I want to be able to add expressions to set the color, as doing it manually is very cumbersome. If this is not possible, is there a syntax available to set the color when the "Keep source format" is unchecked?

    Please let me know.

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about QlikView.

May 18, 2021 10AM EST

Events

Qlik Insider - Webinar Series

This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.

May 26, 2021