Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a client considering a move to saas, so I downloaded the qlik sense migration app. Unfortunatly you need a cloud tenant to to the check. Older versions are without this connection to cloud.
Does anyone have an older version of the cloud Readiness app? One without the connection to cloud?
Kind regards,
Isabelle
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
Qlik Compose for Data Warehouses
Hello everyone,
in qlik sense
I have a timestamp in a string format and I need to convert it into a date and time with e specific format.
the idea is to be able to create a calendar or extracts month.week...etc from that field, which is not possible when it's a string
Hi,
I have many cases in my data where the question asked essentially is:
if value () doesnt appear // does appear in this table then 'Yes' else 'No'
this simple formula is proving very challenging to do without creating synthetic keys.
Is there an easy one line formula you are able to slot into the actual table in the load editor that would solve this. For example:
Load
*,
If......'yes','no
from File
Please help
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]);
Hii, I'm Darshan Hiranandani, How do you suggest testing an app before launching it to the public? I'm interested in hearing your insights and recommendations.
I have been following the Top N the example on YouTube, but I guess I lost.
While the example only looks at Brand and Sales
In my example. I group Function, Name on Sales
When I do the of
Rank(Sum(Sales), Function, Name)<=10
It tested for -1 and 0. -1 means the Sales falls within the Top 10
However, when I try to bring the actual result so I can use variable input, it does not work.
This is what I am using to try to filter the column for only the Top 10
Sum(
{<
Function, Name={“= Rank(Sum(Sales), Function, Name)<=10
”}
>}
Sales)
Hello,
how do i need to make a linechart with a cumulative total that stops drawing a line when there are no actua values instead of keeping a straight line?
i can't seem to work this out...
This is expression i have:
sum({<[Fiscal Year]={'2023 - 2024'}, [KPI's]={'KPI 1:Retail / Tafelen'} >}[factuur tot net])/1000
Thanx a lot!
grtz,
Chris
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.
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!