Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
1,328 online
Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now

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 QlikWorld 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.

Participate in Qlik Technical Previews, submit ideas, and review documentation.

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 ten unique blogs. Check out the new Product Insight & Ideas Blog!

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

Discussion Boards and Documents for Qlik Services.

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

  • No Boards Found
  • forum
    Qlik NPrinting Discussions

    NPrinting Excel Chart Y axis minimum and maximum values cannot be set

    Hi allCan you please please let me know if I can set the NPrinting Excel Chart Y axis to show as 0% for minimum and 100% as maximum values. It keeps o... Show More

    Hi all

    Can you please please let me know if I can set the NPrinting Excel Chart Y axis to show as 0% for minimum and 100% as maximum values. It keeps on showing up as 120% max or 80% minimum.

    Also can the values be sorted as max to min and not by alphabetical order.

    Many thanks 

    D

    Show Less
  • forum
    New to QlikView

    Case 528 How to link my sales order and GL table data to time line ?

    Hi AllI have 2 Table :-GL Table - Date field name = date_GLSALES ORDER Table - Date field name = date_SOMy below script is how i link my sales order a... Show More

    Hi All

    I have 2 Table :-
    GL Table - Date field name = date_GL
    SALES ORDER Table - Date field name = date_SO

    My below script is how i link my sales order and GL Table data field :-

    tmp:
    LOAD
    min(date_GL) AS MinDate,
    max(date_GL) AS MaxDate
    RESIDENT GL_TABLE;
    CONCATENATE (tmp)
    LOAD
    min(date_SO) AS MinDate,
    max(date_SO) AS MaxDate
    RESIDENT SALES_TABLE;
    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;

    May i know it is correct ? As My master claendar table is not link with sales order and GL data.

    Paul Yeo

    no link.png

    Show Less
  • forum
    QlikView Scripting

    Cross table with multiple value fields

    Hi Gurus,I am trying to transform an xls into a more reportable format in Qlikview, xls format is unfortunately is as belowDeptNoDeptNameDate1Exp1Date... Show More

    Hi Gurus,

    I am trying to transform an xls into a more reportable format in Qlikview, xls format is unfortunately is as below

    DeptNo
    DeptName
    Date1
    Exp1
    Date2
    Exp2Date3Exp3Date4Exp4Date5Exp5
    1accounts20/02/20161019/02/20161018/02/20161017/02/20161016/02/201610
    2marketing20/02/20162019/02/20162018/02/20162017/02/20162016/02/201620
    3sales20/02/20163019/02/20163018/02/20163017/02/20163016/02/201630

    I want to transform this data into below format , I tried cross table but was not able to work out how to do it easily. Please help !

    DeptnoDeptNameDateExpense
    1accounts20/02/201610
    1accounts19/02/201610
    1accounts18/02/201610
    1accounts17/02/201610
    1accounts16/02/201610
    2marketing20/02/201620
    2marketing19/02/201620
    2marketing18/02/201620
    2marketing17/02/201620
    2marketing16/02/201620
    3sales20/02/201630
    3sales19/02/201630
    3sales18/02/201630
    3sales17/02/201630
    3sales16/02/201630
    Show Less
  • forum
    New to Qlik Sense

    Selection one of the bar from grouped bars in bar chart

    Hi All,I have developed a bar chart, i have 2 dimensions on y axis (AdmissionType, AdmissionMonth). When i select sheet for two months it shows groupe... Show More

    Hi All,

    I have developed a bar chart, i have 2 dimensions on y axis (AdmissionType, AdmissionMonth). When i select sheet for two months it shows grouped chart. See scenario1.png in attachment.

    Now i want to select only May Month of ABC AdmissionType. But when i am clicking on May it is selecting both May and June months. Basically it is selecting AdmissionType='ABC'. See scenario2.png in attachment.

    But i want to select only May month and get only 11 records of May month. It this possible?

    Show Less
  • forum
    New to QlikView

    How to make the table file name as TABLE1 ?

    Hi All,Below Script work fine , it will generate 2 Table name depend on the file name i load  :-For Each i in '$(vFile2010)','$(vFile2011)','$(vFile20... Show More

    Hi All,

    Below Script work fine , it will generate 2 Table name depend on the file name i load  :-

    For Each i in '$(vFile2010)','$(vFile2011)','$(vFile2012)','$(vFile2013)','$(vFile2014)'
    LOAD
    '$(i)' as SOURCE_,
    Date( Date#([Posting Date], 'MM/DD/YYYY'), 'DD/MM/YYYY') as [date],
    ApplyMap('MAP_ISDN_REV',[GL Code],'REVENUE') as [rEVENUE],
    [Transaction Type]
    FROM
    $(vRAWPath)$(i)
    (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
    NEXT i;

    For Each i in '$(vFile2015)','$(vFile2016)'
    LOAD
    '$(i)' as SOURCE_,
    date#(@58:77T,'DD/MM/YYYY') as date,
    FROM
    $(vRAWPath)$(i)
    (ansi, fix, no labels, header is 0, record is line);
    NEXT i;

    May i know how can i assign the table name to be alway equal to TABLE 1 and TABLE 2 not depend the file name i load ?

    Paul

     

    Below is my Data model :-

    file name.png

     

    Show Less
  • forum
    New to Qlik Sense

    Qlik Map - region = 0 should not be displayed

    Hi,I am working on maps in Qlik.  My dimension Is name of the areas and measure is resident/population *100000.Now the issue is when the measure is ze... Show More

    Hi,

    I am working on maps in Qlik.  My dimension Is name of the areas and measure is resident/population *100000.

    Now the issue is when the measure is zero I could still see the polygon for that region and I don't want to.

    I want to only see the regions which have the number in it and want to filter out the polygon of the regions with result zero.

    Can anyone advise.

    Thanks

    Show Less
  • forum
    Qlik Sense App Development

    List of valid entries for Locations in Maps Object

    Hi there,I am trying to create a Map Visualization also containing a layer for continents.In Qlik Help contoninent is listed as one supported type of ... Show More

    Hi there,

    I am trying to create a Map Visualization also containing a layer for continents.

    In Qlik Help contoninent is listed as one supported type of data, but unfortunately only 'Australia' is detected.

    Entries like 'Africa', 'Europe', 'Asia', 'South America', 'North America' are not shown. Is there a list of valid entries that Qlik can interpretate?

    Show Less
  • forum
    New to QlikView

    Average with Set analysis

    Hello guys, I'm trying to create a chart with Date as Dimension and the following expression:=avg({1 <STCK={'CVCB3'}, DVPG={'> 03/01/2020'}>} VDAF)I d... Show More

    Hello guys, 
    I'm trying to create a chart with Date as Dimension and the following expression:

    =avg({1 <STCK={'CVCB3'}, DVPG={'> 03/01/2020'}>} VDAF)


    I don't know why but it's not working, it shows NO DATA TO DISPLAY,  but I'm sure there are available data to display. 

    My intention is to create a chart where Date (DVPG) is a dimension, and the expression is the average of VDAF values, from 03/01/2020 up to today!

    How can I do it?

    Thanks

    Show Less
  • forum
    Qlik Sense App Development

    How to count historical data when it got replace without loosing them

    Hello,I have a tough question here and since I'm new I don't know how to solve it best. I have two tables.  These tables have the (Shelf.No or others)... Show More

    Hello,

    I have a tough question here and since I'm new I don't know how to solve it best. I have two tables.  These tables have the (Shelf.No or others) and Coordinate as the connected Key.  

    Table1

    Error-NumberDateShelf No. or others
    34338476220.05.201111 
    28564593821.05.203424 
    37578394522.05.203333 
    33334432223.05.204444 
    89768998324.05.207674 
    23432562125.05.206666 

     

    Table2

    CoordinateMaterialnumberSector
    2222C1111111Area11
    3333C4234522Area39
    7777D5930433Area56
    6535E4749573Area11
    4531C4234522Area33
    1111C2345654Area56

     

    Table1 consist error reports from logistic workers who realizes in the shelves of their corresponding Sectors, errors like  "empty shelves", or someone accidentally filled the "wrong material". Then the logistic workers uses the  SAP-UI to file a report. For additional information they just need to fill in the 4-digit coordinates in which shelve the error occurred. SAP interface will then automatically create an unique Error No. with a date/timestamp. Qlik gets daily updates from SAP of these reports. Note that this table also consist of reports without a shelve no., since also other departments uses this user interface to report other not shelve and logistic  related problems. 

    Table2 is a self constructed Excel Database.Since the 4-digit error report doesn't tell me where the actual problem, Sector  or even Material occurred, so this Table is compulsory. For example it tells me that the shelve No. 2222 consist the Material C1111111 and the shelf is in department sector Area11:

    CoordinateMaterialnumberSector
    2222C1111111Area11

    So I also could count and  visualize which material or which sector made the most problems.

    The shelve No. is unique but other shelves can of course also contain the same material. And the sector is of course also not unique, since a sector contains multiple shelves. Normally Table2 is "fixed" there is no automatic update, since coordinates won't change. 

    Now its not a big problem if Table2 never changes. But since production lines and their materials will change from time to time I have a big problem to return the correct values for my bar diagram and so.  So on a monthly basis we sometimes decide to exchange Materials of a few shelves. That means for instance Shelve No.2222 might changed from C1111111to Material "C2222222" all of a sudden. 

    The problem that occurs now: The old error reports  in Tabe1 that counted for the old material C1111111 will also counts for C2222222, instead of making a cut and reset the error of the new exchanged material of the shelf to zero, since I'm having a new material there now and want to start to make a new count with that material.

     But we also don't want to lose the historic data of the past when the shelf still contained the old material. Ideally the bar diagram should show both bars . Shelf No. 2222 with new AND old Material.No accumulation of both count in one bar, it has to be counted separately.

    Every month or two I do  a export of the excel data from the shelf system. I can compare the data with my old excel export to check if there is any changes in materials in the shelves. I will never know exactly when the material was changed. It really depends on how often I check these, but there is NO timestamp when it got replaced with another material. I need to make a monthly update myself.  So there is always a little subset how the errors should be account for: for the new or old material. I can use end of month, respectively the day I manually update the excel sheet as the moment where I start to count for the new material. 
    The only thing I can say, is that I can change the Excel sheet of the Shelf Coordinates to help me count right. But I don't know how to do it.  

    That was a long one, but I hope some expert can guide me through the right direction. 

    Thanks in advance and stay safe!

    Show Less
  • forum
    New to QlikView

    Incremental LOAD

    Dears,I'm using a FOR EACH Loop with 2 Loads inside, something like this:For Each Sticker in 'AZUL4', 'ITUB4', 'CVCB3'...Each Sticker is a file, loade... Show More

    Dears,

    I'm using a FOR EACH Loop with 2 Loads inside, something like this:

    For Each Sticker in 'AZUL4', 'ITUB4', 'CVCB3'...

    Each Sticker is a file, loaded online...

    DemonstrativoResultados:
    LOAD... From...

    Join (DemonstrativoResultados)
    LOAD... From...

    Next Sticker

     

    So, every time I get a new file, I'm loading everything again and it's obviously unnecessary... 

    My question is: 
    How can I load just the new file, and insert it in my project without losing all old data?

     

    Check this example:
    Let's suppose I have the files 'AZUL4.csv' and 'GOLL4.csv'; I'm currently doing something like this:

    For Each Sticker in 'AZUL4', 'GOLL4',

    DemonstrativoResultados:
    LOAD... From...

    Join (DemonstrativoResultados)
    LOAD... From...

    Next Sticker

     

    And now, let's suppose I got a new file, called 'ITUB4.csv'

    I don't want to load 'AZUL4', 'GOLL4', 'ITUB4'. Is there any way to just load the 'ITUB4' and add it to my database?

     

    Thanks for your attention,
    Best regards

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

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

Groups

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

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

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

On Demand Webinar

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

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.

Now Available on Demand