Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
9,043 online
Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER

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

    Qlik Sense App Development

    Count based on other field value

    Hi,I have the following tables:[CAMPOCHECK]:Load[IDCAMPOCHECK],[IDPROPRIEDADEUNICA] FROM TABLE X;//Use previous and peek to get the previous IDCAMPOCH... Show More

    Hi,

    I have the following tables:

    [CAMPOCHECK]:
    Load
    [IDCAMPOCHECK],
    [IDPROPRIEDADEUNICA] 
    FROM TABLE X;

    //Use previous and peek to get the previous IDCAMPOCHECK for each record.
    [IDBEFORE]:
    Load
    [IDCAMPOCHECK],
    [IDPROPRIEDADEUNICA],
    If([IDPROPRIEDADEUNICA] = Previous([IDPROPRIEDADEUNICA]),Peek('IDCAMPOCHECK'), Null()) as [IDCAMPOCHECKBEFORE]
    Resident [CAMPOCHECK]
    ORDER BY [IDPROPRIEDADEUNICA],[IDCAMPOCHECK];

    //DETAILS
    [CAMPOCHECKDETAIL]:
    Load
    [IDCAMPOCHECKITEM],
    [IDCAMPOCHECK],
    [VALUE]
    FROM TABLE Y;

    What I need to achieve is an expression that show the previous COUNT of [IDCAMPOCHEKITEM] for each [IDCAMPOCHECK] based on [IDCAMPOCHECKBEFORE] in a table like this:

    previous countprevious count

    OBS: can't use above or bellow in this case. 

    Thank you,
    Henrique

    Show Less
  • forum

    New to Qlik Sense

    SAN storage for shared data store in Qlik sense server?

    Hi,We need to implement a SAN storage for our PROD so that another server can take over if it is down.We want both the servers to access the same data... Show More

    Hi,

    We need to implement a SAN storage for our PROD so that another server can take over if it is down.

    We want both the servers to access the same data share.

    Is having the data share on a SAN the best option?

    DID anyone implement SAN for qlik sense? Could you please tell me the best approach for this?

    Show Less
  • forum

    New to Qlik Sense

    How to Sort Month Year

    Hi,I want to sort the month year in the below order, could anyone help me.Required order, Current order,Thanks, Jishnu
  • forum

    Qlik Sense Deployment & Management

    Automatic filters when you open an App

    Hi. I need to publish an application that contains user data. For the access level I need that: If the user who enters is one on which the application... Show More

    Hi. I need to publish an application that contains user data. For the access level I need that:

    • If the user who enters is one on which the application contains data, bring the "User" field that is available in the app filtered by that user (just the filter applied,  does not filter the model data)For example, if i'm the user Arregui, 

      When I enter the application, the "User" filter should be applied, but it should allow me to modify it and see all the data of the model

    Capture.JPG

    • If the user who enters is NOT in the list of users in the "User" field available in the app, do not apply this filter

    Capture2.JPG

    I hope you can help me. Thank you very much

    @sguerra2 

    Show Less
  • forum

    QlikView Deployment

    Internal inconsistency, general exception in UV event loop

    Good MorningI'm facing a recurent problem, almost once or twice a day my qlikview server restarts by itself.I noticed many error messages for these re... Show More

    Good Morning

    I'm facing a recurent problem, almost once or twice a day my qlikview server restarts by itself.

    I noticed many error messages for these restarts but the most reccurent one of them is this

    Internal inconsistency, general exception in UV event loop

    yassinemhadhbi_0-1601976083078.png

     

    and it's really become an annoying problem since i'm dealing with very large applications (3 applications > 1 0GO) and loading them back to the take a lot of time.
    Any suggestions why this happens?

    Show Less
  • forum

    QlikView App Development

    Attempt to lease licence shows no apps on server

    TL;dr:  when I get to the window in OpenInServer where I've connected to the server, I get no applications to choose from, and therefore cannot lease ... Show More

    TL;dr:  when I get to the window in OpenInServer where I've connected to the server, I get no applications to choose from, and therefore cannot lease a license.  Has anyone seen this/gotten around it?

    This is a new server box, hoping to replace an old buggy one with a fresh install.  I've gotten server to work, run jobs, publish to a webserver, however, I will need to use Desktop to edit a few qvws, and I haven't been able to license it.  I have been on the phone with support, they've confirmed the LEF shows there are license to be leased, and we poked around but found no issues in server or desktop installs, and the correct port is open.  My netops guy has peeked at the security, and doesn't see anything different from my actual production server.

    Any ideas?

    Show Less
  • forum

    New to Qlik Sense

    IsNum vs IsText

    Hi all,I have three fields in my script which are numbers. I've confirmed this by doing "isnum()" on each of the fields. They are the 3 columns on the... Show More

    Hi all,

    I have three fields in my script which are numbers. I've confirmed this by doing "isnum()" on each of the fields. They are the 3 columns on the right in this screenshot. However, in my script i am creating a new field called test by doing this: BPtest&MRNtest&datetest as test.

    However, there are some results that are no longer considered numbers. If I do num(BPtest&MRNtest&datetest) as test in my script, those instances do not generate any number and are null. Any ideas why if the subparts are numbers why the whole isn't? And any ideas how to solve this?

    melissapluke_0-1603385231222.png

     

    Show Less
  • forum

    New to Qlik Sense

    Converter linha em coluna

    Olá! Tudo bem?Estou com a seguinte dúvida.Estou com uma tabela com os ids concatenados. Gostaria de saber alguma forma de transforma esses ids concate... Show More

    Olá! Tudo bem?

    Estou com a seguinte dúvida.

    Estou com uma tabela com os ids concatenados. Gostaria de saber alguma forma de transforma esses ids concatenadso em colunas. E que eles sejam relacionados. Ex: Que o 02.1.1 esteja dentro de 02.1

    Valber1_1-1603378134903.png

     

     

    Show Less
  • forum

    New to Qlik Sense

    De-Normalizing a dimension for multiple fields in a straight table

    Hello Qlikkers,I have a dataset like this-datasetNow, I want to create a straight table in Qlik Sense that will have Race, CinemaStratum, CinemaPSU as... Show More

    Hello Qlikkers,

    I have a dataset like this-datasetdataset

    Now, I want to create a straight table in Qlik Sense that will have Race, CinemaStratum, CinemaPSU as dimensions and sum(UtilityWt) as measure. I want the straight table to look like this-

    expectedexpected

    But I want all the CinemaStratum and CinemaPSU to be included for each of the races. Even if some of the cinemaStratum/cinemaPSU does not have utilityWt, I want to be inserted in that row for the measure i.e. I want to have 10 rows(total no. of PSUs) for each of the races. All I have is the table below which does not include the missing stratums/PSUs.

    currentcurrent 

    I am at my wits' end about how to proceed further. I have created an island table but with my little experience of data modeling I can't really connect it to the fact table and compare to include all the values. I don't even know if that's a feasible solution. I would appreciate any help or suggestions.I am really looking forward to hearing from all the experts here! I am attaching my dataset and application(please refer to sheet2) here for reference.

    Thank you.

    Show Less
  • forum

    New to Qlik Sense

    Calculate total working days based on selected sales representives

    Hello Everyone!I need to calculate the total working days of a group of sales reps.Everyone has the same calendar, but different starting dates (someo... Show More

    Hello Everyone!
    I need to calculate the total working days of a group of sales reps.
    Everyone has the same calendar, but different starting dates (someone started to work after the 1st of January).

    In order to calculate working days for a single person that I chose inside my filters, I simply use the following formula:
    NetWorkDays (FirstSortedValue({1<year = {'2020'}, rep_name=p(rep_name)>} distinct date, date), today())

    This works perfectly for a single rep because it counts since its first working day until today.
    My question is: How can I calculate the exact amount of days if I choose more than one rep?

    Using:
    NetWorkDays (FirstSortedValue({1<year = {'2020'}, rep_name=p(rep_name)>} distinct date, date), today()) * (Count(distinct rep_name))
    is wrong because the formula picks the rep with maximum number of days and multiplies them for the number of reps that I choose.
    E.G. REP 1 = 30 days; REP 2 = 100 days
    this formula returns 200 days instead of 130.

    Can anyone help me?
    Thanks a lot in advance

    All the best!

    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