Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
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:
and this is my Nprinting setting:
the preview gives me back
i need the format € #.##0,00
any helps?
thanks all.
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?
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.
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
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...
I'm looking for solution to get custom bar colors using expression if and hexa colors.
Status | Color |
Received | 2d7fef |
First Touch | 8d46ad |
In Progress | e05631 |
On Hold | 732477 |
Finished | 41a64f |
Thanks in advance for any tip.
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
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?
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.
MVP
22801MVP
8656Employee
8652MVP
8200MVP & Luminary
7991Employee
6509MVP & Luminary
5369MVP
5178MVP & Luminary
4408Employee
4113Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
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.
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!’
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.