Hi there,

I am trying to compute a 5-weeks moving average correctly to display it in a graph in a Nprinting report.

Basically my data looks like the attached example : 

- week id

- Nb is my measure

- Moving average 5 weeks : the 5-week moving average of the measure "Nb"

I want to display "Nb" and its "Moving average 5 weeks" only over the last 10 weeks, so between week 202411 and 202420 in my example.

But for weeks 202411 to 202415, I need older data points to be able to compute properly the 5 weeks rolling average, example : 

Moving average 5 weeks for week 202411 = (120 + 200 + 27 + 128 + 625 )/5 = 220

Problem : if I filter on the last 10 weeks only, I miss older data required to compute properly the 5-weeks rolling average. For 202411, I will only get 120/5 = 24 which is wrong.

How can I do to compute properly the moving average for each point and only then, filter to display only the 10-week period of my interest ?

What I have already tried without success :

- compute the moving average in QlikSense and then filter on 10 last weeks in Nprinting graph : FAILED

- filter on 20 last weeks in Nprinting graph to get correct moving average value and then apply an additional filter on 10 last weeks at task level (hoping the aggregation would be performed before the final filter on period) : FAILED

Thanks for your help

Hi All,

In my project using Qlik Data integration here as Source; Sql server, Target: snowflake

After full load of the DB. Iam getting the below errror. Kindly share your suggestions as soon as possible.

Hi Qlik-Experts,

I want to generate a grid chart using two dimensions and calculate the relative fraction but aggregated by one of the dimension.

Unforturnately I am struggling right now.

Attached screenshot shows, that the sum per each row seems to work.

The overall "aggregated sum" is also correct (2.540.234), but for my understanding it would need to be shown in each row of the last column.

Could you please help to push me in the right direction?

Thanks in advande

I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD's in my data and simply adding them to my chart in Excel but in Qlik, I can't seem to work this out.

Below is how I would have it created in Excel:

This makes an easy year on year comparison possible.

But how can I get ytd's and add them to a grouped bar chart like above AND have these refreshed automatically upon a new data load?

I' ve been puzzling with expressions for dimensions in the chart but that didn't work out, I tried to add a variable containing the YTD (add wanting to add YTD-1 and YTD-2 later on).

Hello,

On mobile devices filter clicks result in a popup window.
My question;l how to disable this behaviour?
The current view is clear enough, i want the selected value to be set without any additional popup.
Couldn't find the question/answer on the forum.

Thanx!
 
Best regards,
Sander Kolkman

Hi there 🙂

I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-from dates (one per product). Thats it 😄 

Coud you please help me out with the script function. Attached you find the table load.

Thanks a lot!
Pesche

Hi, I need your help quite urgently. 

I have 2 sources, so 2 fields with the name 'code'. I need to compare them so I added a 'flag' into the sources: 'Source 1' as Flag and 'source 2' as Flag. 

I need to find the codes who only have 'source 1'. So they are missing in source 2. 

All those codes have 2 sources in this example: source 1 and 2. 

I only need the codes with source 1 (and not source 2). 

load script example (basic):

load 

code as 'check code'

Source 1 as Flag

From source 1

load 

code as 'Check code'

Source 2 as Flag

From source 2

If I filter on dimension 'Flag' on  'source 1' and select a code, then I remove the filter 'source 1' (so only the code filter left), then there are 2 sources: source 1 and source 2.. Those are the codes I DON'T need.. 

Can anyone please help me? 

Many thanks! 

I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached)
and successfully synced then using user directory connector , 

But these synced users are failing to authenticate / login to Qlik hub and  QMC

Tried different ways to resolve this , - 

But nothing worked, please help if anyone can provide suggestions