Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,258 online
Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW

Data Analytics Forums

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

Data Integration Forums

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.

Product Insight & Ideas

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 Qlik Community

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

    New to Qlik Sense

    grouping articles

    In my app, I have a pivot table that looks like this:Name    AgeMary      10Ann        11Jane      12Jack       3John      6Peter     5I need to group... Show More

    In my app, I have a pivot table that looks like this:

    Name    Age

    Mary      10

    Ann        11

    Jane      12

    Jack       3

    John      6

    Peter     5

    I need to group Girls and Boys to have something like

    Girls    33

    Boys    14

     

    The entire list of names is pretty long. Is there a more elegant way to write the formula then repeating if statement?

    Thank you very much in advance

     

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense

    When I try to access Qlik Sense, I have to apply a link or translate an qr image, but I can't open my Qlik Sense environment to work, creating my apps... Show More

    When I try to access Qlik Sense, I have to apply a link or translate an qr image, but I can't open my Qlik Sense environment to work, creating my apps as usually, in previous releases of Qlik Sense.

    I look help and forum, but I don't get the right way to access.

    I don't understand how an access layer has been added so complex that it really has nothing to do with the application, but that makes it difficult to use it.

     

    Show Less
  • forum

    New to Qlik Sense

    Selection disabling on sheet visualizations

    Hi all,In bar chart if i clicks on bar it select the bar and it filters the sheet through the value of the bar,Is it possible to disable the selection... Show More

    Hi all,

    In bar chart if i clicks on bar it select the bar and it filters the sheet through the value of the bar,

    Is it possible to disable the selection on charts.

    Thanks,

    Pramod

    Show Less
  • forum

    Qlik Sense App Development

    Concatenate two columns from two qvd files

    Hello.I am creating an app, using three qvd files.my script is:LOAD    %0MATERIAL,    %0MAT_SALESFROM [1.qvd](qvd);Load    %0MATERIAL,    "Corporate R... Show More

    Hello.

    I am creating an app, using three qvd files.

    my script is:

    LOAD
        %0MATERIAL,
        %0MAT_SALES
    FROM [1.qvd]
    (qvd);

    Load
        %0MATERIAL,
        "Corporate Reporting Group (Material)"
    FROM [2.qvd]
    (qvd);

    LOAD
        %0MAT_SALES,
         "Local product hierarchy 2",
    FROM [3.qvd]
    (qvd);

     

    I need a field, which would be a combination of  "Corporate Reporting Group (Material)" and  "Local product hierarchy 2"

    I understand I need to write something like "Corporate Reporting Group (Material)"&' '&"Local product hierarchy 2" as NewField, but where and how exactly?

    Thank you very much in advance

     

    Show Less
  • forum

    Qlik Sense App Development

    Min value for each hour

    Hello,Please advise how can I recive the Min sales per Hour as in the bellow example.:  Thank you,Alona
  • forum

    New to Qlik Sense

    Simple Table extension help

    Hi All,I'm using below simple table extension to show the product picture as column value it's working fine but this extension dosn't have  below feat... Show More

    Hi All,

    I'm using below simple table extension to show the product picture as column value it's working fine but this extension dosn't have  below feature. if you have update coded can you share it Thanks

    Qlik Branch

    1) column header disappear While scrolling the report

    2) There is no sub Total feature in this extension

    FYI, below report have Product ,Product Picture and  Color and looking for the sub total at Product level and header missing while scrolling. can anyone help me on this. @

    Capture.JPG

    Show Less
  • forum

    Qlik Sense SaaS & Multi-Cloud

    How to download data from source file .mdb (Access) ?

    How to download data from source file .mdb (Access) ?
  • forum

    Qlik Sense App Development

    Disregarding chart dimension (x axis)

    Hi Qlik expertsNeed help on one use case.Requirement: A simple bar chart with 1 dimension and 1 measureBar chart X axis  (Dimension) is column : Statu... Show More

    Hi Qlik experts

    Need help on one use case.

    Requirement: A simple bar chart with 1 dimension and 1 measure

    Bar chart X axis  (Dimension) is column : Status 

    (Having 3 values: Green ,Red ,Amber)

    Y axis (Measure) : Distinct count of GroupID

    However the measure must be such that, when GroupID has more than 1 status available, only the highest available Status is counted for.

    (Red > Amber > Green)

    1 Filter object on the sheet : RecordDate

     

    Example data:

     

    StatusRecordDate GroupID Remarks (for explanation purpose) - not a data
    Green2/1/20RECD001 
    Amber3/1/20RECD001 only this Status must be considered for RECD001 (unless RecordDate selected is 2/1/20. In that case OK to have 1 Green status counted for)
    Green4/1/20RECD001 this Status  must be not considered for RECD001 since the Amber Status being higher. (unless RecordDate selected is 2/1/20. In that case OK to have 1 Green status counted for)
    Green3/1/20RECD002 
    Amber4/1/20RECD002for this RECD002, Green status  should not be considered (unless date selected is 3/1/20)
    Amber3/1/20RECD003 
    Amber3/1/20RECD004 
    Green2/1/20RECD005 
    Red4/1/20RECD005When 4/1/20 or 2/1/20 is selected, RECD005 should be only counted against Red (and not Green)
    Amber2/1/20RECD006 
    Green3/1/20RECD006When 3/1/20 or 2/1/20 is selected, RECD006 should be only counted against Amber (and not Green)

     

    expected bar chart output (when no record date is selected):

     

    Barchart_example.PNG

     

    So far I have tried FirstSortedValue,  AGGR  along with TOTAL qualifier and even Only function. It feels I am close but not yet fully there!

    Thanks in advance!

    Show Less
  • forum

    QlikView App Dev

    Unique Rolling Years Based on Another Field

    Hello all:I'm fairly new to app development, and this is my first time posting on the forums, so please excuse any errors/exclusions.I am trying to bu... Show More

    Hello all:

    I'm fairly new to app development, and this is my first time posting on the forums, so please excuse any errors/exclusions.

    I am trying to build a table in my data model that will link to my main data table that provides unique rolling years for multiple states, along with a year index that can be used in calculations in my app. My ideal table would look something like this, with the StateQuarterCombo column being the key field that was previously calculated:

    StateQuarterComboRolling YearWAyear.idxWYyear.idx
    WA|2020Q1Q2 2019 - Q1 20202 
    WA|2019Q4Q2 2019 - Q1 20202 
    WA|2019Q3Q2 2019 - Q1 20202 
    WA|2019Q2Q2 2019 - Q1 20202 
    WA|2019Q1Q2 2018 - Q1 20191 
    WA|2018Q4Q2 2018 - Q1 20191 
    WA|2018Q3Q2 2018 - Q1 20191 
    WA|2018Q2Q2 2018 - Q1 20191 
    WY|2020Q3Q4 2019 - Q3 2020 2
    WY|2020Q2Q4 2019 - Q3 2020 2
    WY|2020Q1Q4 2019 - Q3 2020 2
    WY|2019Q4Q4 2019 - Q3 2020 2
    WA|2019Q1Q4 2018 - Q3 2019 1
    WA|2018Q4Q4 2018 - Q3 2019 1
    WA|2018Q3Q4 2018 - Q3 2019 1
    WA|2018Q2Q4 2018 - Q3 2019 1

     

    Unfortunately, I haven't had much luck with any coding I've tried so far. Would you have any tips on how I might start to construct this?

    Thank you very much!

    Show Less
  • forum

    New to Qlik Sense

    Create calculation after joining tables in script

    I have outer join 2 tables one as current period and one as last period.  After joining, I need to do calculation using the joined data.  May I know h... Show More

    I have outer join 2 tables one as current period and one as last period.  After joining, I need to do calculation using the joined data.  May I know how I do it in script?

    I have invalid expression in the below script:

    [FTP]:
    LOAD
    Period,
    "Ip Shrt Name Ith",
    "Arr Lcl Num Ath",
    "Global Sic Code" as t0_SicCode,
    "Month, Day, Year of Glbl Trade Date" as t0_TradeDate,
    "Month, Day, Year of Maturity Date" as t0_Maturity,
    "Credit Grade Code" as t0_CRR,
    amt as t0_Amt
    FROM [lib://Loan/QS test1.xlsx]
    (ooxml, embedded labels, table is Sheet1);


    Outer join

    LOAD
    "Arr Lcl Num Ath",
    Period as t1_period,
    "Ip Shrt Name Ith",
    "Global Sic Code" as t1_SicCode,
    "Month, Day, Year of Glbl Trade Date" as t1_TradeDate,
    "Month, Day, Year of Maturity Date" as T1_maturity,
    "Credit Grade Code" as t1_CRR,
    amt as t1_Amt

    FROM [lib://Loan/QS test2.xlsx]
    (ooxml, embedded labels, table is Sheet1);

     


    [New]:
    Load*,

    sum(t1_Amt) - sum(t0_Amt) as Var

    Resident [FTP] group by "Arr Lcl Num Ath";


    Drop Table [FTP];

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

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.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand