Qlik Community

Welcome to Qlik Community

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

  • Qlik Sense Integration, Extensions, & APIs

    Custom theme - understanding .qv-object :not([font-family])

    I've created a custom theme that is behaving differently in Qlik Sense April 2019 and Qlik Sense September 2019.I've defined a font-family in my custo... Show More

    I've created a custom theme that is behaving differently in Qlik Sense April 2019 and Qlik Sense September 2019.

    I've defined a font-family in my custom css file where qv-object * should have a font different from the default QlikView Sans.  This rendered ok in Qlik Sense April 2019, but on my new Septemer 2019 version the font is overrided back to QlikView Sans due to the formatting set by Qlik. See screenshot of KPI and the dev tool showing which styling is the active for the element. If I uncheck the top styling element it fetches my custom style.

    clipboard_image_2.png

     

    My questions are.

    What does the  :not([font-family]) do? I assumed that the font family should not be set in this css section. 

    How do I get my custom css  .qv-object to override the Qlik default css?

    Show Less
  • Qlik NPrinting Discussions

    NPrinting API - Create Filter

    Hi,I'm trying to create Nprinting filters in Qliksense script, but each time I received error 400"One of the following errors has occurred:The body of... Show More

    Hi,

    I'm trying to create Nprinting filters in Qliksense script, but each time I received error 400

    "One of the following errors has occurred:The body of the request is malformed.The app with the specified 'appId' does not exist.One or more connections does not belong to the app with the specified appId.The cache for one or more connection IDs is not in status "Generated".The connection does not contain a field with the specified name."

    Based on the documentation I added to the filter's body appid, enabled and name, but issue still appers

    Could someone provide syntax of filter body?

     

    Thansk,

    Vitalii 

     

    Show Less
  • New to Qlik Sense

    Error in expression ')' expected.

    Hello everybody,I can't write the following formula correctly:Interval ({<(sum (date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and]... Show More

    Hello everybody,
    I can't write the following formula correctly:

    Interval ({<(sum (date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY')))) = {"> = $ (Start of Month ) <= $ (vDataRifA) "}>}) * Nominale_a /
    Sum ({<[Practice Date and] = {"> = $ (Start of Month) <= $ (vDataRifA)"}>} Nominale_a)

    Error in expression ')' expected.

    You can help me?
    Thanks

    Show Less
  • QlikView Scripting

    Loop in Skript detected

    Hello, I am trying to set up a new Qlikview application. I have multiple Dimension Tables and 3 Data Tables. I already concatenated 2 of them into one... Show More

    Hello, 

    I am trying to set up a new Qlikview application. I have multiple Dimension Tables and 3 Data Tables. I already concatenated 2 of them into one table. But the 2 remaining tables have a YearMonth field which is, according to my understanding, causing a Loop. I have uploaded my current Table structure for your reference. Do you have a suggestion how I can break the Loop.

    Thanks for your help.

    Stefanexport.png

    Show Less
  • QlikView App Development

    Hide a field selection into current selections box

    Hi all,usually a current selections box shows all the field selections.But I need to hide one of the field selections and show the other selections in... Show More

    Hi all,

    usually a current selections box shows all the field selections.

    But I need to hide one of the field selections and show the other selections into the current selections box.

    It exists any method to do this kind of operation?

    Regards,

    Fabio

    Show Less
  • QlikView App Development

    Set Analysis Issue using Sum

    Hi All,I have the following expression, I basically want a table where the Pallet Expected Qty is less than the Stock Cases, so it's not a full pallet... Show More

    Hi All,

    I have the following expression, I basically want a table where the Pallet Expected Qty is less than the Stock Cases, so it's not a full pallet of stock

     

    NUM(SUM({<[Product Pick Type] = {'PALLET'},[Product Cases Per Pallet] = {"=[Product Cases Per Pallet]) > SUM([Stock Cases])"}>}[Stock Cases]),$(format.number))

    Can anyone suggest why the above expression is not returning the correct result, I would have thought the above would have worked

    Thanks.

    Show Less
  • New to QlikView

    store value of Dynamic Update on access point

    Hi, thanks for reading this post, I'm using Dynamic Update on access point and I need to keep added values.On desktop everything work i have a .bat wh... Show More

    Hi, thanks for reading this post,

     

    I'm using Dynamic Update on access point and I need to keep added values.

    On desktop everything work i have a .bat which run another .qvw witch binary load on the first .qvw and store the Dynamic Update value.

    But on access point the Dynamic Update values don't seems to be in the .qww.

    Anithing know how can i keep those added value ?

    (hope my english is readable, I didn't pratice since years)

    Show Less
  • New to Qlik Sense

    firstsortedvalue with filters

    I read many other posts, but I can't apply it to my case... I think "firstsortedvalue" might be the solution. Here's my Data (I gave my best to get a ... Show More

    I read many other posts, but I can't apply it to my case...

     

    I think "firstsortedvalue" might be the solution.

     

    Here's my Data (I gave my best to get a good example):

    #Reporting PlantMaterial NumberMaterial DescriptionDirect Savings YearInvoice Amount CHFInvoice QuantityDiff. prev. YearCalc. Direct Savings CHFSavings / CostVendor Category
    1Germany12345Apple2019                          480’250.86163’681-0.4802                               -115’571.35SavingsR
    2Germany12345Apple2019                              3’952.291’125-0.4802                               -115’571.35SavingsM
    3Germany12345Apple2018                          694’002.40240’158-0.4802                               -115’571.35SavingsR
    4Germany12345Apple2018                                  940.13503-0.4802                               -115’571.35SavingsM

     

    What do I want to do:

    There are multiple same values for "Calc. Direct Savings CHF", but I only want to see the "Vendor Category", based/ranked on the <highest> "Invoice Amount CHF" per "Direct Savings Year"

     

    Example:

    #1, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2019 is higher than #2

    #3, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2018 is higher than #4

     

    Finally, out of the 4 lines, only 2 shall remain --> #1 & #3

     

    hope this makes sense!

    Thanks already 🙂

    Show Less
  • New to Qlik Sense

    Qlik Sense Deploy Multiple Dashboards Programmatically

    Hey guys!Here is my problem: i have multiple dashboards, that describe different building sites i have. These dashboards look identical, they display ... Show More

    Hey guys!

    Here is my problem: i have multiple dashboards, that describe different building sites i have. These dashboards look identical, they display identical data, the only difference is building site they bound to. They get data via REST data connection. Currently i create and update these dashboards manually, so i have to edit charts on every dashboard i have. This is acceptable when you have 2-3 dashboards, but with 10-20 and more it becomes painful, so i'm looking for something that will help me to deploy multiple identical dashboards automatically.

    My best guess at the moment is using mashups - i will create some sort of mashup template, then programmatically deploy it to my server, as far as i understand it will require programmatic creation of corresponing app and data connection for this app for using in mashup.

    Maybe there are more elegant solutions?

    Thanks in advance.

    Show Less
  • New to Qlik Sense

    Cumulative Sum in QlikSense Expression using RangeSum and Above

    Hi everybody...I am having some issues calculating a cumulative sum by Dimension type. I have looked in several forums but still haven't made it. I ha... Show More

    Hi everybody...I am having some issues calculating a cumulative sum by Dimension type. I have looked in several forums but still haven't made it. 

    I have the following table:

    year   |  Company  |  Sales

    2014  |           A          |    100

    2015  |           A          |    50

    2016  |           A          |    200

    2014  |           B          |    10

    2015  |           B          |    500

    2016  |           B          |    500

     

    And I need to get the cumulative sum for each company; getting the following result table:

    year   |  Company  |  Sales   |  Cumulative Sum

    2014  |           A          |    100     |      100

    2015  |           A          |    50        |     150

    2016  |           A          |    200     |      350

    2014  |           B          |    10       |      10

    2015  |           B          |    500     |     510

    2016  |           B          |    500     |      1010

    So as you can see, I have to sum the value of sales for each year by each Company. So far the closest I have gotten to getting my results is this expression: Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())),Company,Year)

    This starts fine but does weird stuff as the table grows...please help!

    I have been told to specifically use RangeSum ..

    Show Less

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