Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to show "Same Month Previous Year" Sales numbers (As shown below in Column E) in a table. The month itself is in the dimension. My current expressions are:
Sales: Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales)
Sales Previous Month: Above (Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales))
Need help with the expression for "Sales Prev Year".
Appreciate any help!
Regards,
Bhaskar
Hi All,
Can you pleae help me to get Label names from second table to replace IDs in the first table.
Source :
Name | ID | CID | ZID |
Arunesh | 1001 | 2001 | 3001 |
Ramesh | 2001 | 3001 | 40001 |
Nancy | 5001 | 7001 | 6001 |
Map of label:
Field | Label |
ID | ScreenId |
CID | CountryId |
ZID | ZoneID |
output:
Name | ScreenId | CountryId | ZoneID |
Arunesh | 1001 | 2001 | 3001 |
Ramesh | 2001 | 3001 | 40001 |
Nancy | 5001 | 7001 | 6001 |
I am having too many colums so lookng some some automated way in the script.
Thanks in advance!
Best Regards,
Arunesh
Hi Qlik Sense Community,
Hope this question finds you well.
I need your help to identify the the specific error and solution. The error message I get is :"Invalid expression" for HighestPriorityFlag in my codes written below.
For your context, I have defined my definition of duplicates:
if ID and DT_INTERVENTION are the same in other rows, then they are duplicates (highlighted in ythe screenshot below). The error occured when I tried to add a column for row_flag (red column in the screenshot)
The followings are my codes. Could you kindly let me know why it does not work?
Thank you so much in advance!
//Remove duplicates and keep the first row of sorted priority
HighestPriorityFlag:
LOAD
*,
If(priority = FirstSortedValue(priority, [ID]&[DT_INTERVENTION]), 'Keep', 'Remove') AS row_flag
RESIDENT OriginalDataWithPriority
GROUP BY [ID], [DT_INTERVENTION], priority;
FinalData:
NOCONCATENATE
LOAD *
RESIDENT HighestPriorityFlag
WHERE row_flag = 'Keep';
Hi All,
Can you pleae help me to get Label names from second table to replace IDs in the first table.
Source :
Name | ID | CID | ZID |
Arunesh | 1001 | 2001 | 3001 |
Ramesh | 2001 | 3001 | 40001 |
Nancy | 5001 | 7001 | 6001 |
Map of label:
Field | Label |
ID | ScreenId |
CID | CountryId |
ZID | ZoneID |
output:
Name | ScreenId | CountryId | ZoneID |
Arunesh | 1001 | 2001 | 3001 |
Ramesh | 2001 | 3001 | 40001 |
Nancy | 5001 | 7001 | 6001 |
I am having too many colums so lookng some some automated way in the script.
Thanks in advance!
Best Regards,
Arunesh
Hello Community,
We are facing performance issues while bulk insert and updates comes from source, as they too long to reflect on the target. we've checked both source and target availability, and everything seems fine, but the changes are accumulating at the target apply disk, as shown in the screenshot below.
we also enabled verbose logging for both source and target apply performance but haven't been able to identify any specific issue. any suggestions from our community member on how to resolve this would be greatly appreciated.
Thank you,
Pranita
Come connect and network with the inspiring Women Who Qlik community!
Join us on September 24 for an engaging panel discussion on career advancement, professional growth, personal branding, and more. This is an open forum for you to bring your questions and ideas while sharing insights with fellow data enthusiasts and industry leaders.
Whether you're looking to learn, share, or connect—everyone is welcome. If you're passionate about data and AI and want to be part of a network that champions women in the industry, this Meetup is for you!
The first 25 attendees to register will receive an exclusive Women Who Qlik t-shirt!
When: Tuesday, September 24 at 11am ET / 4pm UK / 5pm CEST
Where: Zoom Register here
Featuring panel discussion moderated by:
See you then!
Hello Community!
First of all excuse my bad english.
I had to do a graph that compares 2 different years, and more specifically n days at the near-end-period. Basically it looks the n days before 31/05/2024 and n days before 31/05/2023, i show it in the same graph in 2 different lines with the same scale. For exemple for the 1st of September i want to see in my graph 01 Sept in the dimension and 1000€ in blue for 2024 and 2000€ in red for 2023.
MyDate is at format DD/MM/YYYY and i am doing this :
Dimension :
Day(MyDate) & ' ' & Month(MyDate)
Measure 1 :
Sum({< MyDate = {"=MyDate>= Num(Date('$(vDateMax)','DD/MMM')) - $(vNearPeriodEnd)"} >} Amount)
Measure 2 :
Sum({<MyDate={"=MyDate<= Num(Date('31/05/23','DD MMM')) and MyDate>=Num(Date('31/05/23','DD MMM'))- $(vNearPeriodEnd)"}>}Amount)
And it works very well,
BUT i can't sort dates in the chronological order (without taking care of the year) and i tried lot of things :
Sorting by expression with "MyDate" or "Day(MyDate) & ' ' & Month(MyDate)" or Numerically or Alphabetically and i tried to create in the script "Date(NewDate,'DD MMM') as NewDate" and still doesnt work
Hope some of you have an idea.
Thanks !!
Val
Hi!
I have a parameterized "match" function in load script. That is, I have a variable that handles arguments in the "match" function. In several places I would like it to stay that way, but for match to contain all the data for the field.
The question is, what to enter in match so that it "takes" everything?
match(XXX,'*') doesn't work, does it?
We received an email alert from Qlik Replicate saying a task has the following error. The issue happens frequently though is not causing any issues. The task was able to resume, did not cause error.
Please share how to resolve this.
=========
TASK_AA replication task encountered the following error:
Stream component 'st_0_TASK_AA' terminated Stream component failed at subtask 0, component st_0_TASK_AA Error executing source loop Endpoint is disconnected Encountered an unexpeceted error.
do_organize_fetched_row(...) failed in executing mssql_get_table_tlog_attributes(...)
Failure in querying for compression setting for table 'dbo.MASTERTABLE'
RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Microsoft][SQL Server Native Client 11.0]Query timeout expired Failed (retcode -1) to execute statement: '
select p.data_compression from sys.partitions p,sys.objects o where p.object_id = o.object_id
and schema_name(o.schema_id ) = N'dbo'
and o.name=N'MASTERTABLE'
'.
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!