Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,130 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

    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

    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
  • 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

    Related Items by Invoice in Sales.xlsx example

    Hi:I'm new to Qlik Sense, and I am trying to learn from the Tutorials: https://help.qlik.com/en-US/sense/November2020/tutorials/Tutorial%20-%20Buildin... Show More

    Hi:

    I'm new to Qlik Sense, and I am trying to learn from the Tutorials: https://help.qlik.com/en-US/sense/November2020/tutorials/Tutorial%20-%20Building%20an%20App.zip

    I asking myself how I could know related items by Invoice. The idea es know which items people buy together.

    If I use SQL I can try a Self Join for Sales table. 

    I googled for "Self Join Qlik" and It seems there is no natural way to do that. 

    Maybe there is a natural way to do what I want, but it's not through a self join. 

     

    Any ideas?

     

    Show Less
  • forum

    Qlik Sense App Development

    Pivot Table with two dimensions and formulas for each case

    I cannot expand the Formulas in a pivot table.I made a Load Inline to create this two dimensions, here is the code:Valores_Financeiro:LOAD * INLINE ['... Show More

    I cannot expand the Formulas in a pivot table.

    I made a Load Inline to create this two dimensions, here is the code:

    Valores_Financeiro:
    LOAD * INLINE [
    'Tipo Valor', 'Medida', 'Fórmula Financeiro'
    'Receita', 'Descontos Obtidos', "vReceitas Descontos Obtidos"
    'Receita', 'Juros Auferidos', 'vReceitasJurosAuferidos'
    'Receita', 'Outras Receitas Financeiras', 'vReceitasOutrasReceitasFinanceiras'
    'Receita', 'Ganhos Oper. Renda Variável', 'vReceitasRendaVariavel'
    'Receita', 'Variações Monetárias Ativas' , 'vReceitasVariacoesMonetarias'
    'Receita', 'Variações Cambiais', 'vReceitasVariacoesCambiais'
    'Receita', 'Outras Receitas Operacionais', 'vReceitasOutrasReceitasOperacionais'
    'Despesa', 'Bancárias'
    'Despesa', 'Monetárias Passivas'
    'Despesa', 'Arredondamento Mercantil'
    'Despesa', 'Juros Pagos'
    'Despesa', 'Bancárias Exportação'
    'Despesa', 'Variações Cambiais'
    'Despesa', 'Perda Renda Variável'
    ];

    Here is what happens:

    8b350d88ee404a6abb4002547ffad544.png

     I need to expand the formulas, thought it was just put $([Fórmula Financeiro]) in measures but it doesn't work.

     

    With ValueList i can make this work but than if you select it doesn't select in the right way than for me it doesn't work, i need in this way because than the user can select and then it will filter.

     

    Obs: this variables contains the formulas

    Example: vReceitasDescontosObtidos contains Sum([Receitas Descontos Obtidos]/1000)

    Show Less
  • forum

    New to Qlik Sense

    Nested if in a line chart

    hi team,I am using the below expression in a line chart. I get the trend line if I select only one channel, however if i select multiple channels, the... Show More

    hi team,

    I am using the below expression in a line chart. I get the trend line if I select only one channel, however if i select multiple channels, the chart is simply blank. pl help me solve this.

    if(Channel='AMS',Sum({$<Variables={"ams_direct_cost"}>}Values),
    if(Channel='GCM',Sum({$<Variables={"gcm_direct_cost"}>}Values),
    if(Channel='FB',Sum({$<Variables={"fb_direct_cost"}>}Values),
    if(Channel='ISG',Sum({$<Variables={"isg_direct_cost"}>}Values)))))

    regards, mahe

    Show Less
  • forum

    New to Qlik Sense

    Filter selection issue with Multiple if statement

    I have written multiple if statements in two ways to create a master measure.way 1:pick(match(Account,'MTDAvgAUM','MTDEndAUM','YTDAvgAUM','YTDEndAUM')... Show More

    I have written multiple if statements in two ways to create a master measure.

    way 1:

    pick(match(Account,'MTDAvgAUM','MTDEndAUM','YTDAvgAUM','YTDEndAUM'),Sum({<Account={'MTDAvgAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount])
    ,Sum({<Account={'MTDEndAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount])
    ,Sum({<Account={'YTDAvgAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount])
    ,Sum({<Account={'YTDEndAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount]))

     

    way 2: 

    Num(
    If(Account='MTDAvgAUM', Sum({<Account={'MTDAvgAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount])
    ,If(Account='MTDEndAUM', Sum({<Account={'MTDEndAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount])
    ,If(Account='YTDAvgAUM', Sum({<Account={'YTDAvgAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount])
    ,If(Account='YTDEndAUM', Sum({<Account={'YTDEndAUM'}, [Period Date]={"$(=Max([Period Date]))"}, Period=, [Fiscal Month]=, [Fiscal Quarter]=, [Fiscal Year]=>} [Amount]),
    sum(Amount))))),'#,##0')

     

    But problem is when i am selecting account =MTDAvgAUM in filter , for rest of the if clause it giving 0 which i dont want to show. but i dont want to uncheck include zero value option also.

    I want to show only result for selected account.

     

    Please give me some idea.

     

    Thanks

    in advance.

    Show Less
  • forum

    QlikView App Dev

    For Each Loop not working

    For Each Loop not working: I am trying to load in data from a single field into a value list to use in a For Each Loop.  I can get the data loaded, bu... Show More

    For Each Loop not working:

     

    I am trying to load in data from a single field into a value list to use in a For Each Loop.  I can get the data loaded, but then when trying to use in the for each loop I keep getting the “Field ‘Dataset’ not found”.

     

    Here’s the section of code I’m working with:

    [Databases]:

    NoConcatenate

    SELECT DATABASE

      FROM SYSTEM.ADMIN.DATABASE

    where (DATABASE <> 'FIELD_INT' and DATABASE LIKE 'FIELD%');

     

    TempDatabases:

    load concat(Chr(39) & DATABASE & Chr(39), ',') as concatenatedDatabases resident [Databases];

     

    let Dataset = peek('concatenatedDatabases');

    trace $(Dataset);

     

    For each fy in FieldValueList('Dataset')

    [EMPS]:

    SELECT DISTINCT

        AA.EMP_ID_NO,

        AA.EMP_LNAME,

        AA.EMP_FNAME,

        (AA.EMP_LNAME || ', ' || AA.EMP_FNAME) AS EMP_NAME

        FROM $(fy).TABLE AA

        WHERE AA.LOCATION_ID = '42';

    NEXT

     

    After I run the code, I get the error.  If I run only this piece:

    [Databases]:

    NoConcatenate

    SELECT DATABASE

      FROM SYSTEM.ADMIN.DATABASE

    where (DATABASE <> 'FIELD_INT' and DATABASE LIKE 'FIELD%');

     

    TempDatabases:

    load concat(Chr(39) & DATABASE & Chr(39), ',') as concatenatedDatabases resident [Databases];

     

    let Dataset = peek('concatenatedDatabases');

    trace $(Dataset);

     

    I get the desired output for Dataset, which is the list of values I want to loop with:

    Lines fetched: 1

    'FIELD06','FIELD07','FIELD08','FIELD09','FIELD10','FIELD11'

     

    Please help.

    Show Less
  • forum

    New to Qlik Sense

    Loading Calculated Variable in Data Load Editor

    Hello all, I am fairly new to Qlik, and I am attempting to assign and display a Sales Group designation for each ID in my Purchasers table.  My tables... Show More

    Hello all, 

    I am fairly new to Qlik, and I am attempting to assign and display a Sales Group designation for each ID in my Purchasers table.  My tables look something like this and are imported via flat file: 

    Purchasers:

    CustomerID    Name       Region

    1                           John           A

    2                           Jane           G

    3                           Jacob         X

    .

    .

    .

    Transactions:

    TransactionID      CustomerID            Name            Amount

    1                                           2                        Jane                  40

    2                                           1                        Jacob              100

    3                                          2                          Jane                  20

    4                                           2                         Jane                  10

    .

    .

    .

    In the data load editor, I want to create a column that assigns a group to each CustomerID based on definitions created using IF THEN ELSEIF statements in the Purchasers table.  I use the Transactions table to append some calculated transaction summaries to the Purchasers table (which works), and I need to use those calculated columns for the sGroup classification as well.  When I am done with the Transaction table summaries, I am dropping the Transactions table.  This is similar to what I have so far:

    Load * From Purchasers;

    Load * From Transactions;

    ---script that does transaction calculations per purchaser, columns are now loaded to Purchasers table---

    DROP TABLE Transactions;

    FOR EACH x in FieldValueList('CustomerID')
    LET sGroup=Null(); 

    IF Region='A' AND sTotal>50 THEN
    LET sGroup=010;
    Concatenate
    GROUP:
    LOAD x AS [CustomerID], sGroup AS [Sales Group];

    ELSEIF Region='B'  AND sTotal > 50 THEN
    LET sGroup= 020;

    Concatenate
    GROUP:
    LOAD x AS [CustomerID], sGroup AS [Sales Group];
    .

    .

    .

    ELSEIF Region='AA' AND sAvg>100 THEN 

    LET sGroup= 270;

    Concatenate
    GROUP:
    LOAD x AS [CustomerID], sGroup AS [Sales Group];

    ELSE
    ENDIF
    NEXT ID

    All of the other community posts I have found are resorting back to nested if statements in the initial table load, but I have so many different groups that need to be assigned and my definitions are also based on other calculations from the Transactions table.  I have written something similar in SQL using the CASE statement, and the IF THEN ELSEIF seems to be Qlik's closest match to that.  The script loads just fine, but I do not see the Sales Group column in my final Purchasers table.  I am not sure if I need to create this GROUP temp table to concatenate/left join to my Purchasers table or if there is a way to INLINE this sGroup value (which is fixed for the logic definitions) into the Purchasers table for the current CustomerID that the For Each Loop is currently evaluating. 

    Any help would be greatly appreciated!  Thank you in advance!!! 

    Show Less
  • forum

    Qlik Sense App Development

    set analysis for multiple condition in dimension

     I would like to ensure my pivot table exclude [name] where[t0 CRR]=[t1 CRR] and[t0 impr stg] = [t1 impr stg] (row in Red font). I have tried to use b... Show More

     

    I would like to ensure my pivot table exclude [name] where

    [t0 CRR]=[t1 CRR] and

    [t0 impr stg] = [t1 impr stg] (row in Red font).

     

    I have tried to use below set analysis in Dimension but it does not work.  The result returns one null row.  

    Would need guidance from experts again.  Many thanks as always.

    =aggr(only({<[t1 CRR]-=[t0 CRR]>,[t1 Impr Stg]-=[t0 Impr Stg]}[name]),[name])

    namet0 CRRt1 CRRt0 Impr Stgt1 Impr Stgt1_Amt HKD000
    230270-2.1-0299686.689
    2302702.1-0-0
    1293142.22.200-1.609
    1293142.22.2018324999.999
    1293142.22.210-1.609
    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