Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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.
In a table I set a Filter Pane and a Table with columns.
Rather than select manually the items from the Filter Pane, I would like to filter the items through an expression similar to this:
=only({<[Material Number (Product)]={
'xyz'
}>}
[Material Number (Product)]).
Probably the expression is not adeguate to the Filter Pane.
Is there any way to filter it by a predefined list?
Thanks
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.
Hello everyone,
I am trying to connect to a FTP and download (tFTPGet) excel files after having them listed (tFTPFileList and iterate on them)
Those files can have the extension .XLSX or .xlsx (i.e. the extension in UPPERCASE or lowercase)
In the files section, "File Mask", if I only allow "*.xlsx", I won't get the .XLSX files and vice versa
If I set both "*.xlsx" and "*.XLSX", I have the afterwards treatment run twice.
I may also get the error in the tFileInputExcel afterwards : "
Do you know how to properly open the two variations of the Excel files ?
I currently download everything (File Mask "*.*") and the add the .xlsx extension (I will then have a file.xlsx.xlsx) which is not a good solution.
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!