Qlik Community

Welcome to Qlik Community

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

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

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 Boards and Documents for Qlik Services.

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!

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

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

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.

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

Recent Discussions

  • New to QlikView

    autonumber for client id x order id

    Hello,i have a huge database or customer id, order id and value of order.i want to add a new column (the 4th one), like a flag, which counts the numbe... Show More

    Hello,

    i have a huge database or customer id, order id and value of order.

    i want to add a new column (the 4th one), like a flag, which counts the number of the order for each customer.

    for ex:

    if customer A has 2 orders (#145 and #267) and customer B has 3 orders (#189 #211 and #214), the final table will be this one:

    customerorder idflag order
    A1451
    A2672
    B2112
    B2143
    B1891

    this will work also as a dimension, if selecting 1, i will have all the first order for all customers.

     

    thanks a lot,

    Andrei

     

    Show Less
  • New to Qlik Sense

    Count Average of Agents per Day

    Hi!I'm trying  to count the average distinct agents per day in a call center.* On Day 1 - there are 5 agents (A,B,C,D,E) who answered 20 calls* On Day... Show More

    Hi!

    I'm trying  to count the average distinct agents per day in a call center.

    * On Day 1 - there are 5 agents (A,B,C,D,E) who answered 20 calls

    * On Day 2 there are 5 agents (A,B,C,D,F)  who answered 20 calls

    For a single day I counted the distinct agents (otherwise the count will return 20) but when I want to do an average between more then 1 day - that's when I'm confused - (the correct result I'm expecting is 5)

    Selecting the two dates in the filter - results in 6 agents so not correct.

    I'm looking to somehow aggregate the distinct count per day and then dividing by distinct dates.

    Would appreciate any assistance! - Thanks!

    Show Less
  • Qlik Sense App Development

    Crosstable to generate date while loading data in qlik

    Hi Team,I have the below data set :-VLS Global                                                                                                        ... Show More

    Hi Team,

    I have the below data set :-

    VLS Global                                                            
                                                                
    CustomersApril-19May-19June-19July-19August-19September-19October-19November-19December-19January-20February-20March-20
    NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Unofficial Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)NOK parts in customer database - totalReal NOK parts manufactured -  totalNumber of official Written concern Total number Alert + Written concernVolumes shipped (external sales only)
    Brazil334139,780000118,540000114,940010116,0803603601117,550000114,400000013,560000015,15000006,720000115,7220000000000
    Bulgaria002266,300000066,247001158,524222231,413000042,678000055,928000056,031000067,833131132,52992192331,21,3950000000000
    India Pune 44823378,22024772281,29662914475,56742302276,70141882264,34851553466,40823041166,05525941167,96365532279,107121,149331,29,0070000000000
    Italy2225222590,727266266881,60,4549999881,29,1819494331,22,7020120548,7599653101,57,68014545141,06,1001601590,640010166,798079141,89,8600000000000
    Mexico601,991293,98,36561,2165185,03,68969562114,41,1842875293,97,01913981193,82,42522170154,08,460263556184,26,5881255194,04,8692151283,12,55312152253,52,5110000000000
    Morocco0950025,4680680032,5062340249,5531551159,620090028,16801850045,7334704468,1250420053,3437942256,0740400081,4830000000000
    Novy Jicin2748115349,33,55621988215310,17,3641363510378,49,793121,0087596,40,068134566176,28,02187958309,51,84386777419,57,24571,2617478,57,426104776376,59,0191572,88411378,75,7790000000000
    Rychvald3453141,88,5616633232,43,94941484152,15,828101846241,89,9293203131,65,30913549332,62,372105610273,22,98512315183,05,4243583112,30,73461676273,23,6160000000000
    Romania00112,72,355010023,19,04002012,61,60701013,18,17000001,15,039714902343,19,73022222,16,98103022,72,21300001,08,60400002,73,6420000000000
    Poland000000000000000000000000000000000000000031292293,248018202614,9230000000000
    Turkey664421,49,1753623871223,23,812664417,69,5653193194619,77,00901781117,91,943183002826,33,69681324621,84,6762844361726,43,94916274622,88,8366173423,99,2650000000000
    Vietnam111178,6991072097772,51330302286,870222279,711443378,405111184,290111170,8951951951187,071772387,39511111,14,3580000000000
    VTYC CQ38331,50,985000086,8397174471,51,33349241,60,1706114391,03,70800001,88,9432312312,23,37388442,61,95122222,28,203000000000000000
    VTYC CZ55221,02,48604001,09,470131384,792394997,60924221,00,14602021,17,62601011,05,19411111,47,8491171694,689000000000000000
    India Chennai000000000000000000000000000000000000000000000000000000000000
     000000000000000000000000000000000000000000000000000000000000
     000000000000000000000000000000000000000000000000000000000000
     000000000000000000000000000000000000000000000000000000000000
    Europe (NJ,RY,PL, Mor.) 30621184811,47,585271,119247612,93,8191981714540231,24714848,89,617164859308,21,498211,034176312,59,94822803217213,48,355191,334126512,16,1932375813799,49,0751633,273179012,95,8010000000000
    US (Brazil+ Mexico)632,0253124,08,14561,2165195,22,2296956212028762104,13,0993617582203,99,97522170164,22,860263556184,40,1481255194,20,0192151283,19,27312152263,68,2330000000000
    2WSL2935303326,57,256735872161929,42,06613513715160417418111425,29,00541944920,76,8247421,26892332,51,32425189122326,34,68322470182531,61,706243871125,84,1629928981230,98,5200000000000
    China 813552,70,85804001,96,309817751007186132,57,77981185112,03,85402023,06,5692322323,28,56799554,09,800319383,22,892000000000000000
    India (Pune+ chennai)44823378,22024772281,296629144042302276,70141882264,34851553466,40823041166,05525941167,96365532279,107121,149331,29,0070000000000
     000000000000000000000000000000000000000000000000000000000000
    TOTAL ACTUAL1343,1735910145,44,6777703,6884711650,35,7191742,378409641,88,7374532,7893512341,66,2013931,743227235,66,4997702,6762910853,07,109771,6834214648,17,8082552,8932710552,75,681581,5192710842,54,5092864,8633011148,91,5610000000000

     

    I wish to get the below output:-

     NOK parts in customer database - totalReal NOK parts manufactured - totalNumber of official Written concernTotal number Alert + Unofficial Written concern
    Apr-19296981298222224
    May-19153732933323035
    Jun-1942568954922919
    Jul-19109669840129523
    Aug-19110489616920188
    Sep-19145504546420350
    Oct-1916349871830304
    Nov-1948548511819903
    Dec-1914357634625385
    Jan-2058994613322692
    Feb-20#DIV/0!#DIV/0!#DIV/0!#DIV/0!
    Mar-20#DIV/0!#DIV/0!#DIV/0!#DIV/0!

     

    Can anyone please help ?

    Thanks in advance

    Show Less
  • New to Qlik Sense

    To show negative Value

    how nagative values In qlik sens epie chart but it is showing same number for all in pie chart.
  • New to QlikView

    Help me on my issue

    Hi All,i have four Date columns like        Offer_StartDate                                                                    Offer_EndDate          ... Show More

    Hi All,

    i have four Date columns like        Offer_StartDate

                                                                        Offer_EndDate 

                                                                        Calendar_StartDate

                                                                        Calendar_EndDate.

     

    Offer_StartDate & offer_EndDate are  in T1 table 

    Calendar_Startdate & Calendare_EndDate are in T2 table 

    i have created one Calendar_StartDate  calendar object  And one Calendar_EndDate calendar object

    As per my requirement, i want show the Offer_StartDate and Offrer_EndDate with in the date rang which i select in Calendar_StartDate and Calendar_EndDate, but issue is "Calendar_Startdate & Calendar_EndDate" column table is independent table(isolated table). can u help me how the apply the triggers to make it work this.

    Thanks in Advance.

    Show Less
  • New to Qlik Sense

    Restrict one of the filters on multi KPI

    Hi,I have 2 identical sheets that display several KPIs and a multi KPI. There are also 3 filters on each sheet: district, year and area.I want to use ... Show More

    Hi,

    I have 2 identical sheets that display several KPIs and a multi KPI. There are also 3 filters on each sheet: district, year and area.

    I want to use one sheet to display data according to all filters, that is KPIs for a chosen district,year and area.

    The 2nd sheet is the main one, and it displays the data for the whole organization. That is, the same KPIs but  using only 2 of the filters: year and area. In order to give the user the full picture on one page I want to add a multi-KPI or a table to show the data for all districts in the organization.
    The chart should be based on the district dimension, but it should always display all the values in this dimension, without filtering.

    Is there a way to disable the filter itself for the specific chart? Otherwise it shows only the selected districts and not all of them. 

    Show Less
  • New to Qlik Sense

    Create new variables from mapping existing variable names

    Hello, How can i create new variables from mapping existing variable names ? i have a table in an excel sheet 'customer' containing column names. I wa... Show More

    Hello, 

    How can i create new variables from mapping existing variable names ? i have a table in an excel sheet 'customer' containing column names. I want to use the column names to map to the excel sheet 'mapping'.

    I am expecting on QlikSense to create new fields from mapping file : customer_type,  loyal_yes_no, loyality_years. that must be mapped to the excel sheet customer. 

    Please see attached exelsheets for further clarification 

    Many thanks 

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    IGenericObject.GetLayoutAsync() behavior on large objects

    Hello, dear Qlikers!I am experiencing a rather odd behavior of the interface's IGenericObject GetLayoutAsync() function. It hangs and freezes while tr... Show More

    Hello, dear Qlikers!

    I am experiencing a rather odd behavior of the interface's IGenericObject GetLayoutAsync() function. It hangs and freezes while trying to calculate some heavy-duty tables. 

    What I do is iterate through some list of sheets and get their children and for each, I call GetLayoutAsync() function. 

    Is there something that I miss? The strangest thing is if I have multiple sheets to be calculated, that specific sheet which yields a timeout when is ran alone, it works. 

    The server also have some other heavy-duty tasks which put some pressure on the I/O and memory. It could make this process of pre-loading objects to timeout?

    Private Sub CalculateObjects(ByVal app As IApp, ByVal location As ILocation, ByVal id As IAppIdentifier)
    For Each sheetid In sheetids
                    Dim obj As GenericObject = app.GetObject(Of GenericObject)(sheetid)
                    Dim copii = FindAll(app, obj)                
                    Dim tasks = children.[Select](Function(o) o.GetLayoutAsync()).ToArray()
                    Task.WaitAll(tasks)               
    Next
    End Sub
    
    Private Function FindAll(ByVal app As IApp, ByVal obj As IGenericObject) As IEnumerable(Of IGenericObject)
                Dim copii As IEnumerable(Of IGenericObject) = obj.GetChildInfos().[Select](Function(o) app.GetObject(Of GenericObject)(o.Id)).ToArray()
                Return copii.Concat(copii.SelectMany(Function(copil) FindAll(app, copil)))
    End Function

     

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Make selection / set filter in Qlik Sense App via .NET SDK

    Hello,I'm currently developing an .NET App which should control a QS App (making selections/setting filters etc.).I'm can read the current made select... Show More

    Hello,

    I'm currently developing an .NET App which should control a QS App (making selections/setting filters etc.).

    I'm can read the current made selection in the tool live, which is great but I have troubles making selections via my app.

    So my question is: How can I make a selection / set a filter on my app?

    Like setting a Datefilter, a customer filter to a certain customer etc.?

    Dim currentSelection As ICurrentSelection = myApp.GetCurrentSelection

    For Each selectedField In currentSelection.Selections

    MsgBox("Field: " & selectedField.Field & vbNewLine & "Selected Values: " & selectedField.Selected)

    Next

    Thank you and best regards

    Show Less
  • QlikView Scripting

    How to create additional field name PNL+TYPE = Revenue IF GL_CODE=80020 ?

    Hi AllMy Table after load raw data to Qlik is look like below :-SOURCEGL_CODE_GL_DESC_AmountTDS80020LOCAL SALES205297.31PMC5000200LOCAL SALES-590387.6... Show More

    Hi All

    My Table after load raw data to Qlik is look like below :-

    SOURCEGL_CODE_GL_DESC_Amount
    TDS80020LOCAL SALES205297.31
    PMC5000200LOCAL SALES

    -590387.65

     

    I Wish to make the table as below :-

    SOURCEGL_CODE_GL_DESC_AmountPNL_TYPE
    TDS80020LOCAL SALES205297.31REVENUE
    PMC5000200LOCAL SALES-590387.65REVENUE

     

    Base on condition :- 

    SOURCE = TDS , GL_CODE=80020 , PNL_TYPE = Revenue

    SOURCE = PMC, GL_CODE=5000200 , PNL_TYPE = Revenue

    Can some one advise me how to do it ?

    PAul Yeo

    SOURCE = TDS GL_CODE=80020 , PNL_TYPE = Revenue

     

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

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 World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by February 29th to save $200.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Insider: What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

February 26, 2020