Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ishansjain2095
Creator
Creator

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

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

Labels (1)
3 Replies
Ksrinivasan
Specialist
Specialist

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-202002-06-202003-06-202004-06-202005-06-202006-06-2020SumupSumup/6Avg %
5005667876689789889788345885764.66716.66667
ishansjain2095
Creator
Creator
Author

How can I map date this.....

ishansjain2095_0-1597381581126.png

in QS data load editor .

Ksrinivasan
Specialist
Specialist

hi,

 

hi,

i have done in Pivot table,

you can use Dimension Column see below:

Ksrinivasan_0-1597508742382.png