Set Analysis on Current MTD

Tue, 21 Jul 2015 06:12:52 GMT

Hello, It's been a long day and trying to figure this out, can someone assist please.

Data:

Filters: Year (2014, 2015) Month (Jan...Dec)

Computer	Total Average % Deleted Files (For all data)	Avg Current MTD (July 1 to Today())
A	20	2
B	30	3
C	20	2
D	50	2

-- TOTAL Current Avg MTD = 9

***Don't mind the data, just entered whatever***

What I am trying to achieve:

Expression showing the Total Current MTD Number until I filter to the specific computer...

Currently, If I filter to a computer the data changes to match the total for all the data..

Sorry if this is confusing, I cannot post the QV file, I will try and give as much info as possible.

=Num((Sum(<$={"$(= '>=' & date(MonthStart(today())) & '<=' & date(Today()))"}>} distinct Computer)/(Count(Sum(<$={"$(= '>=' & date(MonthStart(today())) & '<=' & date(Today()))"}>} distinct Computer))/100), '###.##%')

Re: Set Analysis on Current MTD

sunny_talwar — Tue, 21 Jul 2015 15:28:25 GMT

May be this:

=Num((Sum({<Date = {"$(= '>=' & date(MonthStart(today())) & '<=' & date(Today()))"}>} Distinct Computer)/

(Count({<Date = {"$(= '>=' & date(MonthStart(today())) & '<=' & date(Today()))"}>} Distinct Computer))/100), '###.##%')

topic Re: Set Analysis on Current MTD in QlikView

Set Analysis on Current MTD

Re: Set Analysis on Current MTD