Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
4,040 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

Data Analytics

Forums for Qlik Data Analytics 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 Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

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.

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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    QlikView App Dev

    Create iterative numbers

      Hello,I am trying to achieve Field2;Field1  Field21            12            13            11            22            23            21           32... Show More
     
     

    Hello,

    I am trying to achieve Field2;

    Field1  Field2

    1            1

    2            1

    3            1

    1            2

    2            2

    3            2

    1           3

    2           3

    3           3

    I tried peek function as well as loops but I couldn't success. I am trying to create page numbers for NPrinting PowerPoint so the tables will fit accordingly.

    Thank you!

    Show Less
  • forum

    Qlik NPrinting Discussions

    Qlikview User name in Footer

    Hi Team,                I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. Tasks : Need to show QVuser name in NPrintin... Show More

    Hi Team, 

                   I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. 

    Tasks : Need to show QVuser name in NPrinting. 

    Please refer below my Steps(but i am not getting what i am expected)

    1. Created One variable in Qlikview (vPrepared By = 'Prepared By: ' & Subfield(OSUser(),'\',2) 

    2. Value is showing as Prepared By: Sakthivel. Selvaraja 

    3. Taking this variable in Nprinting Variable. 

    4. If I Use this variable in Qlik Nprinting it is showing as NPAdmin(which is Nprinting Admin User)

    5. But what my expectation is shown as the same above which is Prepared By: Sakthivel.Selvaraja. 

     

    Will anyone help me to resolve this . It is very urgent

     

    Thanks and Regards, 

    Sakthivel.S

    Show Less
  • forum

    QlikView Connectivity

    New User Login - perform a RELOAD

    Hello,Our IT department created a new user definition "QlikView". However, the following pop-up appears when the user tries to log in. We ask for your... Show More

    Hello,


    Our IT department created a new user definition "QlikView". However, the following pop-up appears when the user tries to log in. We ask for your support on how we can fix this problem.

    "This field is recognized as one your own. However, we must update the key in the document to reflect the change to your personal edition since you created this document.

    The document will now be updated and loaded without any data. After the operation completes, please SAVE the document and then perform a RELOAD."

    Atalay_0-1632144788407.png

     

    Also in the logs file that we are able to see the following fatal details.

    P.s. I have been masked paths and log names in the following details(*)

    Select Log: 2021-09-13 16:22:422021-09-13 16:21:292021-09-13 16:10:272021-09-13 16:07:282021-09-13 16:03:522021-09-13 08:30:002021-09-09 09:23:482021-09-08 17:55:362021-09-08 17:56:492021-09-08 17:55:412021-09-08 17:54:542021-09-08 17:54:452021-09-08 17:36:592021-09-08 171407.12021-09-08 17:14:072021-09-08 16:59:512021-09-08 16:59:362021-09-08 16:58:312021-09-06 08:30:002021-08-30 08:30:002021-08-23 08:30:002021-08-16 08:30:00

    (2021-09-13 16:22:42) Information: Starting task '***.qvw'. Id:d514400d-1bbb-4143-a1a3-5ec39d52fa20. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c(2021-09-13 16:22:42) Information: Entering Task Execution. (2021-09-13 16:22:42) Information: ClusterID=1(2021-09-13 16:22:42) Information: QDSID=8a9a3be2-de21-f066-4e72-98863cda71f6(2021-09-13 16:22:42) Information: TaskID=d514400d-1bbb-4143-a1a3-5ec39d52fa20(2021-09-13 16:22:42) Information: MaxRunTime=06:00:00(2021-09-13 16:22:42) Information: MachineName=****(2021-09-13 16:22:42) Information: Max attempts:1(2021-09-13 16:22:42) Information: Current Attempt=0(2021-09-13 16:22:42) Information: Task Dependencies are OK(2021-09-13 16:22:42)
    Error: The task "********.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.SourceDocumentNotFoundException: Could not find SourceDocument (Distribution): qvp://****/****/****/****.qvw || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)(2021-09-13 16:22:42) Information: Task Execute Duration=00:00:00.0312431(2021-09-13 16:22:42) Information: TaskResult.status=Finished(2021-09-13 16:22:42) Information: Notifying all triggers of new state:FinishedWithErrors(2021-09-13 16:22:42) Information: Notifying all triggers of new state:FinishedWithErrors - completed(2021-09-13 16:22:42) Information: Saving Task Result

     

     

    QlikView version is 11.20.140004.0 SR21

    Show Less
  • forum

    App Development

    Filters valued but not chosen

    If I do certain filters (for example if I choose my DES_REFERENT field) I notice that in the object where the list of filters is displayed I learn a f... Show More

    If I do certain filters (for example if I choose my DES_REFERENT field) I notice that in the object where the list of filters is displayed I learn a filter that I have never put, and I would not want it, on what does this behavior depend?

    For example:

    danosoft_0-1631800210703.png

    it has been inserted autonomously and I would not want it, because if I change the filter in DES_REFERENTE this previous CD_FORNITORE limits me the view of the rows (which should not have selected it)

    Show Less
  • forum

    Integration, Extension & APIs

    selectMatch() for more than one value

    Does anyone have experience using the selectMatch() function for selecting more than one value in a Qlik Sense mashup?I want to select more that one y... Show More

    Does anyone have experience using the selectMatch() function for selecting more than one value in a Qlik Sense mashup?

    I want to select more that one year and I've tired these statements without any luck:

    app.field("[Year]").selectMatch("20102011", false);

    app.field("[Year]").selectMatch("2010 2011", false);

    app.field("[Year]").selectMatch("2010|2011", false);

    app.field("[Year]").selectMatch("2010,2011", false);

    Thanks in advance.

    /Thomas

    Show Less
  • forum

    Qlik NPrinting Discussions

    NPrinting exception error(Exception to HRESULT: 0x80048240)

    Good day I am using NPrinting Feb V21.0.0.0 with Qlik Sense 2020 Patch 2.When I create a NPrinting Power point report I get this error when I try and ... Show More

    Good day 

    I am using NPrinting Feb V21.0.0.0 with Qlik Sense 2020 Patch 2.

    When I create a NPrinting Power point report I get this error when I try and add a image in using Template editor: Exception to HRESULT: 0x80048240 (In screenshot below).

    Justinjdkdekock_0-1632314269719.png

     

    I am able to do this when creating reports in all other formats, but I cannot drag and drop the image into Excel or Word within template Editor.

    Your assistance will be highly appreciated.

     

     

    Kind regards,

    Justin 

    Show Less
  • forum

    New to Qlik Sense

    Qliksense Calendar Chart

    Hello Qlik Enthusiasts , I want to have a little calendar where i can choose a particular date for example, 02-04-2022 and then get all the records wh... Show More

    Hello Qlik Enthusiasts , 

    I want to have a little calendar where i can choose a particular date for example, 02-04-2022 and then get all the records which would be expired until this date. The date is as follows . 

    Student , Document, Expiration Date, Document Status 

    101, Doc1, 12-03-2021, Expired 

    102, Doc2 , 12-09-2022, Valid

    103, Doc3, 12-11-2021, Valid 

    104, Doc4, 31-12-2021, Valid

     

    for now i am calculating status if the expiry date is less than today then its expired. But i want to have a calendar where i can choose a particular date and get all the expired certifcates until that particular date. For example,if i select 31-12-2021 then i would like to get the following output . 

    Student , Document, Expiration Date, Document Status 

    101, Doc1, 12-03-2021, Expired 

    102, Doc2 , 12-09-2022, Valid

    103, Doc3, 12-11-2021, Expired

    104, Doc4, 31-12-2021, Expired

     

    Please help me solve this , Thank you for your valuable time in Advance. 

    Show Less
  • forum

    QlikView App Dev

    Dual function and how it goes underneath

    HelloCould someone please describe what happened in this dual expression?=Dual(Num(Sum(Quantity), '#,###.') & Chr(10) & Num(Sum(Quantity)/Sum(TOTAL <M... Show More

    Hello

    Could someone please describe what happened in this dual expression?

    =Dual(Num(Sum(Quantity), '#,###.') & Chr(10) & Num(Sum(Quantity)/Sum(TOTAL <Market> Quantity), '##.##%'), Sum(Quantity))

    As far as I know, Dual creates both text and numeric value out of single field/variable, and structure looks like DUAL(text, numeric), however in this expression there are three sections:

    (Num(Sum(Quantity), '#,###.') - I guess its going to be first value, integer stored as a text

    Num(Sum(Quantity)/Sum(TOTAL <Market> Quantity), '##.##%') - this is going to be second value, numeric, percentage

    Sum(Quantity)) - I am completely blunt with this one.  This refers to let Y axis be sum of quantity? Just a blind guess.. and without this, the expression has an error. How one could know, it is necessary, can you share knowledge behind this?

    Thank you in advance

    Show Less
  • forum

    App Development

    Color condition in qliksense table

    Hello Everyone,I am using below formulae in my calculation :-if(GetSelectedCount([User.Divison Name])>0,((Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Ma... Show More

    Hello Everyone,

    I am using below formulae in my calculation :-

    if(GetSelectedCount([User.Divison Name])>0,((Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

    /

    (only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8)) /count([Person Name])),

    if(
    GetSelectedCount([User.Department Name])>0,(Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

    /

    (only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8)),


    (Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

    /

    (only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8))/count(distinct [User.Department Name])


    )) // & '%'

     

    Aspiring_Developer_0-1632388551127.png

    Now inside the selection, i want to add colors on the basis of condition in %input completion column.

    If % input completion >=100, green(), red().

    I am unable to implement this condition inside this expression. The way to do it is add the color expression in background color option , however, i am unable to do it.

     

    Can anyone please help ?

    Thanks in advance

     

    Show Less
  • forum

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

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.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region