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.

Qlik NPrinting 

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.

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?