Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,070 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

  • QlikView Creating Analytics

    How to create a Column at scripting

    Hello All,I am Trying something like below ,it is Possible to create a column with values CV,PV,ALL.if(segment='COMMERCIAL','CV',if(segment='PERSONAL'... Show More

    Hello All,

    I am Trying something like below ,it is Possible to create a column with values CV,PV,ALL.

    if(segment='COMMERCIAL','CV',
    if(segment='PERSONAL','PV',
    if(segment='COMMERCIAL' and segment='PERSONAL','ALL')

    )) as SEGMENT

     

    I know if we select both CV and PV which is nothing but ALL, ..but User specifically  need  CV,PV,ALL 

     

     

    Thanks

    Show Less
  • Qlik Sense App Development

    Max(Date) returns invalid expression

    I have a table with field  Date(Date#("ACCTG DATE (P0045)",'yyyyMMdd'),'YYYYMMDD') as "ACCTG DATE (P0045)" and I want to have a field to return latest... Show More

    I have a table with field

      Date(Date#("ACCTG DATE (P0045)",'yyyyMMdd'),'YYYYMMDD') as "ACCTG DATE (P0045)"

     and I want to have a field to return latest date.

    I used Max("ACCTG DATE (P0045)") and get invalid expression

    Hope I can get some guidance

     

     

    Show Less
  • New to Qlik Sense

    Date Picker

    Hi, I want to add a date picker to my dashboard. I found one in the Qlik dashboard bundle but it doesn't work. Whenever I select a date it will not fi... Show More

    Hi, I want to add a date picker to my dashboard. I found one in the Qlik dashboard bundle but it doesn't work. Whenever I select a date it will not filter the rest of the data on my sheet. See images attached. Do I need to do something to get it to work?

     

    Show Less
  • New to Qlik Sense

    How to extract the date from text+date?

    Hello all,I'm learning to use Qlik Sense and trying to build my first app. I was trying to get the date from a field that looks like this:Resolution n... Show More

    Hello all,

    I'm learning to use Qlik Sense and trying to build my first app. 

    I was trying to get the date from a field that looks like this:

    Resolution notes
    ETC: 29-MAR-2020

     

    I would like to extract the date, how should I do it having "ETC: " before the date?

    Thank you very much in advance.

    Show Less
  • Qlik NPrinting Discussions

    How to use variable in N Printing Power Point report

    Hi Experts,I have to add a Dynamic text box on below Nprinting Power point report as As of 02/04/2020.For 02/04/2020 I have dragged vMaxReportDate var... Show More

    Hi Experts,

    I have to add a Dynamic text box on below Nprinting Power point report as As of 02/04/2020.

    For 02/04/2020 I have dragged vMaxReportDate variable to slide but its showing max(Report Date) expression which is the formula of variable but i am looking for 02/04/2020 as the result from that variable. Please help me on this.

    Max report date.png

    Thanks in advance

    Show Less
  • QlikView Creating Analytics

    How to write condition enabling in expression

    Hello All,i Need help in doing a condition enabling in a chart , in below combo chart by default i have to show as belowDimension: YEARMONTHExpression... Show More

    Hello All,

    i Need help in doing a condition enabling in a chart , in below combo chart by default i have to show as below

    Dimension: YEARMONTH

    Expression: 1)Prod:    Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_input)

                            2)Sale:      Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_d_op)

    Combo:  

    Untitled.png

     

    so far so good,

    Now my requirement is to do a condition enabling , I have created a inline field called Category which as values prod,sale,Brand and in each expression i have added condition as shown below

    Combo Chart:

    Dimension: YEARMONTH

    EXpression :1)   if(Getselectedcount(Category) =0 or Category='prod',

    Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_input)

    )

     

    Before selecting Category 

    Untit.png

     

     

    After selecting  prod from category

    Untitled1.png

     

     

    I am getting only Selected Year, Month prod values even after ignoring Year,Month

    Kindly suggest,how to write condition in expression.

     

    Thanks

     

      

             

    Show Less
  • Qlik NPrinting Discussions

    NPrinting On Demand error: {"code":403,"message":"User has no rights to access ...

    Hello We have been using On Demand and N Printing for a long time.  Suddenly we are receiving the error message above.  All users seem to be receiving... Show More

    Hello 

    We have been using On Demand and N Printing for a long time.  Suddenly we are receiving the error message above.  All users seem to be receiving this.  Does anyone know why this might be the case or how to check why?

    Thanks

    Paul

    Show Less
  • New to Qlik Sense

    How to add different calculations for different values in a particular column.

    Hello Everyone, I am bandari, i have just started working with qliksense. i am currently working and i am stuck somewhere and i am not finding any ans... Show More

    Hello Everyone, 

    I am bandari, i have just started working with qliksense. i am currently working and i am stuck somewhere and i am not finding any answer for it. 

    I have 13 columns like P01,P02..P12, and KPI column. for example:

    KPIq1q2q3q4
    AP03P06P09P12
    BP01+P02+P03P04+P05+P06P07+P08+P09P10+P11+P12
    CP03 P06P09P12

     

    Now i will have to calculate values for every quater(q1,q2,q3,q4) depending on each Kpi value(i.e., if its 'A' then i have  just give the sum of P03 for q2, If its 'B' then it should be sum(P01+P02+P03) for q1 likewise i have to calculate P06 for q2 and sometimes P01+P02+P03 for q2). i have importe the script . but now i dont know how to proceed furthure. Please help me do this. I have a deadline by this saturday.  Please give sample querys if possible. 

    Thank you so muh for your time .

    Show Less
  • Qlik NPrinting Discussions

    NPrinting Web Engine timeout

    Hi,Does anyone know if NPrinting, like Qlik Sense, has a configurable timeout for the web engine?We are experiencing an issue at a customer where a sh... Show More

    Hi,

    Does anyone know if NPrinting, like Qlik Sense, has a configurable timeout for the web engine?

    We are experiencing an issue at a customer where a short duration of inactivity causes the users the be thrown out and needs to log in again.

    In Qlik Sense there is a timeout setting for the proxy service (<add key="WebSocketPingInterval" value="0"/>) where the default value is "0" but when changed to 60 the session is kept alive.

    Have anyone else experienced this and if so, how did you solve it?

    BR

    Daniel

    Show Less
  • Qlik Sense App Development

    Peek Previous lookup all returns '-'

    I have below table.  The first 2 fields are loaded table fields. The 3rd field is what I want to achieve.The logic is if the Trade Num is the same as ... Show More

    I have below table.  The first 2 fields are loaded table fields. The 3rd field is what I want to achieve.

    The logic is if the Trade Num is the same as the previous, return the previous ACCTG DATE, otherwise returns blank

    As I m a new to the tool, I first try to test if I can get the previous ACCTG DATE using

    Peek(TRADE NUM, RowNo()-1)

    or Previous (TRADE NUM)

    or Lookup('ACCTG DATE', 'TRADE NUM', TRADE NUM, 'TABLE')

    All returned -. 

    Hope I can get some expert guidance

     

    ACCTG DATETRADE NUMPrevious Acct Date
    20191231503232H 
    20200131503232H20191231
    20191231503237H 
    20200131503237H20191231
    20191231960509H 
    20200131960509H20191231
    202001311096601H 
    201912311096602H 
    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.

March 25, 2020 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


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