Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
1,378 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

    How to delete sheets(IDs available in external sheet) via repository API

    Hi techies,I have a use case where I need to delete Qlik app sheets which are unused since last one year. I have collected the concern sheet ids from ... Show More

    Hi techies,

    I have a use case where I need to delete Qlik app sheets which are unused since last one year. I have collected the concern sheet ids from operation monitoring app. Lets say concern sheets are 500 from 1 app. I am looking for a way that I delete such sheets from   repository API by picking sheet ids from external sheet which has sheet id exported from operation monitoring app.

    I have found a document which has information how to delete single sheet in one request but I need to send request for all 500 sheets in one go, like picking sheet id one by one and send request to QSR database via API.

    https://support.qlik.com/articles/000055464

     

    Please help me to achieve my goal

    Thanks in Advance

    Rohit

     

    Show Less
  • New to Qlik Sense

    Expression Help: Need a filterable bar graph with multiple dimensions displayin...

    Hi everyone,   I need a bar graph that shows average profit on rims and tire sales (hypothetically) for each car brand grouped by month (picture at bo... Show More

    Hi everyone,   

    I need a bar graph that shows average profit on rims and tire sales (hypothetically) for each car brand grouped by month (picture at bottom)

    So imagine on the left of the graph the annual profit per car sold of Hondas each month (12 bars, one for each month) and then next would be the same thing for Toyota, etc.  The height of the graph would be average profit per car.

    Ideally this would be both a grouped graph and a stacked graph, but that capability doesn't exist.  So the height would be the sum of the averages.  So, for example, if the company averaged $1,000 in rim profits per car, and $100 in tire profits per car, the height of that bar would be $1,100 in wheel profits per car (not $550, which is what the average function would give me).

    I want a filter that would show the average if it was just Rims, just Tires, or both Rims and Tires.

    Here's an example of a piece of the table:

    BRAND  TYPE  PROFIT UNITS  MONTH
    Honda    Rims  $10,000  10   March
    Honda    Tires     $1,000  10   March
    Honda    Rims  $12,000  12   March
    Honda    Tires         $600  12   March
    Nissan    Rims  $10,000  10    April
    Nissan    Tires     $1,000  10    April
    Nissan    Rims  $26,000  13    April
    Nissan   Tires      $1,950  13    April


    I wrote this expression, which gives me what I want, except that the filters don't operate when it is written this way:

    Sum({<TYPE={Rims } >}PROFIT) / Sum({<TYPE={Rims } >}UNITS) + Sum({<TYPE={Tires } >}PROFIT) / Sum({<TYPE={Tires } >}UNITS)



    Note:  I created this report in another application and was able to work around this by adding a row called "total" under TYPE which would be the subtotals.  Then, in the application they could select Rims, Tires, or Total and I used a feature that forced the user to always have exactly one choice selected.


    Thanks!
    Qlik Wheels.jpg



     

     

    Show Less
  • New to Qlik Sense

    Loading vertically stored data into columns, Tried a CrossTable, but it is not w...

    The data warehouse we are connecting to has data in tables stored vertically and horizontally. All the ones that are horizontally stored I am having n... Show More

    The data warehouse we are connecting to has data in tables stored vertically and horizontally. All the ones that are horizontally stored I am having no issues with. However the vertical ones I am.

    The load statement is the following (Simplified):

    CROSSTABLE(item, TEXT_VALUE, 3)
    LOAD
        [ID],
        [PREV_ID],
        [SUB_ID],
        [FIELD_NAME],
        [TEXT_VALUE]
        [NUMBER_VALUE];

    Currently the data is in this format in the MySQL database.

    IDPREV_IDSUB_IDFIELD_NAMETEXT_VALUENUMBER_VALUE
    8849211AMT 551
    8849211VALUE 125758
    8849211HTS5556.55.1000 
    8849211HTS DESCGOAT FUR 

     

    I need to make AMT, VALUE, HTS, HTS DESC, have their own columns, with the data associated with them.

    Such as

    IDPREV_IDSUB_IDAMTVALUEHTSHTS DESC
    88492115511257585556.55.1000GOAT FUR

     

    I tried using a CrossTable, but not seeming to get results that would work. Any suggestions on what I should use or how to get this better setup better?

    Note PREV_ID links to the KEY in the parent table, and SUB_ID links it to the Part Number associated with these. Some have 50-100 part numbers. So these get huge very quickly. I requested these be split out, but didn't resolve the issue as more empty lines were created which made it even harder as more columns and more blank rows of data with 1 value in AMT, VALUE, HTS, or HTS DESC.

    Show Less
  • Qlik Sense App Development

    YTD comparison minus one day

    Our data warehouse is always one day behind. This makes true inYTD comparisons unequal unless I subtract.For example, on 4/2. If I'm doing a compariso... Show More

    Our data warehouse is always one day behind. This makes true inYTD comparisons unequal unless I subtract.

    For example, on 4/2. If I'm doing a comparison between the current year and the previous year, I'm comparing data up to 4/1 in the current year but 4/2 in the previous year.

    I'm using an auto-calendar but I don't see a "DaysAgo" option. 

    This is my current set analysis for the previous year's Sales measure. I need this to be inYTD, 1 year ago, but also one day before to make it equal. Does anyone have any recommendations?

    Sum( { $< [INV_DATE.autoCalendar.InYTD]={1}, [INV_DATE.autoCalendar.YearsAgo]={1} > } [SALES] )

     

     

    Show Less
  • New to QlikView

    Fiscal Year expense calculation

    I have data as below to calculate the Total Amount.IDAmount IDAmountStart DateEnd Date800110855.353/1/2018 0:0010/31/2018 23:59800211107.811/1/2018 0:... Show More

    I have data as below to calculate the Total Amount.

    IDAmount IDAmountStart DateEnd Date
    800110855.353/1/2018 0:0010/31/2018 23:59
    800211107.811/1/2018 0:0010/31/2019 23:59
    800111410.7411/1/2019 0:0010/31/2020 23:59

     

    In this FY is from July 1st - June 30th.

    Below should be the calculation.

    FY for 2019 is July 2018 - June 2019.Based on the start date and End date there are 4 Months in 1st row and 8 months in 2nd row that falls under the 2019 FY.so Expense would be (10,855 * 4) + (11,107*8) = 132,283.

    FY for 2020 is July 2019 - June 2020.Based on the start date and End date there are 4 Months in 2nd row and 8 months in 3rd row that falls under the 2020 FY.so Expense would be (11,107*4) + (11,410*8) = 135,717.

    I want to show Expense by Year in bar chart.

    Thank you much

    Show Less
  • Qlik Sense Deployment & Management

    Can I disable a user in our domain directory manually?

    Our primary user directory is tied through LDAP to our company's domain.  Because of the COVID-19 situation, we are furloughing some of our workforce.... Show More

    Our primary user directory is tied through LDAP to our company's domain.  Because of the COVID-19 situation, we are furloughing some of our workforce.  Management wants their Qlik access removed during this period.  They are not disabling the account through AD so the users remain active in Qlik.  Is there any way to override this and inactivate the users temporarily through a secondary process using an API?

    Show Less
  • New to Qlik Sense

    How to change Background color of title of vizlib kpi designer box

    Hi All, I have a requirement to change the Title background color of vizlib kou designer box .Does anyone know how to do it . Regards, 
  • Qlik Replicate Discussions

    Modify Attunity Envelope to adhere to CloudEvents Specification

    Hi Guys:We would like to know what is the best approach to modify the Attunity Envelope sent by the Qlik Replicate to adhere to some of the principles... Show More

    Hi Guys:

    We would like to know what is the best approach to modify the Attunity Envelope sent by the Qlik Replicate to adhere to some of the principles of the CloudEvents 1.0 specification. https://cloudevents.io/

    The Cloud Events Specification seems to be very flexible and some of the fields included at the Attunity Envelope comply to it. This is the Attunity Envelope in YAML for readability purposes (Please imagine this is a JSON file)

    type: record
    name: MessageEnvelope
    fields:
        - name: magic
          type: fixed
          size: 5
        - name: type
          type: string
        - name: headers
          type: map
          values: string
        - name: messageSchemaId
          type: string
        - name: messageSchema
          type: string
        - name: message
          type: bytes

      

    This is an example of the Cloud Events Specification 1.0 in YAML.

    specversion: '1.0'
    type: com.example.someevent
    source: /mycontext
    id: C234-1234-1234
    time: '2018-04-05T17:31:00Z'
    comexampleextension1: value
    comexampleothervalue: 5
    datacontenttype: application/json
    data:
        appinfoA: abc
        appinfoB: 123
        appinfoC: true

     

    On our understanding, this is similar to the envelope 

    type: record
    name: MessageEnvelope
    fields:
        - name: specversion
          type: string
        - name: type
          type: string
        - name: source
          type: string
        - name: time
          type: timestamp
          value: '2018-04-05T17:31:00Z'
        - name: comexampleextension1 # This is extension
          type: string
          value: value
        - name: comexampleothervalue
          type: string
          value: 5
        - name: id
          type: string
        - name: datacontenttype
          type: string
          value: application/json
        - name: data
          type: json
          data:
            appinfoA: abc
            appinfoB: 123
            appinfoC: true

     

    Just to reformulate the question, what is the best approach to extend the Message Envelope from Qlik Replicate to accommodate the fields from the Cloud Events specifications which are not found. This is very useful as it would allow to simplify the monitoring among other things.

    Kind regards

    Gonzalo Pérez-Prim

    Show Less
  • QlikView App Development

    ApplyMap()

    Hello,Please find attached my sample Qlikview doc.The Asssignments table is my main table. It has 2 rows with 2 dats.My datebridge table has 4 rows. I... Show More

    Hello,

    Please find attached my sample Qlikview doc.

    The Asssignments table is my main table. It has 2 rows with 2 dats.

    My datebridge table has 4 rows. I want to get the two rows from the Assignment table and eliminate duplicates.

    The count of file number should only be 2 in the datebridge table - 1 for each date in the Assignment table and not 4

    Please advise as to how.

    Thanks

    Shashank

     

     

    Show Less
  • Qlik Replicate Discussions

    Replicate for datalake

    Hi,Is there any option, to maintain the historical data from source to datalake using attunity replicate. I know that Qlik also has attunity compose f... Show More

    Hi,

    Is there any option, to maintain the historical data from source to datalake using attunity replicate. I know that Qlik also has attunity compose for datalake. But instead of taking another tool, is there any option to maintain historical data in replicate tool itself. 

    Instead of creating the change tables, the main tables itself should maintain the history of the record for past some days , say example : past 7 days data.

    If so please let me know. Appreciate your help.

     

    Thanks,

    Deepthi.

    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