Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 157,493 members
  • 8,151 online
  • 1,708,765 posts
  • 128,198 Solutions
  • 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

      Money number format

      Hi All,Would it be possible in Qlik Sense to change dynamically the money format in a chart, when you select a currency?meaning: I have 2 amounts one ... Show More

      Hi All,

      Would it be possible in Qlik Sense to change dynamically the money format in a chart, when you select a currency?

      meaning: I have 2 amounts one in USD and one in GBP. when I select the USD I would like to show the $ sing in the chart, when I select the GBP I would like to show the  £ sign.

      Thanks in advance,

      Francesco

      Show Less
    • forum

      App Development

      Extract Table Names from a Query

      Hello Qlik Experts, I have requirement here, I have a column which has the complete SQL query Executed. But I  need to extract only the table Names fr... Show More

      Hello Qlik Experts,

      I have requirement here, I have a column which has the complete SQL query Executed. But I  need to extract only the table Names from that Query in the new Column. Queries can sometimes be quite complex too.  Please find below for the sample data. Please help on the below request.

      Input Data:

      Query Statement
      Select * from [dbo].[Customer]
      select FirstName, LastName, b.city
      from [dbo].[Customer] a inner join [dbo].[GeoLocation] b 
      on a.GeographyKey=b.GeographyKey
      select distinct SupplierKey, Name, a.ProductSubcategoryKey, ProductSubcategoryName
      from [dbo].[Product] a inner join [dbo].[Supplier] b on a.SupplierId=b.SupplierKey
      left join [dbo].[ProductSubcategory] c on a.ProductSubcategoryKey=c.ProductSubcategoryKey

       

      Expected Output:

      Query Statement Expected Result
      Select * from [dbo].[Customer] [dbo].[Customer]
      select FirstName, LastName, b.city  
      from [dbo].[Customer] a inner join [dbo].[GeoLocation] b  [dbo].[Customer], [dbo].[GeoLocation]
      on a.GeographyKey=b.GeographyKey  
      select distinct SupplierKey, Name, a.ProductSubcategoryKey, ProductSubcategoryName  
      from [dbo].[Product] a inner join [dbo].[Supplier] b on a.SupplierId=b.SupplierKey [dbo].[Product], [dbo].[Supplier], [dbo].[ProductSubcategory]
      left join [dbo].[ProductSubcategory] c on a.ProductSubcategoryKey=c.ProductSubcategoryKey  
      Show Less
    • forum

      App Development

      QlikSense Straight table background color

      Hi Experts,Please suggest some solution to do header background color in Straight Table (QlikSense native object).Many Thanks  
    • forum

      New to Qlik Sense

      SHA256 Hash in a connection

      I need to connect to a REST API that uses SHA256 in its authentication. The pattern is this: generate a hash import secret key generate a SHA2... Show More

      I need to connect to a REST API that uses SHA256 in its authentication. The pattern is this:

      • generate a hash

      • import secret key

      • generate a SHA256 hash of the secter key and the salt

      • Base-64 encode the hash

      • url-encode the Base-64 encoded hash

      • transmit the result in a header

      I know how to do some of this. I can do it all in PHP, but that's not super useful right now. What i want ot know is:

      1. How can I generate a SHA256 hash?

        1. in php, it would be: $salted_hash = hash_hmac('sha256', $salt, $secretKey, true);

      2. How do I urlencode a string?

        1. in php it's simply $string = urlencode('string');

      If it helps (or it there is an extension or shortcut to use) this is to connect to a Kayako Classic REST API.

      Show Less
    • forum

      QlikView Administration

      License obtain

      I want to issue my license for the machine DESKTOP-KLS4PFQ
    • forum

      Qlik NPrinting Discussions

      Link tag not working in Qlik NPrinting HTML report

        Hi Team, We are trying to built a HTML report in Qlik Nprinting which will be embedded in Email body. We have used an external bootstrap file for ... Show More
       

      Hi Team,

      We are trying to built a HTML report in Qlik Nprinting which will be embedded in Email body.

      We have used an external bootstrap file for the layout purpose using the <link> tag in the HTML report.

      The output looks good when we preview it in Nprinting designer but not the same case when the report is received in an email body.

      Seems like the <link> tag does not work for an email and that is the reason the Bootstrap file is not loaded during the email trigger.

      Is there any other way for using <link> tag in email and if not any alternative way to include the Bootstrap file during email trigger?

      Attachment:
      IMG1 - Preview of HTML report

      IMG2 - Screenshot of report received over email

       

      Thanks in advance .

       

      Regards,

      Sudhir

      Show Less
    • forum

      App Development

      How to get Task load start time from any APP?

      I have a situation where businesses want to display the task start time in the app. Is this something that we can display? In any app, we can see when... Show More

      I have a situation where businesses want to display the task start time in the app. Is this something that we can display?

      In any app, we can see when the data was reloaded. But is there any option when the job started and when the subsequent execution is?

      I know they can go to QMC - Tasks to check this but will we be able to display this info at the app level itself?

      Show Less
    • forum

      New to Qlik Sense

      When we are doing sum of last 6 months. if any month is having 0 value, that mon...

      (sum(aggr(rangesum(above((sum({<status={'Y'},year=>}sales)),0,6)),add_month_year))) Ex:- Suppose if we are doing sum of last 6 months. If any month is... Show More

      (sum(aggr(rangesum(above((sum({<status={'Y'},year=>}sales)),0,6)),add_month_year)))

      Ex:-

      Suppose if we are doing sum of last 6 months. If any month is having 0 then that month is considering this formula. Kindly suggest any other expression/formula. it has to calculate last 6 months from 201907 to 201902 but it is calculating till 201901 because 201906 skipping (because it is having 0).

      chart :- Pivot

      201901 65
      201902 117
      201903 165
      201904 203
      201905 74
      201906 0
      201907 3

       

      Thanks in advance.

       

       

       

      Show Less
    • forum

      App Development

      Do shared spaces support storing QVDs in a folder structure?

      I am new to SaaS and I am struggling with storing QVDs in a shared space. I can only seem to store files in the DATAFILES folder. Is there a way to ad... Show More

      I am new to SaaS and I am struggling with storing QVDs in a shared space. I can only seem to store files in the DATAFILES folder.

      Is there a way to add subfolders? We will have hundreds of  QVDs.

      If there is no way. What alternative approaches could I use?

      Show Less
    • forum

      New to Qlik Sense

      Limit access to sheet

      Good morning, i'm trying to limit access to an app. I want all the user's that are in the @app_limit custom properties--(app, users custom propertis) ... Show More

      Good morning,

      i'm trying to limit access to an app.

      I want all the user's that are in the @app_limit custom properties--(app, users custom propertis) -->with only one person

      to see only the sheet 'Conto Economico' in app _Analisi_Economia.

      If i try the rule in the audit area it seems to work but in the real app nothing changes.

      Any ideas? 

      Carlaf_93_0-1656057400207.png

       

      Thanks

      Carla

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    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

    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