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 : 

Map of label:

output:

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 : 

Map of label:

output:

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: 

• Angelika Klidas, Challenger & Educator, Business Data Challengers 
• Priscila Papazissis Paolinelli, Head of Data Analytics, Vallourec
• Steph Robinson, IT Business Intelligence Manager, JBS USA 

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?