Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have created a solution to follow up sales. In the solution we chose a year and one or more months (master dimension). We monitor new customers, lost customers, customers with sales up and customers with sales down between the chosen period and the same period previous year.
All is working except "Lost customers" where we don't have sales (transactions) this year, only pervious year.
In the solution we have created master measures for the calculations with dynamic timeframes, but we struggle with the lost customers. The master measures is used in aggr functions for incorporation three dimensions.
We belive the problem is with the set expressions in the master measures we have crated. We have attached the qvf file which hopefully explains everything.
To all you experts - is there a solution for this?
Hello,
I'm looking for solution to add source from Network drive in Qlik Cloud. how we can achieve this? also how we can add Teradata as a source in qlik cloud as I'm getting error 'The Teradata server can't currently be reached over this network'.
I'm researching if QLIK replicate can be configured to send messages to another topic called "DLQ" once maximum number of retries has been reached. Can you help me to reply this?
If not, what happen when maximum number of retries has been reached?
Thanks
Hi Everyone,
We have two scheduler nodes (S.Node 1 and S.Node2). Due to security reasons, we are trying to trigger couple of batch files in command prompt in S.Node1 only. But Qlik sometimes assign the S.Node2 directly due to which the batch files are failing. Currently we are simply trying to pass local path of the batch file in the "Path Section".
It would be great if you can tell how we can acheive load balancing in this case? Or do we have to tweak the parameters in the External Program tasks.
Regards,
Hi team ,
I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t see my UDF in qlik under expression builder>>functions>>UDF .
need some help on this . please let me know if additional details needed
followed this .
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/user_defined_transformations.htm#:~:text=the%20Expression%20Builder-,User%2Ddefined%20transformations,%3CINSTALL_DIR%3E%5Caddons%5Csamples%5CMyTransformation,-Information%20note
I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.
Hi,
we are moving to Qlik SaaS and want to connect to a third party oracle (cloud) Database.
Is it required to do this via the direct access gateway connector? Or if the 'oracle' connector can be used, does it need to be an Public IP adress?
All feedback is appreciated .
Hi All,
I have data like below
I want get maximum month, previous maximum month and previous to previous month example like below
For name HGI, months like below
maximum month = Jun 2023, previous maximum month = 6/8/2022, previous to previous month = 5/29/1999
I am creating a table with Name, reporting month as Aggr(Max(reporting month), Name) and expressions like below are
1st expression :
(Sum({<reporting_month={"$(vMaxmonth)"}>}Amount) - Sum({<reporting_month={"$(vPrevMonth)"}>}Amount)) /
Sum({<reporting_month={"$(vPrevMonth)"}>}Amount)
2nd expression :
(Sum({<reporting_month={"$(vPrevMonth)"}>}Amount) - Sum({<reporting_month={"$(vPrev3rdvalue)"}>}Amount)) /
Sum({<reporting_month={"$(vPrev3rdvalue)"}>}Amount)
Variable are like below
See below able
For HGI it is showing 840369, same way in 2nd expression it is suppose to show 8051165775.05686 but is showing empty. seems have an issue with expression while fetching 2nd previous record.
But it is not working as expected , please help me someone to achieve this
thanks in advance
Regards,
Saritha
Hi,
I am using Qlik sense Enterprise on windows of qlik sense server 14.129.6(May 2023).
I need to store the QVD files in S3 bucket. but i am getting error as can't open file...
while making connection to S3, i am not getting option of SSE header(which i get to know while searching the error).
so is the issue related to qlik sense version or what would be the reason?
Thank you!
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off. Use code CYBERSAVE.
Apply by December 16 to showcase your expertise and become a Qlik Lumbiary or Qlik Partner Ambassador!
Seamless Public Data Sharing with Qlik's New Anonymous Access Capability
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!