Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
583 online

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

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

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion board and documents related to Qlik Associative Big Data Index.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

Recent Discussions

  • New to Qlik Sense

    Prior year sales not calculating

    Hello,I am trying to do a KPI chart that compares YTD sales v PYTD sales but I am getting nil for PYTD no matter what I try. What I have at the moment... Show More

    Hello,

    I am trying to do a KPI chart that compares YTD sales v PYTD sales but I am getting nil for PYTD no matter what I try. What I have at the moment is:

    1) A variable - vTodayPriorYear = date(addyears(max(Today()),-1),'DD/MM/YYYY')

    2) Expression - SUM({$< Year={'$(vPriorYear)'}, CalDate={'<=$(vTodayPriorYear)'} >} [Gross sales value])

    If I remove the bold section of the expression above, I get all the sales for the prior year but once added, I get zero. In the edit expression window I am getting OK & SUM({$< Year={'2018'}, CalDate={'<=17/11/2018'} >} [Gross sales value]) so from that I know the variable is working.

    How can I determine where this is falling over?

    Show Less
  • New to Qlik Sense

    Week Quarter and Month

    Hello,I would like to set the month, week and quarter fallow the images But when I changed data load manager in Qlik Sense. I changed from month/3 int... Show More

    Hello,

    I would like to set the month, week and quarter fallow the images

    QWeek.jpg

     

    But when I changed data load manager in Qlik Sense. I changed from month/3 into week/13. It's turn out into this image down here.

    MonthWeekQ.jpg

     

    Green one show weeks in Jan as 5 weeks and red one also duplicate the week 9. How can I fix this and change the form into image up there. Thank you in advance

    Show Less
  • New to Qlik Sense

    Retry Mechanism

    In my dash board i am trying to connect the retry mechanism but it is not working below is the code what i am using (using the REST connection)Set Ret... Show More

    In my dash board i am trying to connect the retry mechanism but it is not working below is the code what i am using (using the REST connection)

    Set Retrycount=4;

    Set LocalscriptErrorcount=0;

    Do

    Set ScriptErrorCount=0;

    Lib Connection..................

    <   MY Script  >

    Drop Table;

    IF ScriptErrorCount>0 Then

    Let LocalScriptErrorCount=$(LocalScriptErrorCount)+1;

    Else

    Set LocalScritpErrorCount=0;

    End IF

    Loop while Mod(LocalScriptErrorCount,Retrycount)<>0; 

    can you please help the code

     

    Can you please help me the correct code.I am explain very clearly i have connection,In that it is running 100 Quries.

    1,2,3.....................100.The query is running up to 70th after that connection is failed so i have to apply the Retry mechanism Here .It will be start from the 70th query not from the 1st could you please explain the code please?

    Show Less
  • QlikView Creating Analytics

    How to load this excel file

    Hi QV Community,i have an excel file like attached. the data is available on more than one excel tab ( in my real data, there are 8 Tabs) and i need t... Show More

    Hi QV Community,

    i have an excel file like attached. the data is available on more than one excel tab ( in my real data, there are 8 Tabs) and i need to extract the data from all tabs  at once (maybe with a loop..) in order to get the desired result. Please have alook at the attached excel file including inputs and expecteted result.

    every help is appreciated!

    thx in advance

    Show Less
  • QlikView Scripting

    How to use if and else command for select which portion of script to load ?

    Hi AllI have below script work fine.Some time i need to only run country A. what i do is manually go to country B script comment it.May i know how to ... Show More

    Hi All

    I have below script work fine.

    Some time i need to only run country A. what i do is manually go to country B script comment it.
    May i know how to using if then else command to handle it , so that i can just enter 1 or 2 to select which country to run.
    Hope some one can advise me.

    Paul Yeo

    // sales COUNTRY A
    sales:
    LOAD left(FileBaseName(), 4) AS Report_dod_1,
    @50:60T as [date],
    'TDS' as SOURCE,
    if(@241:248T = '2',@134:147T*-1,@134:147T) as [sales]
    FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_RAW\Q_DOD_2018.txt (ansi, fix, no labels, header is 0, record is line);

    // sales COUNTRY B
    Concatenate
    LOAD
    'PMC' as SOURCE,
    Date( Date#([AR Invoice Date], 'DD.MM.YY'), 'DD/YY/YYY') as [date],
    [Customer Name] AS COMPANY,
    [Row Total (SGD)] as sales
    FROM [C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\SO_PMC_2019.xlsx]
    (ooxml, embedded labels, table is SO_PMC_2019);

    // AR COUNTRY A
    Payment:
    LOAD
    'TDS' as SOURCE,
    @1:9T as [cust_id_ar],
    left(@10:38T,25) as [company_ar],
    if(right(@73:90T,1)='-', '-' & left(@73:90T, len(@73:90T)-1),@73:90T) as total_ar,
    Today() - @98:110T as [total number of day due]

    FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_RAW\AR_Aging.TXT (ansi, fix, no labels, header is 0, record is line);

    // AR COUNTRY B
    Concatenate
    LOAD
    'PMC' as SOURCE,
    [Customer/Vendor Code] as [cust_id_ar],
    [Customer/Vendor Name] as company_ar,
    Today() - Date( Date#([AR Invoice Date], 'DD.MM.YY'), 'DD/YY/YYY') as [total number of day due],
    [Outstanding w/o Tax (LC)] as total_ar
    FROM [C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\AR_PMC.xlsx]
    (ooxml, embedded labels, table is AR_PMC);

    tmp:
    LOAD
    min(date) AS MinDate,
    max(date) AS MaxDate
    RESIDENT sales;
    MaxMinDate:
    NOCONCATENATE LOAD
    MIN(MinDate) AS MinDate,
    MAX(MaxDate) AS MaxDate
    RESIDENT tmp;
    DROP TABLE tmp;
    LET varMinDate = Num(Peek('MinDate'));
    LET varMaxDate = Num(Peek('MaxDate'));
    LET vToday = num(today());
    DROP TABLE MaxMinDate;
    //*************** Temporary Calendar ***************
    TempCalendar:
    LOAD
    $(varMinDate) + rowno() - 1 AS Num,
    date($(varMinDate) + rowno() - 1) AS TempDate,
    date($(varMinDate) + rowno() - 1) AS D,
    year($(varMinDate) + rowno() - 1) AS Y,
    month($(varMinDate) + rowno() - 1) AS M,
    date(monthstart($(varMinDate) + rowno() - 1), 'MMM-YYYY') AS MY
    AUTOGENERATE $(varMaxDate) - $(varMinDate) + 1;

    MasterCalendar:
    LOAD TempDate AS date,
    day([TempDate]) as [day],
    num(month([TempDate])) as [month],
    Y AS year
    RESIDENT TempCalendar
    ORDER BY TempDate ASC;
    DROP TABLE TempCalendar;

    Show Less
  • QlikView Scripting

    Why Qlik View still remember my OLD script ?

    Hi AllMy below script work fine , only issue is when i try to rename the excel TAB name from BRAND to COUNTRY_A it have issue.The Situation :-if i cha... Show More

    Hi All

    My below script work fine , only issue is when i try to rename the excel TAB name from BRAND to COUNTRY_A it have issue.
    The Situation :-

    if i change from :-
    FROM C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand.xlsx (ooxml,embedded labels, table is [BRAND]);
    To below :-
    FROM C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand.xlsx (ooxml,embedded labels, table is [COUNTRY_A]);

    i Will keep same Erroe Massage Below :-

    Field not found - <Brand_>
    MapDescTDS:
    Mapping LOAD
    [Brand_],
    [SubBrand_]
    FROM C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand.xlsx(ooxml,embedded labels, table is [COUNTRY_A])

    When i have change excel Tab name from BRAND TO COUNTRY_A
    and below :-
    FROM C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand.xlsx (ooxml,embedded labels, table is [COUNTRY_A]);

    it there any other work around ?

    Hope some one can advise me.

    Paul Yeo

    MapDesc:
    Mapping LOAD
    [Brand_],
    [SubBrand_]
    FROM MapBrand.xlsx (ooxml,embedded labels, table is [TDS]);

    // sales COUNTRY A
    sales:
    LOAD left(FileBaseName(), 4) AS Report_dod_1,
    @50:60T as [date],
    'TDS' as SOURCE,
    ApplyMap('MapDesc',@282:298T,'OTHERS') as [BRAND_C],
    @282:298T as [BRAND],
    if(@241:248T = '2',@134:147T*-1,@134:147T) as [sales]
    FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_RAW\Q_DOD_2018.txt (ansi, fix, no labels, header is 0, record is line);


    tmp:
    LOAD
    min(date) AS MinDate,
    max(date) AS MaxDate
    RESIDENT sales;
    MaxMinDate:
    NOCONCATENATE LOAD
    MIN(MinDate) AS MinDate,
    MAX(MaxDate) AS MaxDate
    RESIDENT tmp;
    DROP TABLE tmp;
    LET varMinDate = Num(Peek('MinDate'));
    LET varMaxDate = Num(Peek('MaxDate'));
    LET vToday = num(today());
    DROP TABLE MaxMinDate;
    //*************** Temporary Calendar ***************
    TempCalendar:
    LOAD
    $(varMinDate) + rowno() - 1 AS Num,
    date($(varMinDate) + rowno() - 1) AS TempDate,
    date($(varMinDate) + rowno() - 1) AS D,
    year($(varMinDate) + rowno() - 1) AS Y,
    month($(varMinDate) + rowno() - 1) AS M,
    date(monthstart($(varMinDate) + rowno() - 1), 'MMM-YYYY') AS MY
    AUTOGENERATE $(varMaxDate) - $(varMinDate) + 1;

    MasterCalendar:
    LOAD TempDate AS date,
    day([TempDate]) as [day],
    num(month([TempDate])) as [month],
    Y AS year
    RESIDENT TempCalendar
    ORDER BY TempDate ASC;
    DROP TABLE TempCalendar;

    Show Less
  • New to Qlik Sense

    Avg Function Not producing expected results

    I have a data set that has the following information Sum(TAT) = 8635Count(TAT) = 2When I do an average either using Avg function or SUM/Count my expec... Show More

    I have a data set that has the following information 

    Sum(TAT) = 8635

    Count(TAT) = 2

    When I do an average either using Avg function or SUM/Count my expected value is  4317.5

    But for some reason, I am getting, 179.89

    Can someone help me with this weird issue?

    Many Thanks.

     

    Show Less
  • New to Qlik Sense

    Avg function not producing the correct value

    Qlik Sense Question: The avg function is not producing the correct value. I have an app that contains two sheets. The first sheet is made up of visual... Show More

    Qlik Sense Question:

    The avg function is not producing the correct value.

    I have an app that contains two sheets. The first sheet is made up of visualizations and filters, and the second page is a table which contains every dimension (no measures or calculations).

    I select my desired filters, and then confirm the total amount of rows on the second sheet's table (it correctly matches the total counts from the first page). One column in this table is annual_salary. If I use the average function (annual_salary), I receive a number that does not match excel's average function on the same column.

    Note:

    1. The table is set to display all null values.

    2. The column does not contain any 0's, or nulls.

    Has anyone encountered similar issues with the avg function?

    Show Less
  • Qlik Sense Cloud Discussions

    Qlik Sense Business connection lost constantly

    I am developing in Qlik Sense Business, and constantly get either one of the below messages. When I say constantly, I mean about every 5 minutes. Ever... Show More

    I am developing in Qlik Sense Business, and constantly get either one of the below messages. When I say constantly, I mean about every 5 minutes. Every time you need to do a refresh or close, your last changes are gone. The machine is not left idle, I am working on a new App. 

    I have a fibre line with 20g upload and down load. I also have a 4G standby router. The issue is the same no matter which service I use. I have done the rebooting of the router thing!

    Has any experienced the issue and found a solution? If so, please can you share your solution. Thank you.

    Capture.JPG

    Show Less
  • New to Qlik Sense

    Bar chart with 2 dimensions

    How do I develop a bar chart with 2 dimensions. I can easily do this in excel but couldn't do in Qlik sense. Could someone help.uid dim1 dim21 yes no2... Show More

    How do I develop a bar chart with 2 dimensions. I can easily do this in excel but couldn't do in Qlik sense. Could someone help.

    uid dim1 dim2
    1 yes no
    2 yes yes
    3 no no
    4 no yes
    5 yes no
    9 no no

    output:

    11-14-2019 5-03-53 PM.png

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

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

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

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

750+ Members

Events

Qlik Insider Webinar

Join the last Qlik Insider Webinar of 2019, where our experts will discuss the latest features and capabilities in Qlik's platform.

November 20, 2019 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Data Revolution Tour

Discover how to transform your entire data value chain for deep insights at unprecedented speed.

Find a location One Day Event