# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Did you mean:
Contributor II

## Sum of Last Day Sales

 Platform OI_Systeminfo.virtual Inventory Date count AI Virtual CCMF 11/25/2017 51 AI Virtual CCMF 11/26/2017 51 AI Virtual CCMF 11/27/2017 52 AI Virtual CCMF 11/28/2017 52 AI Virtual CCMF 11/29/2017 52 AI Virtual CCMF 11/30/2017 52 AI Virtual CCMF 12/1/2017 52 AI Virtual CCMF 12/2/2017 52 AI Virtual CCMF 12/3/2017 52

This series getting increase as per the new date .

I have tried a expression /Set analysis ,

=sum({<Date={Today(),-1}>},count))

I need sum of count for all type of platform .

Let me know if you need any more details

1 Solution

Accepted Solutions
Partner - Master III

Try,

sum({<Date={"\$(=Today()-1)"}>} count)

or

sum({<Date={"\$(=Max(Date))"}>} count)

12 Replies
Partner - Master III

Try,

sum({<Date={"\$(=Today()-1)"}>} count)

or

sum({<Date={"\$(=Max(Date))"}>} count)

MVP

I'd suggest:

sum({<Date={"\$(=Today(1)-1)"}>} count)

Contributor II
Author

sum({<Date={"\$(=Max(Date))"}>} count) This worked Thanks Shraddah,

I have one more Query,

I want to display one more KPI with in that KPI ,

The second KPI should give me ,the difference of (Last working day ) -(sum of 2nd last day )

Let me know if you need more details .

Partner - Master III

Sum({<Date={"\$(=max(Date))"}>} Count) -

Sum({<Date={"\$(=date(max(Date)-1,'MM/DD/YYYY'))"}>} Count)

Contributor II
Author

I have enhanced query on this ,I want the sum of count on last day wrt platform

Means there are several platform like AI,BI,CI and so on

I want some of count of last day of AI and BI .

Let me know if you need more details .

I use this below query but its giving 0 ,Which is not correct .

sum({<Date={"\$(=Max(Date)),Platform={'AI'},{'BI'}"}>} count)

Partner - Master III

Try:

sum({<Date={"\$(=Max(Date))"},Platform={'AI','BI'}>} count)

Contributor II
Author

I have another query.

I am using this Set Analysis but not working .Its giving Zero Value .

sum({<Date={"\$(=Max(Date))"},OS={'2003*'}>}count)

I have data like ,

 OI_Systeminfo.operatingsystem Microsoft(R) Windows(R) Server 2003 Enterprise x64 Edition Microsoft(R) Windows(R) Server 2003 Standard x64 Edition Microsoft(R) Windows(R) Server 2003, Datacenter Edition Microsoft(R) Windows(R) Server 2003, Enterprise Edition Microsoft(R) Windows(R) Server 2003, Standard Edition Microsoft(R) Windows(R) Server 2003 Enterprise x64 Edition Microsoft(R) Windows(R) Server 2003 Standard x64 Edition Microsoft(R) Windows(R) Server 2003, Enterprise Edition Microsoft(R) Windows(R) Server 2003, Standard Edition

MVP

sum({<Date={"\$(=Max(Date))"},OS={'*2003*'}>}count)

Contributor II
Author

Thanks Omar ,Its Working

I have another Query ,

I want Sum of Count while Info is Virtual and inventory is DDM

I Have tried this below Query .

sum({<Date={"\$(=Max(Date))"},Info={'Virtual'} AND Inventory={'DDM'}>}count)

For Only Virtual the below query is working

sum({<Date={"\$(=Max(Date))"},Info={'Virtual'}>}count)

Any help is Appreciated

Let me know if you need any more details

Tags
Community Browser