Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 162,693 members
  • 8,658 online
  • 1,715,452 posts
  • 129,173 Solutions
  • Announcements
    Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE

    Welcome to Qlik Community

    FOR NEW MEMBERS

    Everything you need to make your Qlik Community experience valuable.

    SEARCH KNOWLEDGE BASE

    Explore official Support and member created content.

    ASK PRODUCT QUESTIONS

    Submit questions to product experts and participate in conversations.

    Analytics

    Forums for Qlik Analytic 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

    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.

    Support

    Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

    Events

    Learn about upcoming Qlik related events, webinars and local meetups.

    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.

    About

    Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

    Blogs

    Hear directly from Qlik employees in our ten unique blogs.

    Qlik Resources

    Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

    Qlik Academic Program

    Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

    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 add a aggregation row in pivot table

      hi i'm new to qlik sense, i have a doubt in qlik sense description             portfolio1           portfolio2            portfolio3             portf... Show More

      hi i'm new to qlik sense,

      i have a doubt in qlik sense

      description             portfolio1           portfolio2            portfolio3             portfolio4         

      expenses                   2000                           100                         500                           0

      revenue                     1000                        1500                         2500                        100

       

      Now, i want a third row that row should be divided by expenses/revenue with percentage

      so if anyone knows please let me know what is the expression and where i can create the expression i mean field ASAP

      Show Less
    • forum

      New to Qlik Sense

      Syn-key from QueryResult Table

      Good morning Experts, I am facing an unprecedented situation in which a syn key is generated after the data has completed loading from the data load e... Show More

      Good morning Experts,

      I am facing an unprecedented situation in which a syn key is generated after the data has completed loading from the data load editor. The syn key arises from a table called 'QueryResult', which I am very sure I did not code for in the data load editor (and I verified this through the Search function in the data load editor). The conflicting fields in this QueryResult table with my main fact table are from a table which I had specifically dropped in the script, but somehow reappears and renamed as this 'QueryResult' table.

      Anybody faced a similar situation or know how to simply remove this table (from nowhere)?

      Thank you very much in advance,

      Jason

       

      Show Less
    • forum

      Security & Governance

      Create CSR from the Qlik Sense

      Hello, I have installed Qlik Sense Enterprise on-premise in the customer environment. The customer wants me to generate CSR from Qlik sense but I don'... Show More

      Hello,

      I have installed Qlik Sense Enterprise on-premise in the customer environment. The customer wants me to generate CSR from Qlik sense but I don't know the steps on how to create the CSR from Qlik Sense. I tried looking at the community but unfortunately, the information is archived.


      I will appreciate it if anyone can share the steps to generate CSR from Qlik Sense.

       

      Thanks and Regards
      Vaibhav 

      Show Less
    • forum

      Qlik NPrinting Discussions

      Qliksense Certificate export failing

      I wanted to connect the Qliksense with the Nprinting server. So when i try to export the certificates from QMC, it throws the error" the export of the... Show More

      I wanted to connect the Qliksense with the Nprinting server. So when i try to export the certificates from QMC, it throws the error

      " the export of the certificates failed"

      Used the root admin account to login in QMC

      Attached the screenshot of the error


      Show Less
    • forum

      New to Qlik Sense

      Pivot Total do not work properly

      Hey,   I have issue with total row in pivot table. All of my value collumns are from measures. Total work mainly with one row or simple filter. Which ... Show More

      Hey,

       

      I have issue with total row in pivot table.

      All of my value collumns are from measures.

      Total work mainly with one row or simple filter. Which is somewhat useless.

      Any help? I use only one dimension.

       

      MT4T_0-1659698442645.png

       

      Show Less
    • forum

      App Development

      Replace values

      Hi, my data looks like, Modes KD KDnew 8.0ANC nKD nKD 10.0AOR KD KD 8.0AB KD KD 8.0AB nKD KD 12.0AB KD KD 16.0AB KD KD 22.0AB nKD nKD... Show More

      Hi,

      my data looks like,

      Modes KD KDnew
      8.0ANC nKD nKD
      10.0AOR KD KD
      8.0AB KD KD
      8.0AB nKD KD
      12.0AB KD KD
      16.0AB KD KD
      22.0AB nKD nKD
      25.0AB nKD nKD
      25.0AB nKD nKD
      35.0AB nKD KD
      35.0AB KD KD
      35.0AB nKD KD

      in this Modes 8.0AB and 35.0AB showing KD column as KD and nKD will replace these values to KD. like KDnew column as my output. i am trying if condition not working help me thanks.

      Show Less
    • forum

      Deployment & Management

      A lot db connectors not shown in HUB

      Dear Supporter, We build the qliksense in Alicloud vm , but the db connectors not shown there,  it's work for built in google cloud platform vm, may I... Show More

      Dear Supporter,

      We build the qliksense in Alicloud vm , but the db connectors not shown there,  it's work for built in google cloud platform vm, may I get your suggestion , many thanks.

       

      We want to clear these db connector is  installed in the qliksense exe file or other places ? Many thanks.

      Show Less
    • forum

      New to Qlik Sense

      How to add custom header to access Qlik enterprise

      Hello Experts, We have deployed Qlik sense in the customer environment and the customer now wants to add a header through which they can log i.e. in i... Show More

      Hello Experts,


      We have deployed Qlik sense in the customer environment and the customer now wants to add a header through which they can log i.e. in instead of localhost/hub or localhost/QMC they want  customheader/hub or customheader/qmc

      Can you please provide steps on how to add a custom header to Qlik Sense?

      Thanks and Regards

      Vaibhav

      Show Less
    • forum

      New to Qlik Sense

      Alternative State with 2 different period of selected time and Set Analysis for ...

      Hi,   Tried to built a dashboard for retail and allow store user to select 2 different time periods with some calculation to compare the sales result ... Show More

      Hi,  

      Tried to built a dashboard for retail and allow store user to select 2 different time periods with some calculation to compare the sales result at product level, customer level.  Usually store people would like to look at the product and customer variance during different period especially to compare the sale uplift in different promotion period.

      We have a daily raw data sales format like following (a simply version).  And it is easily enough for me to bring in branch, product hierarchy table into Qlik as well.

      Date Branch Trade Type Category Product ID Sales
      1/01/2021 ABC In Store Apple 1 $12,546
      1/01/2021 ABC Online Apple 1 $45,246
      2/01/2021 ABC In Store Apple 2 $10,796.01
      2/01/2021 ABC Online Apple 2 $44,807.48
      3/01/2021 ABC In Store Orange 3 $7,531.89
      3/01/2021 ABC Online Orange 3 $20,264.39
      4/01/2021 ABC In Store Orange 4 $2,090.01
      5/01/2021 ABC Online Banana 5 $11,154.45
      1/01/2021 XYZ Online Apple 1 $449.26
      2/01/2021 XYZ Online Apple 2 $874.88
      3/01/2021 XYZ Online Orange 3 $12.44
      4/01/2021 XYZ Online Orange 4 $112.13
      5/01/2021 XYZ Online Banana 5 $4.05


      Dashboard looks like the following:
      Allow user to select Primary date range period that I've applied alternative group called "Primary" into the filter.  And done the same for Comp Period as "Comparable" group.

      We're trying to do an "apple to apple comparison" by selecting different time period.   The table shows sales various by product.  (I will need to create the same table for Customer)

      Gavin_FBu_0-1659918034884.png

      Sales Primary = sum({Primary}Sales)
      Sales Comp = sum({Comparable}Sales)
      will return us the sales within the selected periods but won't drill down if select any dimension in the filter.

      So I learnt:
      Sales Primary = sum({Primary<[Branch]=$::[Branch],
                                                                       [Trade Type]=$::[Trade Type]
                                                                       [Category]=$::[Category]
                                                                       [Product ID]=$::[Product ID]>}Sales)
      Ps:  Same applied into Comparable Sales as well:

      I am still bit struggle to understand $ vs P.  but it looks OK so far, my question is

      1.  My dimensions are getting bigger (adding in 15 more dimensions such as trade account num, customer, sales channel.  Instead to adding all the dimension one by one within this formula (sometime may missed), is there any way we can included all dimension?

      2.  Hope if anyone can help me to understand what is [Branch]=$::[Branch] mean?  :: and what is the different between $ vs P.

      3.  If we build a chart, we can use alternative dimension to swap the dimension across with the same measurement.  Wonder if any easy way for table?  The only option I've got is to create all the require dimension tables within a container so user can change across.  Is anyone have any better suggestion?

      Many Thanks

      Show Less
    • forum

      Qlik Compose for Data Warehouses

      Max (Attribute Value) in a CDC Process

      In a CDC load environment, how do you maintain an attribute value that represents the maximum or minimum value over a set of records?  For example, if... Show More

      In a CDC load environment, how do you maintain an attribute value that represents the maximum or minimum value over a set of records? 

      For example, if I have an order with three items, I want to create an attribute called MaxItemRequestDate where this value is the max Request date among the three items.

      I have tried using a windowing function on both the entity and in the mapping. But, looking at the task list scripts SQL, it looks as if in the CDC process the function will only be performed over the delta rows in the TSTG "staging" table, and not the entire row set like it would be in a full load.

      Can I have the best of both worlds ?

      Thanks!

      Show Less

    Blogs

    Community News

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

    Blogs

    Qlik Academic Program Blog

    Read the latest blog around the Qlik Academic Program.

    Blogs

    Qlik Product Innovation Blog

    If you want to know what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Get the latest Support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Qlik Design Blog

    Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

    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

    Events and Webinars

    QlikWorld Tour

    Discover your data swagger at a city near you.

    Find your city

    Events and Webinars

    Qlik and Qlik Community Hosted Events

    Subscribe to our Events and Webinar page so you do not miss an event opportunity!

    choose and register

    Event

    Welcome to Qlik

    Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

    On-Demand

    Events

    Upcoming Events and Webinars

    There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

    Upcoming