Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,485 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 eight unique blogs. Check out the new Architecture Deep Dive 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.


Challenge the status quo

See why Qlik (Attunity) is recognized in the 2019 Gartner Magic Quadrant for Data Integration Tools.

Recent Discussions

  • QlikView Management

    Qlikview server returns an error - failed to distribute QVS

    Hi,Is there someone who can help me with following error? The Qlik Server returns this error during the automatic reload of the application. The error... Show More

    Hi,

    Is there someone who can help me with following error? The Qlik Server returns this error during the automatic reload of the application. The error does not occur when I reboot the Qlik Server and perform a manual reload.

     

    Thanks in advance

    -----------------------------------------

    17/09/2019 7:10:31ErrorThe QlikView Server returned a error

    17/09/2019 7:10:31ErrorQVS Distribution failed to distribute to QVS

    17/09/2019 7:10:31ErrorDistribution to resources failed with errors. Warnings: 0, Errors: 2

    17/09/2019 7:10:34ErrorThe task "xx\App.qvw" failed. Exception:

    QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.LogBucketErrorException: Distribution to resources failed with errors. Warnings: 0, Errors: 2

       at QDSMain.DistributeTask.RevertOneAndAlwaysOne(Document qvbDocument)

       at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument)

       at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

       at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

       --- End of inner exception stack trace ---

       at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

       at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

    Show Less
  • QlikView App Development

    Set Analysis instead of Pick

    Hi,Please see data example below. ProductGroup,StockColor,StockSize,StockQuantity,ProductGroup1,Green,40,10,ProductGroup1,Green,41,15,ProductGrou... Show More

    Hi,

    Please see data example below. 

    ProductGroup,StockColor,StockSize,StockQuantity,
    ProductGroup1,Green,40,10,
    ProductGroup1,Green,41,15,
    ProductGroup1,Red,40,5,
    ProductGroup1,Red,41,5,
    ProductGroup2,Yellow,Small,5,
    ProductGroup2,White,Large,15,

     

    ProductGroup,SalesProductName,SalesColor,SalesSize,SalesQuantity,
    ProductGroup1,Shoes,Green,40,3,
    ProductGroup1,Shoes,Green,41,5,
    ProductGroup1,Shoes,Red,40,2,
    ProductGroup1,Shoes,Red,41,2,
    ProductGroup2,Toy,,,11,
    ProductGroup2,Toy,,,8,

     

    In the current data model these two Fact tables are joined by ProductGroup.

    However in a chart it should be presented by all dimensions (Group, ProductName, Color, Size) with correct values per row for StockQuantity and SalesQuantity measures.

    Some products doesn't have Color and Size therefore key cannot be combined using these columns.

    Existing data model is complex. I am thinking to move Products where available Size and Color in a different Table.

     I am curious whether is possible to create an expression with only Set Analysis (e.g. {<StockColor=P(SalesColor), StockSize=P(SalesSize)>} or something like {<StockColor={"=Only(SalesColor)"}, StockSize={"=Only(SalesSize)"}>} )

    It doesn't work properly.

    In addition I have created the expression with Pick function where result as expected.

    Pick(Match(StockColor,'Green','Red')
    // Green
    ,Pick(Match(StockSize,'40','41')
    ,Sum({<StockColor={'Green'}, SalesSize={'40'}>}StockQuantity) // 40
    ,Sum({<StockColor={'Green'}, SalesSize={'41'}>}StockQuantity) // 41
    )
    // Red
    ,Pick(Match(StockSize,'40','41')
    ,Sum({<StockColor={'Red'}, SalesSize={'40'}>}StockQuantity) // 40
    ,Sum({<StockColor={'Red'}, SalesSize={'41'}>}StockQuantity) // 41
    )
    )

    clipboard_image_2.png

     

    My question is how to replace Pick function with Set Analysis hence leave only one formula?

     

    Any help will be much appreciated.

     

    Show Less
  • Qlik Connectors Discussions

    MS Dynamics Connector + MFA

    Hey guys, we are using the Dynamics connector to extract data from our Dynamics instance but as Microsoft partner we are forced to enable MFA pol... Show More

    Hey guys,

     

    we are using the Dynamics connector to extract data from our Dynamics instance but as Microsoft partner we are forced to enable MFA policy to all our accounts.

    If we do this the connection string isn't working anymore (how obvious -.-) and now i am asking is there any workaround?

    I thought AppPasswords would do the trick but it's not working as soon as we enable the MFA policy...

     

    We are thankful for any ideas or suggestions 🙂

     

    thanks in advance

    Show Less
  • QlikView App Development

    QLIKVIEW script - Need help in transforming data , based on Sample work data Ne...

    Hello folks,I have sample input data as belowNeed output as show in screen shot attached jpg file .  I need to do this using  QlikView ... Show More

    Hello folks,

    I have sample input data as below

    Need output as show in screen shot attached jpg file .  I need to do this using  QlikView script , any help is highly appreciated as I am running under tight deadline of project

    Show Less
  • QlikView Layout & Visualizations

    Pick and match not working with 12 rolling months

    Hi All,I need one help in achieving one result in which i need 13 months rolling with 2 condition.This is the result which i am getting with this expr... Show More

    Hi All,

    I need one help in achieving one result in which i need 13 months rolling with 2 condition.

    This is the result which i am getting with this expression.

    =pick(match([Prof6 Raw],'ABC'),

    Num(sum({<[BI As Of Month]={">=$(=Date(addmonths(Max([BI As Of Month]), -12),'MMM-YY'))<=$(=Date(addmonths(Max([BI As Of Month]), 0),'MMM-YY'))"},Segment={'Auto'},Flag={'Prpop'}>}Value),'###,#00')//
    )

    Above expression is giving me extra null month columns which i want exclude , not by suppress zero because of chart background formatting. 

    Thanks

     

    Show Less
  • New to Qlik Sense

    Read the log files via script

    Hello qlikers,I found this article: https://support.qlik.com/articles/000041017 . You can find the log files for every application in the QMC.I w... Show More

    Hello qlikers,

    I found this article: https://support.qlik.com/articles/000041017 . You can find the log files for every application in the QMC.

    I want to visualization the log files in Qlik Sense for specific applications. So my question is, how can I read the log files via script for particular applications? 

    Thank you in advance. 

     

    Show Less
  • New to QlikView

    How to get top five with the highest rank?

    Good Day,How can I get the top 5 Region with the highest outstanding balance percentage per month in a line graph, please see below sample screenshot&... Show More

    Good Day,

    How can I get the top 5 Region with the highest outstanding balance percentage per month in a line graph, please see below sample screenshot

     

    I use this measure  : SUM({<[CLASSIFICATION] = {'PD','LEGAL'}>}[outstanding_bal])/(SUM({<[CLASSIFICATION = {'PD','LEGAL','REGULAR'}]>}[outstanding_bal])

    clipboard_image_0.png

     

    Thank you

     

    Show Less
  • Qlik Sense App Development

    P&L Pivot - June 2019

    I have recently upgrade to Qliksense June 2019.I want to use the P&L pivot to develop a P&L app.I have loaded a table into the App that holds ... Show More

    I have recently upgrade to Qliksense June 2019.

    I want to use the P&L pivot to develop a P&L app.

    I have loaded a table into the App that holds all the fields that I want to use in my calculations.

    What I want to develop is a P&L that will show the following...

    P&L

    Heading                                         Current Value

    Gross Sales Value                      Sum(T_GSV)   (Where T_GSV is a field from my table)

    Invoiced Sales                            Sum(T_INV_SALES)

     

    etc.

     

    Not sure how to load the data or configure the P&L Pivot to get the above result. 

    Any help would be greatly appreciated.

    Show Less
  • Qlik Sense Deployment & Management

    Upgrade Qlisense Enterprise to June 2019

    We are currently running Qlik Sense version Qlik Sense November 2018 (qliksenseserver: 12.44.1). I want to upgrade to the latest version (June 20... Show More

    We are currently running Qlik Sense version Qlik Sense November 2018 (qliksenseserver: 12.44.1).

     

    I want to upgrade to the latest version (June 2019).

     

    Can you outline the steps involved in upgrading ?

    Show Less
  • Qlik Sense App Development

    Combo Chart with two Dimensions and Two Measures

    Hi All,We have a requirement where we need to add a Combo chart with two dimensions and Multiple measures  as bar or line graphs respectively.In ... Show More

    Hi All,


    We have a requirement where we need to add a Combo chart with two dimensions and Multiple measures  as bar or line graphs respectively.

    In QlikSense Out of the box Combo Chart we can only include one Dimension.Need to know if there is any Workaround to achieve this

    We have also tried the Combo chart extenison but it did not solve our purpose

    Regards,

    Bhargav

    Show Less

Blogs

Qlik Community Manager Blogs

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

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

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
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

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

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar
Show help for this page