Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The screenshot below refers, l want to create a Calculated Field to convert the column EFFDATE into a proper date format. Current format is 04/03/2024 07;06:22 which is a string and not proper date format for trend analysis.
can we able to use multiple condition in a where clause?
for ex: we are having several countries. ( ind, aus, eng,pak)
i need to filter and show only ind and aus.
so, how we can write script using where condition.
can anyone please share your ideas for my learning.
Hi all,
I need to concatenate these 2 tables, and they share the name of 2 fields (event_code and weeks_left_to_event), but need them to be connected only by the event_code.
As I have the script now, there aer rows missing form the second table as only appear the rows that share the weeks_left_to_event. How could I do this? Do I need to make a UNION ALL in the pipeline before Qlik or there is a way to do it in the load editor?
This is the code:
[marts_event_ticketing]:
SELECT "event_id",
"event_name",
"event_country",
"event_date",
capacity,
"event_code",
"ticket_id",
"cashless_paid_credits",
quantity,
"ticket_type",
"sold_date",
"ticket_date",
"ticket_category",
status,
"event_currency",
"gbp_rate",
"eur_rate",
"base_amount",
"fee_amount",
"total_amount",
email,
"customer_country",
city,
age,
gender,
"age_group",
"year_event",
"month_event",
"days_left_to_event",
"weeks_left_to_event",
"months_left_to_event",
babb,
"previous_event_code",
"previous_event_name",
"previous_year_comparison",
"ticket_sales",
"previous_event_ticket_sales",
"event_end_time",
"event_to_compare",
"previous_day_sales",
"marketing_total_spend",
cpa,
budget_event_end_time,
budget_quantity,
budget_price,
budget_fee,
budget_gross_revenue
FROM "dbt_xavi_marts"."marts_event_ticketing";
concatenate
LOAD
"event_code",
"budget_event_end_time",
round("weeks_left_to_event", 1) AS weeks_left_to_event,
"budget_quantity",
"budget_price",
"budget_fee",
"budget_gross_revenue"
FROM [lib://DataFiles/Ticketing 2024 (1).xlsx]
(ooxml, embedded labels, table is [Hoja 3]);
I wrote the below Macro code using VBScript I know the code is correct. Anytime I press the button attached to macro on my system instead of the script to fire it was reopening the macro editor. please, what can I do apart from changing module security to system access in which I did but it is not running.
Sub HideTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=False
ActiveDocument.SetProperties DocuProp
End Sub
Sub ShowTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=True
ActiveDocument.SetProperties DocuProp
End Sub
Hi,
I have a scenario where I want to tagged a policy with a remark "Case_Repeated" if same policy was logged after previous call resolved <= 56 days. e.g. is given below.
Policy_No | Call Logged date | Call Resolved date | Token_no | Repeted_Remark |
123457 | 12-Mar-23 | 17-Mar-23 | A_123 | |
456789 | 17-Apr-23 | 20-Apr-23 | B_124 | |
123457 | 12-May-23 | 17-May-23 | A_126 | Case_Repeated |
456789 | 19-Jun-23 | 12-Jul-23 | B_123 | |
123457 | 21-Jun-23 | 25-Jun-23 | A_129 | Case_Repeated |
456789 | 26-Aug-23 | 31-Aug-23 | B_127 | Case_Repeated |
123457 | 12-Dec-23 | 01-Feb-24 | C_124 | |
234567 | 09-Feb-24 | 15-Feb-24 | d_123 |
Thanks in advance
Hi, I have asked ChatGTP to write some code that will show me the third business day of the week. I have been amazed at how fast and accurate it has been.
Do you think it can be optimized? (al code in text format bellow)
// Set up a calendar table to use for date calculations
Calendar:
LOAD
date(YearStart(year, month, 1) + rowNo() - 1) as date,
week(YearStart(year, month, 1) + rowNo() - 1) as week,
year(YearStart(year, month, 1) + rowNo() - 1) as year,
month(YearStart(year, month, 1) + rowNo() - 1) as month,
day(YearStart(year, month, 1) + rowNo() - 1) as day
FROM
[lib://calendar/calendar.qvd] (qvd);
// Set up a table to store the 3rd business day for each week
ThirdBusinessDay:
LOAD
min(date) as third_business_day
RESIDENT
Calendar
WHERE
isweekday(date) = 1 and day >= 3;
// Group by week to get the 3rd business day for each week
ThirdBusinessDay:
LOAD
third_business_day,
week,
year,
month
RESIDENT
ThirdBusinessDay
GROUP BY
week,
year,
month;
// Drop the original calendar table
DROP TABLE Calendar;
Hello Folks,
I looked through my tasks on the QMC and I saw that one failed.
However, when I look at the script log, I see that the script says it finished successfully.
Has anyone else seen such behavior?
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Get to know these Qlik experts driving innovation and excellence in data, analytics and AI.
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!