Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,059 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.

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

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

Information about additional Qlik opportunities and offerings.

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

Discussion Boards and Documents for Qlik Services.

View our Technical Blogs for updates and information.

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.

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.

The Qlik Analytics Tour


AI in Action - The Qlik Analytics Tour


Looking for fresh approaches to using data – and using it to lead? Wish you could give everyone in your organization the power to drive competitive edge? Join us for AI in Action: The Qlik Analytics Tour, where we’ll explore the revolutionary new ways businesses are using the Qlik Sense® analytics platform to transform, reinvent, and pull ahead of the pack.

Recent Discussions

  • New to QlikView

    Average at max dates

    I need to calculate the average of a set of data at the latest recording date and then the last three recordings- can you help with the expressions?Da... Show More

    I need to calculate the average of a set of data at the latest recording date and then the last three recordings- can you help with the expressions?

    Data looks like...  (excel copy attached)

    IDBatch NoDate InDLWG

     

    and I would like to create

    Latest batch3 batch average
    1.11  (avg(DLWG))1.02

     

    I have tried: 

    Avg({$<[DATE IN]={'$(=Max[DATE IN])'}>} DLWG1)

    Thanks

    Show Less
  • Qlik GeoAnalytics Discussions

    Territories not getting mapped

    Hello Team,I am using my shape file for Market territories to be shown on Map. Every Market territory is getting mapped on map. Now, i need to show te... Show More

    Hello Team,

    I am using my shape file for Market territories to be shown on Map. Every Market territory is getting mapped on map. Now, i need to show territories only in the map. Territories are getting failed while showing them on map. Not sure why!

    In the attached snapshot, you can see the 2 straight tables:

    1: Dist_Code and Dist_Name are columns from Shape File.

    2: Territory Code and Territory Name are columns from Client data. 

    Does mismatch of Territory Code and DistCode is the reason for Territories not getting mapped?

    Show Less
  • New to Qlik Sense

    SET formatting - UK Format

    Hello,It's a really basic question and help request as it would probably need just a copy paste from an UK user 🙂 !I'm having the french version of t... Show More

    Hello,

    It's a really basic question and help request as it would probably need just a copy paste from an UK user 🙂 !

    I'm having the french version of the formating:

    SET ThousandSep=' ';
    SET DecimalSep=',';
    SET MoneyThousandSep=' ';
    SET MoneyDecimalSep=',';
    SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
    SET TimeFormat='hh:mm:ss';
    SET DateFormat='DD/MM/YYYY';
    SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
    SET FirstWeekDay=0;
    SET BrokenWeeks=0;
    SET ReferenceDay=4;
    SET FirstMonthOfYear=1;
    SET CollationLocale='fr-FR';
    SET CreateSearchIndexOnReload=1;
    SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
    SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
    SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
    SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';
    SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

     

    And I would need it with the UK standard... (date in am/pm), GBP, standard UK formatting, etc... So if anyone have it, I would be really grateful !

     

    Thanks by advance,

    Best regards,

     

    Antoine

    Show Less
  • New to QlikView

    Qlik-Sense-D3-Visualization-Library-master Error.

    Hi, I have Extension Qlik-Sense-D3-Visualization-Library-master. I downloaded from Qlik Brach. I added Qliksensed Desktop. I have file ... Show More

    Hi,

     I have Extension Qlik-Sense-D3-Visualization-Library-master. I downloaded from Qlik Brach. I added Qliksensed Desktop. 

    I have file and loaded the data.

    I am able to add only 3 Di mentions and 1 measures and chart type= Collapsible Dendrogam

    But, when I tried to add 4th dimention the extension throwing error like below and since I am not JS developer. Not able to understand  what is the issue

     

    I attached extension as well and please check and let me know

     

    Error: Invalid value for <g> attribute transform="translate(NaN,undefined)"ta.transform @ d3.min.js:4
    d3.min.js:5 Error: Invalid value for <path> attribute d="M0,359.03108992CNaN,0.803340288 NaN, NaN,"(anonymous function) @ d3.min.js:5

    Show Less
  • Qlik Sense App Development

    Calculated Dimension

    Hi,I'm trying to create a chart that has -Top 50% of countries+ AustraliaThe following works when there is no selection=Aggr( DISTINCT If( RangeSum... Show More

    Hi,

    I'm trying to create a chart that has -

    1. Top 50% of countries
    2. + Australia

    The following works when there is no selection

    =Aggr( DISTINCT
      	If( RangeSum( Above(Sum({$<RecType={2}, CountryFlag={1}, UoM={'MT'}>} Quantity), 1, RowNo() ))
                   	      / Sum({$<RecType={2}, CountryFlag={1}, UoM={'MT'}>} TOTAL Quantity) < 0.5
    	OR Country='Australia'
          ,Country )
    //    sorted structure parameter
          ,(Country,(=Sum({$<RecType={2}, CountryFlag={1}, UoM={'MT'}>} Quantity),Desc))
        )

    but when I select 'Europe' I only get Russia & Germany which is correct for the 50% part, but can't add Australia. (i.e. I want Australia regardless of where it comes in the rankings) I tried using a reference line but that didn't work either.

    Any ideas would be appreciated.

    Show Less
  • New to Qlik Sense

    Is there a way to show data types in a table from a xml file ???

    I am trying to load data from a xml file to make a table but i also want to display the data types of the values present in my table. is there any way... Show More

    I am trying to load data from a xml file to make a table but i also want to display the data types of the values present in my table. is there any way to do it ?

    Show Less
  • New to QlikView

    How to show 5 recent weeks of data in bar chart

    I want to create a bar chart that would show me recent last 5 weeks data by default. And then when user selects any datethen based on the selection it... Show More

    I want to create a bar chart that would show me recent last 5 weeks data by default. And then when user selects any date
    then based on the selection it would show that week and previous 4 weeks 0f data in the same fashion.
    So in my load script , i have this code for dates.

    DATE,
    WeekDay(DATE) as D_WEEKDAY,
    Year (DATE) as D_YEAR,
    Month (DATE) as D_MONTH,
    Year(DATE) * 12 + num(Month(DATE)) as [MonthCounter],
    Date(MonthStart(DATE),'MMM-YYYY') as MonthYear,
    Day (DATE) as D_Day,
    week(DATE) as D_Week,
    AutoNumber(Year(DATE) & Week(DATE)) AS WeekSerial

    Then in the chart expression i am using the following code to show 5 recent weeks,

    =FABS(sum({<WeekSerial={"<=$(=(max(WeekSerial)))>=$(=(max(WeekSerial)-4))"},D_MONTH,D_YEAR>} Sales))

    The above approach is not working when i click on the date filer, then it is only showing me that week data .
    I need to show that week and 4 previous weeks as well (total 5 weeks).

    Please advise.

    Show Less
  • Qlik NPrinting Discussions

    Filter data of "Import Recipient Task"

    Hiwe are using NPrinting 16.I have setup a "Import Recipient Task" which works fine.What I want to do now is to import only a filtered subset of recip... Show More

    Hi
    we are using NPrinting 16.

    I have setup a "Import Recipient Task" which works fine.

    What I want to do now is to import only a filtered subset of recipients from the QlikView document.
    But there is no "filter" option for an Import Task.

    Is it possible to apply a filter to the qlikview document when opening it with NPrinting, in order to
    limit the import?

    What I could possibly do is to create a "Run Macro Task" and then execute the macro (applying a bookmark) before execution of the recipient import. Is there another way to do it (as I do not like macros)?

    Thank you!

    Marcel

    Show Less
  • New to Qlik Sense

    How to have part of a calculation have a higher AGGR level, within a AGGR calcul...

    Hi All,My calculation below needs a last level of refining. I have an overall aggregation on Client, Member and Investment Product level. (Green)Then ... Show More

    Hi All,

    My calculation below needs a last level of refining. I have an overall aggregation on Client, Member and Investment Product level. (Green)

    Then within the calculation I need the result to be zero when the sum of the indicator column is greater than or equal to 1 at a Client, Member level. (Blue)

    I think I understand why it is still not working because of my overall AGGR being at a lower level. 

    Is there another way around this?

     

    Many thanks,

    James

     

     

    sum(AGGR(

    {<  dteTerminationDate4INDICATOR = {'-1'}, dteTerminationDate3INDICATOR = {'-1'},  dteDJFNew = {[<=$(vEndDate)]}, fkiLedgerID = {'1010','1020'}, fkiDescriptionID = {">3"},fkiInvestmentPolicyINDICATOR = {'-1'} >    }

     

    if(  aggr(sum( {dteEffectiveDate14={[<=$(vEndDate)]}}blnBankAccn),ClientID,MemberID)   >= 1  , 0,

    sum ( {< dteEffectiveDate14 = {"<=$(vEndDate)"} >} numProductUnits14 ) * FirstSortedValue( {< dteDate16 = {"<=$(vEndDate)"} >}  numOfferPrice , - dteDate16 ) )

     

    ,ClientID, MemberID,InvestmentProductID         

    ))

    Show Less
  • New to Qlik Sense

    generic load with multiple qualifiers

    Hi,I was checking a thread https://community.qlik.com/t5/Qlik-Education-Discussions/Calculate-Column/m-p/1584234#M3813, I could not understand wh... Show More

    Hi,

    I was checking a thread https://community.qlik.com/t5/Qlik-Education-Discussions/Calculate-Column/m-p/1584234#M3813, I could not understand what the user wanted , nevertheless i thought to convert the table onto cross table using generic load but post the join i do not seem to get the matching records from table 2 and table 3 , it seems to join only table 1 not sure what is going wrong.

    Could someone please check what i have missed in here

    Attached is the Qliksense Document that I have been working on

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.