Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,323 members
  • 7,714 online
  • 1,998,164 posts
  • 149,811 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Reporting Service

    Tabular Reporting - Table size

    Hello everyone, I am trying to distribute a slightly larger table with Tabular Reporting. The table has 31 columns and, depending on the filter, 100-2... Show More

    Hello everyone,

    I am trying to distribute a slightly larger table with Tabular Reporting. The table has 31 columns and, depending on the filter, 100-200 thousand data records.

    When I try to export it, I get the message in the preview: Max number of objects exceeded in report, error code: REP-400039.

    Now the help (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-service-specifications-limitations.htm) says something about

    Reporting limits for the Qlik add-in for Microsoft Excel
    Metric Value
    Maximum number of nested levels in a template 5
    Maximum number of object tags in a template 200
    Maximum number of objects per generated report

    A single chart, variable value, level value, or expression value counts as one object.

    For Excel tables, 500 generated cells count as one object. If there is an additional remainder of less than 500 cells (for example, several smaller tables containing a total of as many as 499 cells), this does not count as an object.

    50,000
    Maximum number of generated images in a report 1,000.

    Does this mean that I can generate a maximum of 50,000 cells per report (in my case 31 columns x 1612 rows)? Per Excel file, per tab sheet?

    Maybe someone can help?

    Thanks and regards.

    Show Less
  • forum

    Qlik Enterprise Manager

    What is QVX ?? Do we have any real world use case for this??

    Hi Experts Please help with real-world experience using QVX files kindly share some insights into their use cases? Additionally, if there are any rel... Show More

    Hi Experts

    Please help with real-world experience using QVX files kindly share some insights into their use cases?

    Additionally, if there are any relevant documentation or resources available on this topic, I'd greatly appreciate it if you could share them as well.

    Thank you!

    Show Less
  • forum

    Connectivity & Data Prep

    copy value from field to another until specific line of a new value is reached

    I have dataset like this TranID Line nr itemCode LineType 123 1 Gitem1 group 123 2 item12 inv 123 3 item34 inv 123 4 - endgroup 123 5 Git... Show More

    I have dataset like this

    TranID Line nr itemCode LineType
    123 1 Gitem1 group
    123 2 item12 inv
    123 3 item34 inv
    123 4 - endgroup
    123 5 Gitem2 group
    123 6 item55 inv
    123 7 item6 inv
    123 8 item5 inv
    123 9 - endgroup
    1235 1 Gitem12 group
    1235 2 item12 inv
    1235 3 item34 inv
    1235 4 item76 inv
    1235 5 - endgroup
    1245 1 Gitem17 group
    1245 2 item6 inv
    1245 3 item8

    inv

     

    and I want a new field ItemGroup where is the group item of each line that it belongs too. 

    So I basically want to add the itemcode (example Gitem1) of the LineType "group" to new field ItemGroup

    to all the fields with the same TranID as long as LineType "endgroup" is reached. After that the next group's itemCode is added to the next lines to ItemGroup -field

    TranID Line nr itemCode LineType ItemGroup
    123 1 Gitem1 group Gitem1
    123 2 item12 inv Gitem1
    123 3 item34 inv Gitem1
    123 4 - endgroup Gitem1
    123 5 Gitem2 group Gitem2
    123 6 item55 inv Gitem2
    123 7 item6 inv Gitem2
    123 8 item5 inv Gitem2
    123 9 - endgroup Gitem2
    1235 1 Gitem12 group Gitem12
    1235 2 item12 inv Gitem12
    1235 3 item34 inv Gitem12
    1235 4 item76 inv Gitem12
    1235 5 - endgroup Gitem12
    1245 1 Gitem17 group Gitem17
    1245 2 item6 inv Gitem17
    1245 3 item8 inv Gitem17

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Only show the newest date (valid from)

    Hi there 🙂 I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-... Show More

    Hi there 🙂

    I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-from dates (one per product). Thats it 😄 

    Coud you please help me out with the script function. Attached you find the table load.

    Thanks a lot!
    Pesche

    Show Less
  • forum

    App Development

    Find a Value in a selected line in a table box

    How can i Find a value from a field in one selected line in a Table box.
  • forum

    Qlik NPrinting

    PixelPerfect pie chart bug on percentage label

    Hi When a pie chart or a donut chart is natevely created in the PixelPerfect template, there is a bug displaying the last label of the percentage. In ... Show More

    Hi

    When a pie chart or a donut chart is natevely created in the PixelPerfect template, there is a bug displaying the last label of the percentage.

    In fact if the last percentage and first percentage values are between 1% and 3% than their label get swapped clockwise after the first label. Wrongly displaying the labels.

     

    The Resolve Overlapping Mode property behavior does not move the label to the right side. See attached images.

    It happens on all NPrinting versions.

    How can this be fixed?

     

    Kind regards

    Hatus Peters

    Show Less
  • forum

    Qlik Reporting Service

    Qlik Cloud Emailing report with filters

    Hi all,I have been attempting to set up email reports using Qlik Cloud and haven't been able to find answers if QlikCloud is capable of doing what I a... Show More

    Hi all,
    I have been attempting to set up email reports using Qlik Cloud and haven't been able to find answers if QlikCloud is capable of doing what I am aiming to achieve.

    I have a qlik cloud app that I am trying to send multiple email snapshots of the graph within the app via email to users each day. For each snapshot, it will be selecting a different filter (e.g. location). 

    I have managed to achieve this as individual email reports, however I was wondering if there is a way to combine all of these into a single email report (and associated PDF).

    Show Less
  • forum

    Catalog and Lineage

    Domino's Pizza Tracker-type graphic

    Completely new to Qlik. I'm been asked to create a a "Domino's pizza tracker" like graphic that is colored based on the status of the activity. A user... Show More

    Completely new to Qlik. I'm been asked to create a a "Domino's pizza tracker" like graphic that is colored based on the status of the activity. A user could then click on a "section" to get more details. Does anyone know how I could go about creating something like this?

    Show Less
  • forum

    New to Qlik Analytics

    The Paris 2024 Olympic Games with Qlik sense 🥇🥈🥉

    Hello, The Paris Olympics are in 426 days! In the meantime, we have just developed a mashup made with #Qlik and #Talend to analyze data from all the O... Show More

    Hello,

    The Paris Olympics are in 426 days!

    In the meantime, we have just developed a mashup made with #Qlik and #Talend to analyze data from all the Olympic Games since 1896️ : 51 editions, 223 countries, 729 events, +19k medals, + 140k athletes…

    link : https://www.acssi.fr/jo2024/

    2023-05-27_06h46_54.png

    In progress : English language, font optimization, new Data, optimizations, addition of Winter Olympics data for the last 2 editions, Paris Olympics calendar, live statistics of the Paris Olympics...

    Do not hesitate to share your feedback and your ideas with us so that we can evolve the web site.

    Many Thanks,

    Olivier

     

    Qlik Sense Enterprise on Windows #sport #talend

    Show Less
  • forum

    Integration, Extension & APIs

    Correct management of sessions between QlikSense and third party website

    Hello! We have QlikSense on prem; at the authentication level, we would like to connect a website where users authenticate using Office365 accounts, t... Show More

    Hello!

    We have QlikSense on prem; at the authentication level, we would like to connect a website where users authenticate using Office365 accounts, to the QlikSense application.

    I'll try to explain our need: we have a website; users authenticate with their Office365 accounts. They exists also on QlikSense in the users list because the list is automatically updated every day. I want that when a user log in into the website, he is authenticated also on QlikSense. 

    How can I accomplish this?

    I tried to explore the solutions in the documentation, bot got lost.

    Thank you

     

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!