Set analysis Expression for Aggregated data from the last 4 weeks

[amrutha_sathish]

Can somebody suggest a  Set analysis Expression for Aggregated data from the last 4 weeks based on the dimension 'Channel'.

Thanks in advance.

[joaopaulo_delco]

Hi @amrutha_sathish !

        Using a table object, you can add the "Channel" dimension and add the follow measure:

Sum({<YourDimensionDate={"$(=(Date(today(1)-28)))"}>} YourValue)

[amrutha_sathish]

Hi, can you please explain the set analysis expression. i mean i'm just curious to know why are we doing 'Date(today(1)-28'....?

[joaopaulo_delco · Accepted solution]

OK, I'll try to explain.

       A date field is actually a number, but the mask shows in a date format.

As a number, you can do mathematical expressions like + or -.

Let's suppose that today is 07-11-2023, so if you use some expression adding 3, the return will be 07-14-2023.

I used "-28" in the expression because it is exactly the number of days of 4 weeks.

the function today(1) return the date of the latest data reload.

You can check this link https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunc...