Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I'm creating a script for export, import and publishing apps betweens tenants in Qlik Cloud using Qlik-CLI. As the first step I create a context using following line:
qlik context create test --server https://<TENANT NAME>.us.qlikcloud.com/ --api-key <API KEY>
After that I log into that context with qlik context use test . After that I use following line for export app from a shared space from test tenant
qlik app export <AppId> > <Pathfile>/AppName.qvf
It does export app with data
Furthermore we should use OAuth client for multitenant managing. So we create context using --oauth-client-id and --oauth-client-secret flags for creating context.
However, using the last context with this authentication it's exporting app with No Data.
What could be the issue?
Note: I followed this tutorial for creating OAuth client credentials
https://qlik.dev/manage/platform-operations/authenticate-platform-ops/#how-to-create-a-region-level-oauth-client
Thanks in advance.
Hey there,
I have a table in my app that contains a few dimensions and 3 measures.
The 3 measures are:
1. Current Period - Represents the amount of money I currently have (based on period selection)
2. Compared Period - Represents the amount of money I had in a selected period (also based on period selection, using a different variable than the one used in current period)
3. Difference - the calculation of money in my current period minus the money in the compared period
Also, I have a variable that gets a number that is used as a threshold for amounts of money (we'll call it $Threshhold).
I'm trying to filter rows from the table based on the next condition:
If the absolute value of the difference between the periods is greater than $Threshold, then keep the value of it in the table, otherwise filter it.
The problem is that I can't find a way to actually filter the values from the table, the become a null value instead.
I tried many IF conditions and also tried using the limitation option in one of the dimensions, but to no avail.
I would really appreciate if someone could help me with this.
(And sorry I cant ease it with real examples).
Thanks!
Hello,
I am using Qlik Cloud and leveraging a large dataset in BigQuery. I have setup up direct query successfully to start building analytics.
I am facing an issue with the Fractile function. I need to generate 99%, 99.9% quantiles and the direct query seems to only support basic aggregation functions.
I have tried to define a Fractile measure. Qlik is accepting the expression and then generating SQL with the Fractile function in BigQuery. BigQuery computes quantiles thanks to different functions but Fractile() is not one of them.
The trick is that Fractile cannot be preaggregated. It needs to run on the full dataset.
Is there a workaround I could apply?
Thanks
Hello everyone!!
I am a newbie and have little info aboutapp development. I wants to develop sim registration app. Can I do so on the behalf of my knowledge as a newbie. Or should I hire a freelance developer.
If yes then tell me the quielties of the developer that are suitable to hire
Hi Community,
We are using GCP Cloud bucket to access some of our QVS files using Must_Include but it is throwing an error as file not found.
QVS file is not supported from GCP Bucket?
I am able to load using normal file load.
I went through some of the community discussions like below
Solved: Using QVS in Qlik Sense SaaS - Qlik Community - 1724164 still it is not working for me with provided solutions.
Qlik Version :
When extracting data from a MySQL table to a QVD file, most timestamp values are saved as NULL.
It is a simple script:
LIB CONNECT TO 'MySQL_MYDB (qs.user)';
LET vTabla = 'MY_TABLE';
$(vTabla):
SELECT *
FROM my_schema.my_table;
STORE $(vTabla) INTO [lib://DAT_MARIADB_MYDB_QVD (qliksense_user)/DAT_01_MARIADB_MYDB_$(vTabla).qvd] (QVD);
DROP TABLE $(vTabla);
When querying the database directly, there are no NULL or invalid values in the timestamp column. However, QVD metadata shows 95% NULLS (using QViewer):
As a result, every date related KPI is not reliable, since data is not consistent with the source.
What can I do to prevent this?
Bonjour,
J'essaye désespérément de récupérer certaines infos du CRM Sellsy grace à leur API (https://api.sellsy.com/doc/v2/) mais je bloque sur le filtrage des données !
Dans ma requête, j'utilise la clause "With connection" suivante :
WITH CONNECTION (
URL "https://api.sellsy.com/v2/activities/search",
HTTPHEADER "Authorization" "Bearer $(vAuthorization)",
BODY "$(vBody)"
);
vAuthorization, c'est le token que je récupére pour autoriser la connexion, aucun souci.
Et vBody, c'est ca :
Let vBody ='{""filters"":""entities"":[""calendar_event""]}';
Je precise que j'ai utilisé plusieurs modèles pour le vBody
Exemple : '{[""filters"": {""entities"": [""calendar_event""]}]}';
Et malgré ca, le filtre ne fonctionne pas du tout !
Ca ne renvoi pas d'erreur, mais ca ne filtre pas !
J'ai testé dans le requeteur Postman, et ca fonctionne très bien !
En espérant que quelqu'un ai déjà utilisé ce type de connexion !
Merci d'avance !
Hi I have data loaded as NUM. It contains date. I want to convert it to date format so that I can load it into the datepicker.
Here is my data:-
I have tried these in the data load editor:-
Load
Date((Floor(Timestamp#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];
Date((Floor(Num#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];
I have set my date and time to this:
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
It still loads as Num. Can anyone suggest how to load it in Date?
Pencil in our most magical conference yet: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
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 enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!