Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator III
Creator III

Get Sum of yearstart each year

Hello,

I need the value from the beginning of each year in a pivot table.

  2023 2024 2025
Employess      

 

Previously, this value was shown individually for a selected year. But now I have to display these values ​​in a table for each year.

Count([MASTER_CAL.Date] = {"$(=Yearstart(AddYears(Max(MASTER_CAL.Date),0)))"}>} distinct [Abtn.ANNr])

 Of course I can't use this expression anymore.

Can you help me please?

Labels (2)
1 Solution

Accepted Solutions
reporting_neu
Creator III
Creator III
Author

Thanks for your suggested solution.

I can't use it in the script because the required data isn't together in one table.

But I found another solution.

Count({<MASTER_CAL.Date = {"=Left(Date(MASTER_CAL.Date ), 6)='01.01.'"}>} distinct [Abtn.ANNr])

View solution in original post

2 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

In your place I would use the script.

You can create a DateYearStart field like this:
if([MASTER_CAL.Date]=YearStart([MASTER_CAL.Date]),[MASTER_CAL.Date]) as DateYearStart

Then I will use the DateYearStart field as a dimension

reporting_neu
Creator III
Creator III
Author

Thanks for your suggested solution.

I can't use it in the script because the required data isn't together in one table.

But I found another solution.

Count({<MASTER_CAL.Date = {"=Left(Date(MASTER_CAL.Date ), 6)='01.01.'"}>} distinct [Abtn.ANNr])