Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
In my table i am having two date
1.order date
2.Delivery date
but when i am using Canonical Date the count of delivery not coming correct as per my source
Hi,
I have a problem in the data model and KPIs.
The Facts table consists of several tables (concatenate), and there is a dimension table that contains flags.
I want to count the amount of values in a packet according to a certain flag and I don't get data.
How can I solve this?
Simple example
Fact:
SourceTable | num(Date) | StoreID | OrderID | ItemID | Qty | Amount | GoalAmount | Key |
Orders | 44444 | 001 | 1001 | a001 | 1 | 100 | - | 44444 | 001 |
Orders | 44444 | 001 | 1001 | b002 | 1 | 150 | - | 44444 | 001 |
Orders | 44444 | 001 | 1002 | a001 | 2 | 200 | - | 44444 | 001 |
Orders | 44444 | 002 | 2001 | c003 | 5 | 50 | - | 44444 | 002 |
Orders | 44444 | 002 | 2002 | a001 | 4 | 350 | - | 44444 | 002 |
Orders | 44444 | 001 | 1003 | b002 | 2 | 300 | - | 44444 | 001 |
Goals | 44444 | 001 | - | - | - | - | 700 | 44444 | 001 |
Goals | 44444 | 002 | - | - | - | - | 800 | 44444 | 002 |
Dim:
Key | flag1 | flag2 | flag3 |
44444 | 001 | 1 | 1 | 0 |
44444 | 002 | 0 | 1 | 1 |
44444 | 003 | 1 | 1 | 1 |
Sum({<flag1={1}>}Qty) = 6 --> I received 0.
Sum(Qty) when filtered on flag1=1 --> I received 0.
My final KPI should be like that:
Avg(Aggr(Sum({<flag1={1}>}Qty),Date))
Thanks!!
Hi everyone,
I'm currently working on retrieving user data related to the export of data, images, or PDFs in our Qlik Sense Cloud environment. I have set up a connection for auditing purposes as per the guidelines in the Qlik Developer Portal, but I am struggling to find the specific information regarding user exports.
Despite setting up the audit connection, I'm unable to locate or retrieve logs that detail when users export data, images, or PDF files.
Here’s what I have tried:
Could anyone provide guidance or share examples on how to properly query the Qlik Sense Audit API to capture these specific user activities? Any tips on the types of filters or API endpoints to use would be greatly appreciated.
Thank you in advance for your help!
Best Regards,
Nick
Hi everybody,
I have tried to sort the filter-values shown on the screenshot. Unfortunately they are sorted as Strings due to the concat-function i use for creating the "selections". Does anybody know how to sort the values correctly?
Hi,
I am working with Qlik Sense February 2024 Patch 1 (QSEoW) and I am wondering what makes the list of fonts which we can choose from when styling objects. The list opens up and presents various fonts but those are not all fonts this client has and uses. I would like to add my own font to that list so it is always present for users to choose from. Is there any documentation regarding custom font requirements and whether it is possible to add one to that list without creating custom theme?
I am going through documentation trying to find anything on that subject but so far I didn't see anything.
thanks
Lech
Hi there.
I have a problem and I can't seem to fix it in my load editor I want to import only the values of the latest row found for each Kenteken. So for instance a Kenteken xx-00-xx can be on row 12000 and the same one xx-00-xx can be on 14000. I only want to import the latest row with that particular kenteken and other fields in order to get rid off duplicates. I want it to be done in the load editor and not in the front-end.
Unfortunately I can't do anything with dates because they can be similar and there are too many variances.
This is the script:
For example, let say i create a routine that will pretty print JSON on log
package routines;
import org.apache.log4j.*;
import routines.system.JSONObject;
public class PrettyPrintJSON {
private static org.apache.log4j.Logger log = LogManager.getLogger(PrettyPrintJSON.class);
public static void print(String jsonPayload, String description) {
try {
JSONObject json = new JSONObject(jsonPayload); // Convert text to object
log.info(description + " JSON : \n" + json.toString(4));
} catch (Exception e) {
e.printStackTrace();
}
return;
}
}
So when I use this routine on Tjava or inside another routine that uses non JSON string
String json ="sorry I not JSON man!";
PrettyPrintJSON.print(json,"Wakanda create case payload");
Seem the job still keep continue running and exit with status 0.
I expecting it to stop or exits with status 1
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!