Comparing two dates data

[#1]

Hi, I am new to qlikview can anybody tell how to compare today's date data with yesterday's date data and display the higher count of logcount happened on any date.

I have already counted two days data but i am not getting how to compare and display the highest one. Please help

[qlikview979]

Hi,

Are you Expecting like this

[ahaahaaha]

Hi,

May be like in attached file

Regards,

Andrey

[sanjay006]

Today Sales :

(Sum({<NUM_DATE = {$(vMaximum)}>} AMOUNT))

vMaximum=num(max(Date_Field))

Previous date Sales :

(Sum({<NUM_DATE = {$(vPrevious)}>} ACCTD_AMOUNT))

vPrevious=max(DATE_SLIPDATE1)-1

[sanjay006]

Today Sales :

(Sum({<NUM_DATE = {$(vMaximum)}>} AMOUNT))

vMaximum=num(max(Date_Field))

Previous date Sales :

(Sum({<NUM_DATE = {$(vPrevious)}>} ACCTD_AMOUNT))

vPrevious=max(Date_Field)-1

[#6]

yeah but not exactly same i need to compare the data and display the highest count in a text box

[qlikview979]

can you please share sample data.

[sanjay006]

Give this expression in your text box

if((Sum({<NUM_DATE = {$(vPrevious)}>} ACCTD_AMOUNT)))>(Sum({<NUM_DATE = {$(vMaximum)}>} AMOUNT))

,

(Sum({<NUM_DATE = {$(vPrevious)}>} ACCTD_AMOUNT))),

(Sum({<NUM_DATE = {$(vMaximum)}>} AMOUNT)))

[#9]

My data is something like this i need to compare yesterdays data and todays data and need to display only whichever has the highest count

[qlikview979]

Goto Presentation tab---> Click on Values on datapoints