Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Senor_Dai
Partner
Partner

Compare Current Week to Previous 3 Week average

HI,

 

I have the following Expression to count the number of export/send to excel actions from the Governance Dashboard:

sum({<AuditType={'Export','SendToExcel'} >}Audit_Count) 

 

What I would like to do is create a chart that only populates if the current weekly total (Mon-Fri) is greater than the previous 3 week average (Mon-Fri) and show this by the Authenticated_User dimension.

 

Many thanks for any help or advice.

Dai

 

Labels (1)
  • Other

0 Replies