Qlik Sense

Hi Everyone,

I am trying to set the background color based on the IF statement. I'm not sure if I can combine multiple conditions within the IF statement or not? Because calculation works fine when I run it separately along with the indicator, it doesn't work while I combine it with the IF clause. Please see the calculation below, and help me with fixing it. I have set up the indicator as a variable.

if (Only({<Goal_Metric={'Computer'}>} [Goal]) > sysvalue >= Sum({< Plan_Quarter ={'$(=MaxString(Plan_Quarter))'},[Plan_Metric]={'Computer'}>} [Plan_Value]), '$(vC_LightIndicator)')

Note: sysvalue is also a calculated field.

I'm trying to calculate if goalvalue > sysvalue >= planvalue then show this background color

Any suggestion is greatly appreciated!

Hi, i have to do a store with  some days given by an Excel file. How do I have to have a variable equal to a day?                       I think so:   

load*inline [
month, day
sep, 24/09/2021
oct, 25/10/2021];

Let vtoday = date(today(), 'DD.MM.YYYY');
let vmonth=month(today());

if $(vtoday)= '24/09/2021' then

store [table] into 'lib://....._$(vmonth).csv' (txt,delimiter is ';');

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. 

I am working on Qlik SaaS and I am using custom colors for a Master Item Dimension with 75 values. Qlik lets you set 100 custom colors so it shouldn't be a problem. But we have changed some of the text of the values during the project and now when I go to edit a color it tells me I've hit the maximum of 100 custom colors. So there are 25 custom colors stored in the database but I can't access them to remove them and free up more for the current 75.

A higher limit than 100 seems like the easiest solution to this problem, but if not that then maybe it's possible to remove the stored custom colors that are no longer for a valid value in the field? If not that then continue to list the old values with custom colors at the bottom of the list of values in the field in the UI so that they can still be removed.

#MasterItems

I am trying to select to most recent record where Planned = 'N' (for the given combination of dimensions).

Here is my table:

I want the output to only show the following highlighted row:

Is there a way to achieve this using a chart expression?

Hi,

I have a requirement like this. How do I derive the new column?

Customer   Alert         NewColumn

A                     1                      1

A                     0                      0

A                     0                      0

A                     1                       1

A                     1                      2

A                     1                     3

Thanks

Hi All

I'm finding the pivot table sorting a little tricky and need some advice.

I have 2 dimension - Inventory and StockNumber

I have 3 measures - Vendor 1 Value on Hand, Vendor 2 Value on Hand, Variance (between V1 and V2)

I have no problem sorting the Inventory descending by the variance, but when I expand on an inventory, the I cant quite figure out how to sort descending on the variance here.

Can anyone help?

Much appreciated

Ciara                                            

Hi @Patric_Nordstrom 

I would like to know is it possible to count points (triangle shape) within the TravelArea?

I generated TravelArea on-the-fly hence it's dynamic according to address I selected (represent in circle shape). 

Then I would like to know, within the travelarea boundary generated, how many points lie inside it?

Thanks alot Patric!

Qlik GeoAnalytics  Qlik Sense Enterprise SaaS 

I have a map UI conundrum and would appreciate any thoughts. 

My customers love the "original position" home control of the Qlik Map chart.

Unfortunately  they don't like the Qlik Map tooltip which is sluggish (in our experience)  and displays the "+2 more" type message even when there is clearly only 1 layer area under the pointer.

They do really like though, the tooltip of the Qlik Geoanalytics map chart which is fast to re-render and much more configurable. 

Q1: Is there a way to replicate the "original position" function in the Qlik Geoanalytics map object ?

Q2: Is there a way to influence/customise the Qlik Map chart tooltip to not show "+3 more" ?

Thanks

Hi

We started to test upgrading from June 2020 p12 to August 2021 and the upgrade failed with error messages when the upgrade tries to CREATE TABLE sensemq

That ofc happen because the table exists.

After dropping the QSMQ database and creating an empty one following https://help.qlik.com/en-US/sense-admin/August2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-configuring-postgresql.htm

the upgrade was successful.

The question is if it's safe to do this when we upgrade our Production environment. Any comments on that?

Hi,

I am trying to protect the privacy of location data by performing random perturbation. I need to subtract two polygons from one another (one based on maximum distance of displacement and one based on minimum distance of displacement). What tools could I use to do this and produce a "donut polygon"?

Also is it possible to generate random points within the resulting donut polygon? 

Thanks

Hi,

I try to build a Qlik GeoMap with the countys from Germany.

I've a list with the names of the countys but Qlik does not recognize all of them automatically.

For example:

I've the city 'Aachen' but Qlik need 'Städteregion Aachen' as correct name to show this.

Or 'Leipzig' exists as 'Stadt Leipzig' and 'Landkreis Leipzig' in my list.

'Landkreis Leipzig' works fine but the item 'Stadt Leipzig' Qlik does not know and I need to use only the name 'Leipzig' without 'Stadt'.

Where can I find the official name base of countys for a mapping with my list?

Best regards

Hello community,

the addresses in China are all on matchlevel 0,75 altough I have a street and housenumber.

What is your idea how can I increase the matchlevel for China, Korea, etc…?

Thank you.

Best regards,

Patrick

Hi

I have a table loaded in the script with points data (Lat,Long) and a unique Id for each point and have separately loaded and merged together a number of KML files with polygons and IDs and loaded these as a separate table.

I can load these as separate points and Area layers within the map charts , no problem.  However I now want to use the Geooperations Within() operation to establish which polygon(s) the points fall within, but cant get it to work with two intables. 

Is this even possible and if so, can anyone provide the correct syntax for this?  I am using Qlik Sense SaaS / GeoOperations

Thanks in advance

Duncan

Can you change the map server location without Geo Analytics? I am attempting top route the base map to reference a map server but am not seeing where this could be done.

Hello,

I've created a pivot chart visualization of headcount where the row header is month dimension and the column header is year dimension.  I want to be able to select any combination of month-year to be able to get the names of employees at any point, by using the pivot as a filter slicer.  However, at the moment, I can only select a row at a time, and not a cell (of intersection of row and column).  How can I change the setting so that I can select a cell and not just a row in a pivot table?  

Thank you very much for your help.