Qlik Community

Welcome to Qlik Community

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

    Using a variable input field value to return the corresponding value of another ...

    HI!I've searched the forums to solve this question, but cannot seem to get it working. Your help is much appreciated!I have two fields with the follow... Show More

    HI!

    I've searched the forums to solve this question, but cannot seem to get it working. Your help is much appreciated!

    I have two fields with the following values:

    CodeCode Name
    1Car
    2Bus
    3

    Plane

     

    I would like to use an input field value to designate the code. In this case, the variable is called "vCode". I would like to return the corresponding field value for what matches the "vCode" input field box.

    Input Field Value: "vCode"= 2

    Result:  Text Box: Bus

    This would be similar to a vlookup in excel.

    Thanks in advance!

    Zach

    Show Less
  • forum

    New to Qlik Sense

    Creating dimension to choose distance radius

    Hi hoping for some help on this.I have latitude and longitude coordinates to all Family Doctors Practices in our database.   I have calculated the dis... Show More

    Hi hoping for some help on this.

    I have latitude and longitude coordinates to all Family Doctors Practices in our database.   I have calculated the distances from our central point (hospital) to each of these practices.

    How can I create a dimension so that I can 'bucket' the practices together based on distance (ie. all practices within 5km radius, 10km radius etc)

    Right now... the code below ... obviously just assigns 1 value to each practice so when I choose 5km from my filter it will show me all practices within 5km.  But if I choose 10km in my filter it won't show me those within 5km also.

    Wondering if there is a way I write this in my script so that if I choose 10km on its own it will show me all practices within 0 to 10km etc.

    Hope I'm explaining myself well.

    Thanks 

    Ciara 

    If(Distance>=0 and Distance<5.1
        , 
        	'5km'
        , 
        	If(Distance>=0 and Distance<10.1
            , 
            	'10km'
            ,
            	If(Distance>=0 and Distance<20.1
                , 
                	'20km'
                ,
                	If(Distance>=0 and Distance<50.1
                    , 
                    	'50km'
                    ,
                    	'Other'
                    )
               	)
            )
        ) 	as DistanceRadius

     

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Error in postgres as deploying multiple nodes.

    Hello guys, I recently implemented a qlik sense cluster, using a Master Node and two Slaves. However I am getting the following error in postgres.ERRO... Show More

    Hello guys, I recently implemented a qlik sense cluster, using a Master Node and two Slaves. However I am getting the following error in postgres.

    ERROR: duplicate key value violates unique constraint "ix_sensemq_target_topic_messageid"
    DETAIL: Key (target, topic, messageid)=(AppDistributionService, app.update, 9ab82626-a136-48e0-85ff-8687d56d9c0a) already exists.
    STATEMENT:
    INSERT INTO sensemq (id, messageid, messagetype, createddate, expirydate, source, target, topic, data)
    VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)

     

    For the implementation of the Master Node, the backup was performed followed by the restore of the old server.

    Show Less
  • forum

    New to Qlik Sense

    Comparar Meses

    Podem me ajudar a comparar o mês maior com o menor?A equação não está dando certo.Sum ({$ <[Dat_Faturamento.Calendario.Mês] = { $ ( = Min ([Dat_Fatura... Show More

    Podem me ajudar a comparar o mês maior com o menor?

    A equação não está dando certo.

    Sum ({$ <[Dat_Faturamento.Calendario.Mês] = { $ ( = Min ([Dat_Faturamento.Calendario.Mês]))}>} [Val_Faturamento])

    Show Less
  • forum

    Qlik Sense SaaS & Multi-Cloud

    Avoiding duplication of users between QSE Client Managed and SaaS

    We have a licence that includes both Client Managed and Saas (but not multi-cloud).We have configured both environments to use the same Identity Provi... Show More

    We have a licence that includes both Client Managed and Saas (but not multi-cloud).

    We have configured both environments to use the same Identity Provider (Azure AD) - following some helpful guides on the topic.

    We want our users to be able to access either environment but of course only want them to use up one licence.

    In the initial setup from Azure AD the SaaS version uses "sub" as the identifier which is a GUID from Azure AD as far as I can tell - whereas Client Managed uses the email address.

    So I changed the SaaS version to use email address as the "sub" to try and get them to line up.

    However when you look in SaaS the licence allocation shows User IDs in the format DIRECTORY\user.name@domain.com for all Client Managed allocations but just user.name@domain.com for all SaaS allocations meaning they're still duplicated.

    When you look in Client Managed the SaaS licence allocations (and users) show with Directory of UNKNOWN.

    I tried changing the directory name to UNKNOWN (in both User Directory Connector - which had to be changed to Generic LDAP - and Virtual Proxy) but this doesn't remove the duplication.

    I tried setting a blank directory in the Virtual Proxy (or just []) but this isn't allowed - it won't save.

    I looked at adding the on-prem version of the user ID (DOMAIN\user.name) to the Azure AD claims for SaaS but it's not an option in the Token configuration for a user - although weirdly it's a simple click for groups (link). I could look at extensions for Azure AD to get that detail to come through (see here) but that seems like overkill. 

    Am I crazy or is this a pretty fundamental issue with synchronising users & licences across environments? Am I missing something? Is it because Azure AD isn't fully supported in SaaS yet? Does it work with other providers? 

    Show Less
  • forum

    New to QlikView

    Making two Applymap function in one syntax

    Hey guys I  hopefully you can help me:  I Need the AZK 100% Field as a double applymatch syntax not as a Peek(). Monat=Month  VorMonat =One Month befo... Show More

    Hey guys I  hopefully you can help me:

     

     I Need the AZK 100% Field as a double applymatch syntax not as a Peek().

     

    Monat=Month  VorMonat =One Month before2020-10-29 17_56_40-QlikView x64 - [F__impex_QlikView_00_ZentralsteuerungQlikView_ - __Remote.png 

    Stammdaten:
    LOAD * INLINE [
        KEY, Monat, Name, PersonalNR, AZK
        Mark_Bremen_Willhelm_karmann_2020_01, 1, Mark, 1, 40
        Mark_Bremen_Willhelm_karmann_2020_02, 2, Mark, 1, 40
        Mark_Bremen_Willhelm_karmann_2020_03, 3, Mark, 1, 42
        Mark_Bremen_Willhelm_karmann_2020_04, 4, Mark, 1, 36
        Mark_Bremen_Willhelm_karmann_2020_05, 5, Mark, 1, 35
        Paul_Bremen_Willhelm_karmann_2020_01, 1, Paul, 2, 40
        Paul_Bremen_Willhelm_karmann_2020_02, 2, Paul, 2, 36
        Paul_Bremen_Willhelm_karmann_2020_03, 3, Paul, 2, 35
        Paul_Bremen_Willhelm_karmann_2020_04, 4, Paul, 2, 45
        Paul_Bremen_Willhelm_karmann_2020_05, 5, Paul, 2, 20
        Karin_Bremen_Willhelm_karmann_2020_01, 1, Karin, 3, 40
        Karin_Bremen_Willhelm_karmann_2020_02, 2, Karin, 3, 45
        Karin_Bremen_Willhelm_karmann_2020_03, 3, Karin, 3, 42
        Karin_Bremen_Willhelm_karmann_2020_04, 4, Karin, 3, 43
        Karin_Bremen_Willhelm_karmann_2020_05, 5, Karin, 3, 38
    ];
     
    [Map_Vormonat_primary]:
    Mapping
            load
            Key &'|'& Monat,
            Key &'|'& (Monat-1)
            Resident Stammdaten
            ;  
    [Map_AktuellerMonat_AZK100]:
      mapping
            load
           Key &'|'& Monat,
            AZK
    Resident Stammdaten
            ;
     
            NoConcatenate
            temp_MA_Infos:
            load
            *,
            applymap('Map_AktuellerMonat_AZK100',applymap('Map_Vormonat_primary',Key &'|'& Monat,0),0) as [AZK 100 % Vormonat]
            resident Stammdaten
            ;
     
            drop table Stammdaten;
            rename table temp_MA_Infos to Stammdanten;
     
    It wont Work.
     
    can you guys help met out.
    Show Less
  • forum

    New to Qlik Sense

    QLIK Sense - How to export data for multiple tables in a single excel (.csv or ....

    Hello,Is it possible to export the data of multiple tables in a single excel (.CSV or .xls)  file instead of individually in  #QLIK SenseI see we can ... Show More

    Hello,

    Is it possible to export the data of multiple tables in a single excel (.CSV or .xls)  file instead of individually in  #QLIK Sense

    I see we can export the whole page in PDF though but I am sure QLIK Sense supports the exporting of data from page to excel.

     

    Regards,

    Preet

    Show Less
  • forum

    Community Corner

    Qlikview Tasks Failing

    Hi All,Some of QV tasks are failing randomly and quiet often.Here is the log:(2020-10-29 07:29:11) Information: Starting task 'Model - Sales Performan... Show More

    Hi All,

    Some of QV tasks are failing randomly and quiet often.

    Here is the log:

    (2020-10-29 07:29:11) Information: Starting task 'Model - Sales Performance'. Id:98109b58-9287-4bc4-948c-f4bfdebe2235. Triggered by 'TaskCompletedTrigger'. Id:fba561f6-48f7-40dc-a2db-3c15f9192762

    (2020-10-29 07:29:11) Information: Entering Task Execution.

    (2020-10-29 07:29:11) Information: ClusterID=1

    (2020-10-29 07:29:11) Information: QDSID=eae38e02-59ab-3305-a2d1-51c8b362403a

    (2020-10-29 07:29:11) Information: TaskID=98109b58-9287-4bc4-948c-f4bfdebe2235

    (2020-10-29 07:29:11) Information: MaxRunTime=1.00:00:00

    (2020-10-29 07:29:11) Information: MachineName=YQVS01

    (2020-10-29 07:29:11) Information: Max attempts:1

    (2020-10-29 07:29:11) Information: Current Attempt=0

    (2020-10-29 07:29:11) Information: Task Dependencies are OK

    (2020-10-29 07:29:11) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

    (2020-10-29 07:29:11) Information: Opening "\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw"

    (2020-10-29 07:29:11) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

    (2020-10-29 07:29:11) Information: Max retries:5

    (2020-10-29 07:29:11) Information: Attempt:01

    (2020-10-29 07:29:12) Information: Opened the QlikView Engine successfully. ProcessID=4188

    (2020-10-29 07:29:12) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=512.

    (2020-10-29 07:29:12) Information: Loading document "\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw" (299.10 Mb)

    (2020-10-29 07:29:13) Information: Loading. LoadTime=00:00:01.0000718

    (2020-10-29 07:29:15) Information: Loading. LoadTime=00:00:03.0001938

    (2020-10-29 07:29:19) Information: Loading. LoadTime=00:00:07.0076113

    (2020-10-29 07:29:27) Information: Loading. LoadTime=00:00:15.0127984

    (2020-10-29 07:29:43) Information: Loading. LoadTime=00:00:31.0255813

    (2020-10-29 07:30:05) Information: Physical FileSize=299.10 Mb. Memory Allocation Delta for this file=89.85 Mb. Available Physical Memory Before Open=167278.67 Mb. Available Physical Memory After Open=167207.62 Mb. Total Physical Memory=196573.38 Mb.

    (2020-10-29 07:30:05) Information: Attempted to load the document without data.

    (2020-10-29 07:30:05) Information: The document was loaded successfully.

    (2020-10-29 07:30:05) Information: Document was opened successfully

    (2020-10-29 07:30:05) Information: Starting reload

    (2020-10-29 07:30:05) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

    (2020-10-29 07:30:05) Information: Waiting for the document log "\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw" to become available.. Check until 10/29/2020 7:30:35 AM

    (2020-10-29 07:30:05) Information: The Source Document is being reloaded. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw

    (2020-10-29 07:30:05) Information: Found a document log. FileName=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw.log

    (2020-10-29 07:30:05) Information: Writing documentLog to \\YQASE02\QVLogs\QDS Application Data Folder\1\Log\20201029\072911 - Model - Sales Performance\DocumentLog.txt

    (2020-10-29 07:30:06) Information: Reloading.

    (2020-10-29 07:30:07) Information: Reloading..

    (2020-10-29 07:30:08) Information: Reloading...

    (2020-10-29 07:30:09) Information: Reloading....

    (2020-10-29 07:30:10) Information: Reloading.....

    (2020-10-29 07:30:11) Information: Reloading......

    (2020-10-29 07:30:12) Information: Reloading.......

    (2020-10-29 07:30:13) Information: Reloading........

    (2020-10-29 07:30:14) Information: Reloading.........

    (2020-10-29 07:30:15) Information: Reloading..........

    (2020-10-29 07:30:16) Information: Slow down logging. Log every <2> seconds.

    (2020-10-29 07:30:16) Information: Reloading

    (2020-10-29 07:30:18) Information: Reloading.

    (2020-10-29 07:30:20) Information: Reloading..

    (2020-10-29 07:30:22) Information: Reloading...

    (2020-10-29 07:30:24) Information: Reloading....

    (2020-10-29 07:30:26) Information: Reloading.....

    (2020-10-29 07:30:28) Information: Reloading......

    (2020-10-29 07:30:30) Information: Reloading.......

    (2020-10-29 07:30:32) Information: Reloading........

    (2020-10-29 07:30:34) Information: Reloading.........

    (2020-10-29 07:30:36) Information: Reloading..........

    (2020-10-29 07:30:38) Information: Slow down logging. Log every <10> seconds.

    (2020-10-29 07:30:38) Information: Reloading

    (2020-10-29 07:30:48) Information: Reloading.

    (2020-10-29 07:30:58) Information: Reloading..

    (2020-10-29 07:31:08) Information: Reloading...

    (2020-10-29 07:31:18) Information: Reloading....

    (2020-10-29 07:31:28) Information: Reloading.....

    (2020-10-29 07:31:38) Information: Reloading......

    (2020-10-29 07:31:48) Information: Reloading.......

    (2020-10-29 07:31:58) Information: Reloading........

    (2020-10-29 07:32:08) Information: Reloading.........

    (2020-10-29 07:32:18) Information: Reloading..........

    (2020-10-29 07:32:28) Information: Slow down logging. Log every <60> seconds.

    (2020-10-29 07:32:28) Information: Reloading

    (2020-10-29 07:33:28) Information: Reloading.

    (2020-10-29 07:34:28) Information: Reloading..

    (2020-10-29 07:35:28) Information: Reloading...

    (2020-10-29 07:36:28) Information: Reloading....

    (2020-10-29 07:37:28) Information: Reloading.....

    (2020-10-29 07:38:28) Information: Reloading......

    (2020-10-29 07:39:28) Information: Reloading.......

    (2020-10-29 07:40:28) Information: Reloading........

    (2020-10-29 07:41:28) Information: Reloading.........

    (2020-10-29 07:42:28) Information: Reloading..........

    (2020-10-29 07:43:28) Information: Slow down logging. Log every <300> seconds.

    (2020-10-29 07:43:28) Information: Reloading

    (2020-10-29 07:45:43) Information: The Source Document reload complete. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw

    (2020-10-29 07:45:43) Information: Memory Allocation Delta for this file=2941.66 Mb. Available Physical Memory Before Reload=167207.77 Mb. Available Physical Memory After Reload=163233.01 Mb. Total Physical Memory=163233.01 Mb.

    (2020-10-29 07:45:44) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw.

    (2020-10-29 07:45:44) Information: Closing the document.

    (2020-10-29 07:45:45) Information: Closed the QlikView Engine successfully. ProcessID=4188

    (2020-10-29 07:45:49) Error: The task "Model - Sales Performance" failed. Exception:

    (2020-10-29 07:45:49) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw.

    (2020-10-29 07:45:49) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

    (2020-10-29 07:45:49) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

    (2020-10-29 07:45:49) Error: --- End of inner exception stack trace ---

    (2020-10-29 07:45:49) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

    (2020-10-29 07:45:49) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

    (2020-10-29 07:45:49) Error: --- End of inner exception stack trace ---

    (2020-10-29 07:45:49) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

    (2020-10-29 07:45:49) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

    (2020-10-29 07:45:50) Information: Task Execute Duration=00:16:38.9054470

    (2020-10-29 07:45:50) Information: Sending Alert mail

    (2020-10-29 07:45:50) Warning: No mailaddress found. Recipient=Vidyarani.Hingamire@atoz.com
    (2020-10-29 07:45:50) Warning: Dillon.soni@atoz.com

    (2020-10-29 07:45:50) Information: TaskResult.status=Finished

    (2020-10-29 07:45:54) Information: Notifying all triggers of new state:FinishedWithErrors

    (2020-10-29 07:45:54) Information: Notifying all triggers of new state:FinishedWithErrors - completed

    (2020-10-29 07:45:58) Information: Saving Task Result

     

    Please can anyone help me on this asap.

    Any leads will be greatly appreciated.

     

    Thanks and Regards,

    Vidyarani

    Show Less
  • forum

    QlikView Deployment

    Scroll Bar on left side of straight table

    Is the topic above even possible?moving the scroll bar from the right side of the table to the left?
  • forum

    Qlik Sense Integration, Extensions, & APIs

    "Ticket retrieval failed" when trying to access Qlik Sense through .NET SDK

    Hello, I am trying to connect my web API to our Qlik Sense server using the .NET SDK. I am connecting with AsNtlmUserViaProxy() and passing in the use... Show More

    Hello, I am trying to connect my web API to our Qlik Sense server using the .NET SDK. I am connecting with AsNtlmUserViaProxy() and passing in the username and password for the service account that installed Qlik Sense on the machine. I am using the code below to connect to Qlik Sense: 

     

    ILocation location = Location.FromUri("https://myqliksensesite.com");
    
    await location.AsNtlmUserViaProxyAsync(proxyUsesSsl: true, loginCredentials: new NetworkCredential(
        "username",
        "password",
        "domain"
    ));
    
    using(var hub = await location.HubAsync())
    {
        var engineVersion = await hub.EngineVersionAsync();
        Console.WriteLine($"Engine Version: {engineVersion.ComponentVersion}");
    };

     

    This works when I try running my web API on my laptop through Visual Studio. It connects to my Qlik Sense server, gets the engine version, and prints it out. However, whenever I try running it on our QA server, it fails with the following error:

     

       AggregateException
       One or more errors occurred. (Ticket retrieval failed.) (Ticket retrieval failed.) (Ticket retrieval failed.) (Ticket retrieval failed.)
       at Qlik.Sense.JsonRpc.RpcConnection.RepeatAttempt(Int32 maxAttempts, Func`2 f, CancellationToken token)
       at Qlik.Sense.JsonRpc.RpcConnection.OpenAsync(CancellationToken token)
       at Qlik.Sense.JsonRpc.RpcConnection.EnsureConnectionIsOpen()
       at Qlik.Sense.JsonRpc.RpcConnection.SendAsync(Request request, TaskCompletionSource`1 tcs)
       at Qlik.Engine.Communication.QlikConnection.PingAsync()
       at Qlik.Engine.LocationExtensions.DisposeOnErrorAsync(IDisposable o, Func`1 f)
       at Qlik.Engine.LocationExtensions.HubAsync(ILocation location, ISession session)

     

    Just a little extra information: our QA server is currently running in a Docker container on a Linux server that is running on the same network as our Qlik Sense server. I have whitelisted the IP address of the Linux server in the QMC.

    What I'm trying to figure out is what this "Ticket retrieval failed" error means. Does it mean that I am not establishing any connection at all with Qlik Sense, or does it mean that Qlik Sense is rejecting my credentials. If the latter is the case, then why is it working when I run it from my laptop and not on our QA deployment?

    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