Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,845 online
Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

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.

Ideation

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

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

    New to Qlik Sense

    How to break string into multiple lines

    Hi Qlik Experts,I have a string field which I want to display in a report. The problem: the string isn't preformatted and look something like below-Ac... Show More

    Hi Qlik Experts,

    I have a string field which I want to display in a report. The problem: the string isn't preformatted and look something like below-

    Actual output:

    -Lorem Ipsum is simply dummy text of the printing and typesetting industry. -Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. -It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. -It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Q. How do I break the string and add a line new line after every occurance of '-' ?

    Desired output:

    -Lorem Ipsum is simply dummy text of the printing and typesetting industry.
    -Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
    -It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.
    -It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Show Less
  • forum

    New to Qlik Sense

    Show Last Year's Sales to Date when selecting a Fiscal Year

    Data looks like this: DecJanFebMarAprMayJunJulAugSepOctNov2019-2020$4$3$5$5$5$3$6$4$2$6$3$62020-2021$5$7---------- User selects Fiscal Year 2020-2021.... Show More

    Data looks like this:

     DecJanFebMarAprMayJunJulAugSepOctNov
    2019-2020$4$3$5$5$5$3$6$4$2$6$3$6
    2020-2021$5$7----------

     

    User selects Fiscal Year 2020-2021. The expression should then sum the sales for Dec & Jan of Fiscal Year 2019-2020, and return '$7'.

    My (failed) expression currently reads:

     

     

    <!--
    if(Sum({<[Fiscal_Month]>}Sales)>0,
    Sum({<[Fiscal_Year]={'$(v_FiscalPrevYear)'}>}Sales))
    -->

     

     

    Probably missing something small and simple! v_FiscalPrevYear simply stores the value of the prev fiscal year, based on fiscal year selection.

    Thanks!

    Show Less
  • forum

    QlikView App Dev

    Dimensions with multiple columns - hundreds of millions of rows

    I have a table that is about 200 million rows. 60 fields are in that table.  I have several fields that I want to link to one dimension. I have done t... Show More

    I have a table that is about 200 million rows. 60 fields are in that table.  I have several fields that I want to link to one dimension. I have done the whole create crosstab, and created the tables. The problem is I need to do it to several fields

    Market1 Market2 Market3 Nextfield1 Nextfield2 Nextfield3 Vendor1 Vendor2 Vendor3 dropDate1 dropDate2 dropDate3
    row1 Colorado Utah NewMexico BV MN EL AA BB CC 5/6/2020 9/20/2021 12/20/2021
    row2 Montana Nevada Wyoming MS IE LW WN PO SN 1/15/2021 10/25/2020 2/25/2021

    Each table was set up like below. I have done this with other projects and it worked fine, but those projects pulled in millions of rows. Not hundreds of millions. Its star schema is one main table, 200 million rows, approx 50 fields with four other tables around it with 200 million rows each. It takes about 10 minutes just to open it.

    Market:

    LOAD
    [Trans Id], Market1 as [MarketCarrier]
    Resident FactTable
    WHERE not Market1 '-' or Len(Market1) > 1;

    Join(Market)
    LOAD
    [Trans Id], Market2 as [MarketCarrier]
    Resident FactTable
    WHERE not Market2 like '-' or Len(Market2) > 1;

    Join(Market)
    LOAD
    [Trans Id], Market3 as [MarketCarrier]
    Resident FactTable
    WHERE not Market3 like '-' or Len(Market3 ) > 1;

    I had created separate tables from what others had done. The market had its own table, Nextfield1 had its own table, Vendor had its own table like shown below. But the problem is, there are 200 million rows in the dataset. And each (one time for main, one time for Market, one time for Nextfield1, one time for  Vendor1,  and one time for dropDate1 ) it has to pull in the 200 million rows. Just to pull in the 200 million rows, it takes Qlikview 2 hours. Last night this ran all night and barely finished by morning.

    Is there a better way to do this that doesn't take up all of my resources? Also, this is only 10 days of data. I can't go less than that on the number of days. 

    Thank you,

    Martha

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Nprinting layout issue

    Hi @Lech_Miszkiewicz  @Ruggero_Piccoli  @Frank_SI'm using QlikView Printing 16.9My template is PPT with Table as inputs. am using QlikView pivot table... Show More

    Hi @Lech_Miszkiewicz  @

    I'm using QlikView Printing 16.9

    Chanty4u_0-1614826468377.png

     

     

    Show Less
  • forum

    New to Qlik Sense

    Generate missing sales data for every month

    As the image above suggests, I'm looking to create records for every possible product/store/month combination - where that combination doesn't exist -... Show More

    screen1.png

    As the image above suggests, I'm looking to create records for every possible product/store/month combination - where that combination doesn't exist - and insert NULL for the Sales amount.

    I've looked at this document; https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394 but can't work out how it would apply to my data - as far as I can tell, this only deals with filling in values using peek.

    All help greatly appreciated, thanks.

    Show Less
  • forum

    Qlik Sense Integration, Extensions, & APIs

    Qlik Sense Embed - Loop until Error

    Hi All,We are trying to embed Qlik object using iframe into our own application. When we try to view the page, it seems as if the iframe object goes i... Show More

    Hi All,

    We are trying to embed Qlik object using iframe into our own application. When we try to view the page, it seems as if the iframe object goes into a loop and after a few seconds returns the below error.

    An error occured - Unknown error

    wcilliers_0-1614821641166.png

    The object works fine when you open the url in a new tab.
    Also, when using the Test url from Qlik's Demo site, it also works fine:

    wcilliers_2-1614821882172.png

     

    Any ideas?

    Thank you,

    Wynand

     

    Show Less
  • forum

    Qlik Sense App Development

    if statement

    Hi, I'm trying to rank hierarchies and I'm trying to write dimension.Level=1 Manager,Level=2 Manager Helper ,Level=3 Employeeif selected level 1 show ... Show More

    Hi, 

    I'm trying to rank hierarchies and I'm trying to write dimension.

    Level=1 Manager,Level=2 Manager Helper ,Level=3 Employee

    if selected level 1 show me level 2 names. 

    =if (LEVEL=2,if(LEVEL=1 and PRED=WORKNUM,NAME))

     its not work:(

    please help

    Ekran Alıntısı_TEST.PNG

     

    Show Less
  • forum

    Qlik Sense Data Connectivity

    Website JSON - JWT token

    Hello to all,I have a problem. I should connect to a web page that uses a JSON token to update a table.The data I have available are the following:$.a... Show More

    Hello to all,

    I have a problem. I should connect to a web page that uses a JSON token to update a table.

    The data I have available are the following:

    $.ajax({
    type: 'GET',
    url: 'www.testurl.com/covid19/web/index.php?r=json%2Ftab2',
    username: 'username',
    password: 'password',
    dataType: 'json',

    Is it possible to connect to the tab2?

     

    Thanks!

    Show Less
  • forum

    QlikView Administration

    Azure SQL DW tables and fields are blank

    Good day QV Users,I am on QlikView April 2020 SR4 version on Windows Server 2016 OS trying connect to Azure SQL DW.I am using 64 bit ODBC driver to co... Show More

    Good day QV Users,

    I am on QlikView April 2020 SR4 version on Windows Server 2016 OS trying connect to Azure SQL DW.

    I am using 64 bit ODBC driver to connect to Azure SQL DW.

    ODBC 64bit connection test OK

    arish_delon_1-1614720052785.pngarish_delon_2-1614720085296.png

     

    QlikView Desktop connection using ODBC connection is OK

    arish_delon_0-1614719708366.png

    I can view Master Database (default)

    arish_delon_3-1614720206079.png

    I am not able to view production Database; Tables and Views are empty.

    arish_delon_4-1614720317009.png

    When use the same Service account and password to connect to Azure using ODBC driver work fine in SQL Server Management Studio. I can view the tables and views. Why am i not able to see same in QlikView Select statement?

     

     

    Show Less
  • forum

    QlikView Administration

    Tasks on access point failing all of sudden “Error: Document open call failed. T...

    Hello folks,All of sudden when we run the tasks they are failing on access point. Earlier, they used to run fineAny ideas what could have gone wrong?I... Show More

    Hello folks,

    All of sudden when we run the tasks they are failing on access point. Earlier, they used to run fine

    Any ideas what could have gone wrong?

    In the log I am seeing

    “Error: Document open call failed. The document might require username and password.”

    attached is sample log message:

    (3/4/2021 2:50:19 PM) Information: Max retries:5

    (3/4/2021 2:50:19 PM) Information: Attempt:01

    (3/4/2021 2:50:21 PM) Information: Opened the QlikView Engine successfully. ProcessID=8124

    (3/4/2021 2:50:21 PM) Information: Allocated QlikView Engine successfully. Current usage count=1 of 8 (of type non-reader). Ticket number=17.

    (3/4/2021 2:50:21 PM) Information: Loading document "Test.qvw" (2409.76 Mb)

    (3/4/2021 2:50:22 PM) Information: Loading. LoadTime=00:00:01.0047680

    (3/4/2021 2:50:23 PM) Error: Document open call failed. The document might require username and password.

    (3/4/2021 2:50:23 PM) Information: Attempted to load the document with data.

    (3/4/2021 2:50:23 PM) Error: The document failed to open.

     

     

    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