Qlik Community

Welcome to Qlik Community

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

Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

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.

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!

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

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    Set Analysis with expression having changing value .

    Hello ,I am trying to use a expression in set analysis .The expression value is changed by dimension.I use Sense 2020 Sep. version.The data to be used... Show More


    Hello ,

    I am trying to use a expression in set analysis .
    The expression value is changed by dimension.
    I use Sense 2020 Sep. version.

    The data to be used is following .

    The Data ------------------------------
    ItemCode TRDate              Price             Comment ( Not Data ) 
    1001           2020/10/01      1,000
    1001          2020/10/02       2,000
    1001          2020/10/03       3,000          - last Date of  1001 
    2001          2020/09/01       3,000
    2001          2020/09/10       2,000
    2001          2020/09/30       2,500          - last Date  of  2001
    3001          2020/05/01       3,000
    3001          2020/05/31       2,000          - last Date  of  3001
    ----------------------------------------------
    The chart required is the last TRdate and the last price at last TRDate .

    Chart ------------------------------------------------------
    ItemCode LastDate           LastDayPrice
    1001           2020/10/03      3,000
    2001           2020/09/30      2,500
    3001           2020/05/31      2,000
    --------------------------------------------------------------

    The expression for LastDayPrice is difficult to be soloved .
    Is it possibe to make a the required chart .

    Thanks,

    Jay H Cho

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Can we disable log just for one application?

    Hi Guys,We have a requirement to stop logging queries of one particular application mostly because of the PII security concerns over the parameters of... Show More

    Hi Guys,

    We have a requirement to stop logging queries of one particular application mostly because of the PII security concerns over the parameters of the query? 

    Can we disable log just for this particular application? Or could we encrypt the logs for this particular app?

    Please advise.

    Thanks in advance.

    Regards,

    Ritesh Pathak

    Show Less
  • forum

    New to QlikView

    hourly breakdown of data

    Hi Team,I have a table like below which has date campaign clicks and hour.Every hour when data gets pulled from DB, its a cumulative hourly pullEg:  w... Show More

    Hi Team,

    I have a table like below which has date campaign clicks and hour.

    Every hour when data gets pulled from DB, its a cumulative hourly pull

    Eg:  when data is fetched at 3am, it fetches from 12am -3am  & when data is fetched at 4am, it fetches from 12am -4am

    So my requirement is to get a hourly breakdown for the clicks for each hour as shown in Output

    How to achieve this in back end script?

     

         Output 
    Datecampaign ClicksHour Hour BreakdownClicks
    24/11/2020A1001 1100
    24/11/2020A2502 2150
    24/11/2020A4003 3150
    24/11/2020A7004 4300

     

     

    @Kush @sunny_talwar @Taoufiq_Zarra 

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense Dev-Hub does not open in IE but does in Chrome

    Hello,I have noticed that the Qlik Sense Dev-Hub does not open in IE on a new install with HTTPS but does on Chrome.  What I get are the circles.Does ... Show More

    Hello,

    I have noticed that the Qlik Sense Dev-Hub does not open in IE on a new install with HTTPS but does on Chrome. 

     

    What I get are the circles.

    Does anyone have a solution?

    Thank You,

    Michael

    Show Less
  • forum

    QlikView App Development

    count all skucodes in textobject with aggregation and set analysis: wrong total

    Hello,i would like to do a count of all Sku codes with these 3 conditions:1 = "info" equals Active or Liquidation2 = "TypeArtikel equals Normaal3 = bu... Show More

    Hello,

    i would like to do a count of all Sku codes with these 3 conditions:

    1 = "info" equals Active or Liquidation

    2 = "TypeArtikel equals Normaal

    3 = but also  where the sum of [AK # open] + sum ( {<warehouse_name = {"WHS BE"}>}qty - sum ( qty_unit_open ) for each sku-code is less than zero

    And i don't know where to place that last part.

     

    I have this formula:

    =count ( {<info = {'Active','Liquidation'}, TypeArtikel={'Normaal'} >} ( (Aggr( (sum ([AK # open])+sum ( {<warehouse_name = {"WHS BE"}>}qty)-sum ( qty_unit_open )),sku_code)<=0)))

    But then it only gives me the number of all sku_codes for the first 2 conditions, but it doesn't take into account that the aggregated sum must be less than zero.

     

    Any idea on what i might do to fix this?

     

    htanx!

     

    Chris

    Show Less
  • forum

    New to QlikView

    Probleme Calcul Total TCD

    Hello, I want to add the total column, I added it by "presentation" -> "show partial sums", but it does not calculate the totalthe expression
  • forum

    QlikView App Development

    KPI style

    Does anyone know this style of KPI plugin, thank you very much
  • forum

    New to QlikView

    Cumulative Count Distinct Ignoring Certain Dimension Filters

    Here is the issue I am having. I have a table chart with a count and cumulative count(using the Full Accumulation radio button on the Expressions Tab)... Show More

    Here is the issue I am having. I have a table chart with a count and cumulative count(using the Full Accumulation radio button on the Expressions Tab). 

    When I have nothing filtered the values are as expected.  But as I start filtering the cumulative Count adjusts to the filter by excluding values outside the filter context. 

    In the two screenshots posted. I want the #CumCount values shown in the screenshot without filters also to show up in  the case where filters are selected.

    The #CumCount for Jun 2020 should be 19,035 instead of 3,000 all the time.

    I want to calculate the cumulative count ignoring some or all of the filter contexts.  Is there an expression for that?

    With out Filters

    sqlpuzzle_0-1606335338429.png

     

    With Filters

    sqlpuzzle_1-1606335391524.png

    Thanks

    Show Less
  • forum

    Qlik NPrinting Discussions

    Task times for reports with multiple email destinations

    I have an Excel report that uses a cycle, and has levels and paging, and the destinations include one network folder, 2 individual email addresses (on... Show More

    I have an Excel report that uses a cycle, and has levels and paging, and the destinations include one network folder, 2 individual email addresses (one of which is myself), and an NP Group that has 3 users/emails.  I have noticed that if I run this just for myself and the folder destinations, it runs in about 30 mins, however when all destinations are included (5 user emails and 1 folder) it runs well over 3 hours (I actually killed the task 3.5 hrs in; it was 83% done).  I know cycles, levels and paging add a lot of performance overhead, but what else is happening to make this run so long?  Does NP generate one report and then distribute it or is it going through the process of re-generating a report for each destination?  Does it not like an NP Group as a destination?  Looking for any insight.  Thanks.

    Show Less
  • forum

    New to Qlik Sense

    Coloring a cell as per the the value based on condition

    Hi Experts,Please find the attached excel file, where i need to get color as per the value present in cell.Ex: If the cell value is DGR the cell color... Show More

    Hi Experts,

    Please find the attached excel file, where i need to get color as per the value present in cell.

    Ex: If the cell value is DGR the cell color should reflect as "Green color" in Qliksense.

    I did crosstable for all the months (1,2,3...12) and values(DGR,LGR..) as Data

    like Crosstable(Month,Data,7)

    So coloring the cell in qliksense i used the below expression. but its showing error.

    If(Data="DGR",Green())  I even tried If(Data="DGR",RGB(102,204,0)) but no luck

    Kindly help me with the Expression please

    Thank You 🙂

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

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

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

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

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand