Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table:
I have an expression that should return the records that are at the intersection of scenarios 204 and 208, but it returns records from other scenarios as well, such as 104, 107, 108, etc., as can be seen in the following table:
This is the expression:
=count( {$<ID_CARD= P({<Escenario2={'208'}>})*P({<Escenario2={'204'}>})>} ID_CARD )
If I use the filters and select only the scenarios I want, I get the result I expect:
But, I need you to give it to me without using the filters.
I hope you can help me.
Thank you very much
Dear all,
I have table such as below without any modification date fields and every day the period is changes based on backend calculations.
Day:1
ID Period
1 2Yrs-3months-10days
2 4Yrs-5Months-0days
3 0Yrs-1Month-10days
Day:2
ID Period
1 2Yrs-3months-10days
2 7Yrs-2Months-0days
3 0Yrs-1Month-11days
Our requirement is display the latest Period for each ID. How can we achieve this.
Dear all,
I have below code running in qliksense to get the profit and margin for each ID from the fact table.
I have total 300000 unique ID for each of them I am gettting profit from database package.
Problem is it is taking too much time which is offcourse because for each single ID it is getting connected to database package which has its own script and then as function it is returning its profit to the qliksense.
I need to understand if there is any possible solution to fetch the records faster..
Fact:
LOAD
ID
FROM TEST.QVD;
For i=0 to fieldvaluecount('ID)'
Let vFieldIDValue =FieldValue('ID','$(i)');
Profit:
LOAD*;
Select ID, Profiltfrom table (pkg.profilt('$('vFieldIDValue '))
NEXT;
DROP TABLE FACT;
So, in above code the highlighted is the database package and profitmargin is the function which takes single ID from fact table as parameter and do its CALCULATION AND RETURN the result as profit.
NOTE: when we execute "Select ID, Profiltfrom table (pkg.profilt('$('vFieldIDValue '))" in database directly it takes very lesss time than the qliksense
Hello Qlik Community,
We are currently trying to replicate various tables from a DB2-ZOS to a DB2-LUW using Qlik Replicate, and we have noticed that the nullability in the target table and the corresponding __ct table are different. Are there ways to keep these consistent?
some snippets of the corresponding log:
I am relatively new to this software, and I usually replace my old data with new ones at the homepage. But my 'add new' button is gone (which is the one i usually upload data before i go into data load editor) and i dont know how it went missing. can anyone who knows about this help me out?
Hi,
My connection to Dynamodb was working a couple of days ago. When I try to connect now, I am getting an error message saying "Error connecting to the Sense service". How do I fix this please?
Thanks
Hi People,
I have installed the app Sense-Script-Load-Analyzer.qvf,
and changed the app owner - as requested.
When loading, I get the error mesage:
Connection monitor_apps_REST_app not found.
Any idea how I an resolve this?
Are there any alternatives for this tool?
Thanks!
Hello all,
I would like to exclude Region filter from my expression but the below listed expression is not working. I have If condition for an aggregated dimension and trying to exclude Region filter. Please suggest.
= Count({<Region= >} Aggr (If ( Status = 'InProcess', Status <> 'Complete'), Commodities, Commodities))
Thanks.
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!