sum per minimal date - set analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

could you please give me suggestion how to solve my problem?

I have data by date and i have some values in seperate table.

In pivot table I need dimension that changes from Year/Month/Week/Day. And I need to always select Value for the minimal day (not always 1st of the month/week -so it needs to be dynamic in the expression, cant be a flag in the script).

Month Value e.g.

Feb Value taken from the first date of Month Value for 01.03

Mar Value for 03.03

April Value for 04.03

Week Values for minimal day of Week

I tried:

sum({<date={"$(=min(date))"}>} Value), but that gives me only value in the first line of dimension.. ;/

I'll appreciate your help.

Tommy

Re: sum per minimal date - set analysis

sunny_talwar — Wed, 22 Feb 2017 16:35:37 GMT

May be like this

FirstSortedValue(Value, -Date)

FirstSortedValue(Aggr(Sum(Value), Date), -Date)

topic Re: sum per minimal date - set analysis in QlikView

sum per minimal date - set analysis

Re: sum per minimal date - set analysis