How to find out Average Earnings revenue in Last 7 days using SET Analysis in Qlik Sense?

[ishansjain2095]

Hi All,

I am facing an issue to find out estimated revenue in my sale with an average value i.e.

From below expression how to get an average of my revenue in %age form:

(
(
(
SUM({<Date = {"<=$(vLast6Days))>=$(vLast7Days)"}>}[Estimated Earnings])
-
SUM({<Date = {"<=$(vLast5Days))>=$(vLast6Days)"}>}[Estimated Earnings])
)
-
(SUM({<Date = {"<=$(vCDplusOne)>=$(vCurrentDay)"}>}[Estimated Earnings]))
)
/
(
SUM({<Date = {"<=$(vLast6Days))>=$(vLast7Days)"}>}[Estimated Earnings])
-
SUM({<Date = {"<=$(vLast5Days))>=$(vLast6Days)"}>}[Estimated Earnings])
)
)

*100

[Ksrinivasan]

Hi,

1. Average of Estimated earnings=(Sum( {$<Date = {“>=$(=Today()-6)<=$(Today())”} >} [Estimated Earnings] )/6)  Result from Example:5764.667

2. Average of Estimated earnings %=((Sum( {$<Date = {“>=$(=Today()-6)<=$(Today())”} >} [Estimated Earnings] )/6) / (Sum( {$<Date = {“>=$(=Today()-6)<=$(Today())”} >} [Estimated Earnings] )) * 100

Result from Ex:16.66667%

Ex:

01-06-2020	02-06-2020	03-06-2020	04-06-2020	05-06-2020	06-06-2020	Sumup	Sumup/6	Avg %
500	5667	8766	8978	9889	788	34588	5764.667	16.66667

[ishansjain2095]

How can I map date this.....

in QS data load editor .

[Ksrinivasan]

hi,

hi,

i have done in Pivot table,

you can use Dimension Column see below: