topic Re: Comparing two dates data in QlikView

Comparing two dates data

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Comparing two dates data

qlikview979 — Wed, 17 May 2017 07:38:24 GMT

Hi,

Are you Expecting like this

Re: Comparing two dates data

ahaahaaha — Wed, 17 May 2017 07:50:53 GMT

Hi,

May be like in attached file

Regards,

Andrey

Re: Comparing two dates data

sanjay006 — Wed, 17 May 2017 07:57:51 GMT

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

Re: Comparing two dates data

sanjay006 — Wed, 17 May 2017 07:58:14 GMT

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

Re: Comparing two dates data

Wed, 17 May 2017 08:47:46 GMT

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

Re: Comparing two dates data

qlikview979 — Wed, 17 May 2017 09:01:22 GMT

can you please share sample data.

Re: Comparing two dates data

sanjay006 — Wed, 17 May 2017 09:02:18 GMT

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)))

Re: Comparing two dates data

Wed, 17 May 2017 09:56:23 GMT

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

Re: Comparing two dates data

qlikview979 — Wed, 17 May 2017 11:34:36 GMT

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