Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,381 online
Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

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

QlikWorld

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

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.

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.

Qlik Resources

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

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    Qlik NPrinting Discussions

    NPrinting currency formatting pixelperfect

    Hi all,i'm creating a pixelperfect report .I can't format correctly numbers and the preview is different from the settings i gave.this is my  Sense ta... Show More

    Hi all,

    i'm creating a pixelperfect report .

    I can't format correctly numbers and the preview is different from the settings i gave.

    this is my  Sense table: 

    c_pannese_0-1618326834128.png

    and this is my Nprinting setting:

    c_pannese_1-1618326884013.png

     

    the preview gives me back 

    c_pannese_2-1618326985895.png

     

    i need the format € #.##0,00 

    any helps?

    thanks all.

    Qlik NPrinting 

    Show Less
  • forum

    App Development

    getfieldselections () returns the SEARCH of a Listbox instead of the resulting ...

    If you do a search in a listbox  e.g. 1* which returns all values that start with '1' ,getfieldselections(FIELD , ','  , 20000)will return '1*' and no... Show More

    If you do a search in a listbox  e.g. 1* which returns all values that start with '1' ,

    getfieldselections(FIELD , ','  , 20000)

    will return '1*' and not the selected values of FIELD, even if the selection is below the parameter 20000. 

    If you do the same selection via a visualization object like a barchart with the dimension

    aggr(left(FIELD,1),FIELD)

    and the measure

    count(distinct FIELD)

    , getfieldselections will returs a proper comma separated list.

     

    How can we see the selection as a list, if the selection is made via a placeholder search?

     

    Show Less
  • forum

    New to Qlik Sense

    Date filter in expression of Histogram

    I have a Histogram (frequency distribution) for some weights, on my dashboard I have 3 different graphs, each with a unique set of data so a standard ... Show More

    I have a Histogram (frequency distribution) for some weights, on my dashboard I have 3 different graphs, each with a unique set of data so a standard filter won't help as I have data for X on week 1 but not for Y on week 1.  

    So I am trying to use an if statement to generate the correct filter. 

         =if([XYZ] = 'ABC', [Weight (kg)]) 

    ^ The above works correctly, so I now need to have an additional if for the week number being 13, not sure if Qlik is like Excel whereby if changes to ifs?

    The below is a 'set expression' from the current filter so I imagine that is what I need to try fit into the above expression.

    = if({Date] = <"=Dual('W'&Num(Week([Date]),00),Num(Week([Date]),00))"={'W13'}>, [Weight (kg)]

    extra credit: Is it possible to add a bit of intelligence into the expression so I don't have to manually change 'W13' as new data comes in? I imagine by using a max function?

    Any help would be appreciated.

     

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense SaaS - Map Background Image not displaying

    Hi - we are evaluating Qlik as an embeddable analytics solution. Trying to configure the Map chart to display a background image from a URL, as a back... Show More

    Hi - we are evaluating Qlik as an embeddable analytics solution. Trying to configure the Map chart to display a background image from a URL, as a background to some point data - but despite trying all sorts of different configurations, it doesn't  seem to work. A summary of what we have configured in the Map chart object:

    - A point layer that is using latitude and longitude from our dataset as location, lat and long is in the range of (51.51xxxxx, -0.08xxxxx) to (51.52xxxxx, -0.09xxxxx) [I've anonymised these values for the purpose of the question]

    - Map settings / base map is set to 'None', and projection is set to 'User defined (degrees)' (also tried Mercator, but doesn't seem to make any difference). Note that choosing the default map instead of 'None" renders the data in exactly the right positions on the map, so we know our lats and longs are correct.

    - A background layer who's format is "Image", the URL is correct (opening in the URL in another tab works fine and I believe that the background image is fetched by the browser, not by the server). The image position Top Left Corner and Bottom Right Corner are using latitude and longitude values (Top Left is (51.51xxxxx, -0.08xxxxx), Bottom Right is (51.52xxxxx, -0.09xxxxx)) so the image co-ordinates and our data co-ordinates are using the same model.

    I've also tried swapping the image URL to the one that is used in a related tutorial (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Resources/Images/ui_map-image-background-example.png) but this also does not make any difference.

    Is there anything obvious I'm missing?

    Also as an aside, could you clarify if background images (once this is working) are automatically scaled and rotated based on the Top Left / Bottom Right positioning values?

     

    Many thanks

    Paul

    Show Less
  • forum

    QlikView App Dev

    Formatting of a TimeStamp Field in Qlik going weird

    I am reading from a Teradata db.I have two fields called Sys_Strt_Tms and Sys_End_Tms - both are defined on the db as  Timestamp (6) fields.In the Sql... Show More

    I am reading from a Teradata db.

    I have two fields called Sys_Strt_Tms and Sys_End_Tms - both are defined on the db as  Timestamp (6) fields.

    In the Sql part of my script I am reading the fields like this:

    TO_CHAR(Sys_Strt_Tms, 'YYYYMMDD HH24:MI:SS') as Sys_Strt_Tms - returns e.g. 20210412 23:25:28 - which is correct

    TO_CHAR(Sys_End_Tms, 'YYYYMMDD HH24:MI:SS') as Sys_End_Tms - also usually populates with a value that is right...EXCEPT when the SQL value of that field is = 9999/12/31 23:59:59 (which is a default value if nothing is populated) . Then it returns, in Qlik  10000/01/01/ 00:00:00 (Directly from sql, its fine - 99991231 23:59:59.  I am guessing its because of some overflow and that I'd need to use something like 'Floor'.

    In my Qlik Script, I have tried to format those fields as timestamp (using Timestamp#(Sys_End_Tms ,'YYYYMMDD hh:mm:ss') and then it returns , for the Sys_Strt_Tms - 44298,976023...., and for the Sys_End_Tms it returns 2958466..

    In conclusion, it looks like the Teradata Engine returns the field for  Sys_Strt_Tms , but for Sys_End_Tms, after Qlik reads it, there is an error with the default value.

    I am sure it has to do with the "overflow" on that field, for value 9999/12/31 23:59:59, but I don't know how to format it correctly.

    (Afterthought - I need to subtract these 2 fields from each other at a later stage to get a time diff, so I assume they need to be timestamp fields to be able to achieve that?

    Much appreciated.

     

    Here is a summary of what happens:

    Load
       Timestamp#(Sys_Strt_Tms, 'YYYYMMDD hh:mm:ss') as Sys_Strt_Tms_1 , returns 44298,976023495
       Timestamp#(Sys_End_Tms, 'YYYYMMDD hh:mm:ss') as Sys_End_Tms_1, returns 2958466
       Sys_Strt_Tms, returns 2021/04/12 23:25:28
       Sys_End_Tms; returns 10000/01/01 00:00:00 when the field = default value of 9999/12/31 etc
    Select
       TO_CHAR(EV.Sys_Strt_Tms, 'YYYYMMDD HH24:MI:SS') as Sys_Strt_Tms,
       TO_CHAR(EV.Sys_End_Tms,'YYYYMMDD HH24:MI:SS') as Sys_End_Tms

    from
    Table...

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    if statement with Hexa colors

    I'm looking for solution to get custom bar colors using expression if and hexa colors.StatusColorReceived2d7fefFirst Touch8d46adIn Progresse05631On Ho... Show More

    I'm looking for solution to get custom bar colors using expression if and hexa colors.

    StatusColor
    Received2d7fef
    First Touch8d46ad
    In Progresse05631
    On Hold732477
    Finished41a64f

     

    Thanks in advance for any tip.

     

    Show Less
  • forum

    New to Qlik Sense

    Script Optimization using without where condition

    Hi Folks, I want to know the alternative and best optimized  functions instead of where condition in the backend script of qliksense.
  • forum

    Integration, Extension & APIs

    The website is not secure - Web Certificate

    I need to install a new web certificate for qliksense (June 2020) as upon access we receive the message 'The website is not secure': where can I retri... Show More

    I need to install a new web certificate for qliksense (June 2020) as upon access we receive the message 'The website is not secure': where can I retrieve it?

    Regards,

    Manuela

    Show Less
  • forum

    Qlik NPrinting Discussions

    migration Nprinting september 2019 vers November 2020

    Bonjour, Lors d'une migration Nprinting september 2019 vers November 2020 j'ai eu l'erreur suivante :Error 0x80070643: Failed to install MSI package(C... Show More

    Bonjour,

     

    Lors d'une migration Nprinting september 2019 vers November 2020 j'ai eu l'erreur suivante :

    Error 0x80070643: Failed to install MSI package

    (Cf. https://support.qlik.com/articles/000078516)

     

    L'installation fonctionne correctement a désinstallant complétement l'ancienne version puis en réinstallant le server Nprinting.

    J'ai ensuite restauré (via Qlik.Nprinting.Manager.exe) le backup NPrinting (September 2019) réalisé initialement avec succès.

    Cependant, après restauration, le service QlikNPrintingWebEngine ne démarre plus et j'ai une erreur de format de la BDD Postgres relative au mode de licence signée.

    Pour information j'ai le même problème si je valide ou non la licence avant restauration.

    Avez-vous une idée?

    Est-il possible de débloquer ce problème de démarrage du service?

    Sinon puis-je restaurer le référentiel Nprinting sans écraser complétement la base?

    Show Less
  • forum

    App Development

    QVD Generation based on Username who is generating it

    Hi Team,My requirement is to generate a QVD with Username appended to it whenever that particular user generates it. For instance if i am generating a... Show More

    Hi Team,

    My requirement is to generate a QVD with Username appended to it whenever that particular user generates it. For instance if i am generating a QVD , it should be QVD_Vish123 , and if other user generates it should be QVD_Otherusername. Is it possible in Qlik Sense. Please suggest.

    Show Less

Get Started On Community

Start Here Get Started On Community

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

Online Conference

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

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