Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sushantaqlik
New Contributor

Sum of Last Day Sales

   

   

PlatformOI_Systeminfo.virtualInventoryDatecount
AIVirtualCCMF11/25/201751
AIVirtualCCMF11/26/201751
AIVirtualCCMF11/27/201752
AIVirtualCCMF11/28/201752
AIVirtualCCMF11/29/201752
AIVirtualCCMF11/30/201752
AIVirtualCCMF12/1/201752
AIVirtualCCMF12/2/201752
AIVirtualCCMF12/3/201752

This series getting increase as per the new date .

I have tried a expression /Set analysis ,

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

which is not working .Please help

I need sum of count for all type of platform .

Let me know if you need any more details

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Sum of Last Day Sales

Try,

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

or

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

12 Replies
shraddha_g
Honored Contributor III

Re: Sum of Last Day Sales

Try,

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

or

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

omarbensalem
Esteemed Contributor

Re: Sum of Last Day Sales

I'd suggest:

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

sushantaqlik
New Contributor

Re: Sum of Last Day Sales

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 .

shraddha_g
Honored Contributor III

Re: Sum of Last Day Sales

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

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

sushantaqlik
New Contributor

Re: Sum of Last Day Sales

Thanks Shraddha ,This also Click .Thanks for your support

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)

shraddha_g
Honored Contributor III

Re: Sum of Last Day Sales

Try:

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

sushantaqlik
New Contributor

Re: Sum of Last Day Sales

Thanks Shraddha,It worked ..Thanks again for your support .

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

   

Please help on This

omarbensalem
Esteemed Contributor

Re: Sum of Last Day Sales

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

sushantaqlik
New Contributor

Re: Sum of Last Day Sales

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