Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arixooo123
Creator III
Creator III

Comparing dates in set analysis

my Expression looks like this :

avg({<PurchaseDate<=2015-01-15>}Sales

as you can see I have a Date column (PurchaseDate) and a simple date 2015-01-15

in sql i would simply :

PurchaseDate <= convert(datetime,'2015-01-15',suitable Style)

thanks in advance

5 Replies
its_anandrjs

Try with

Avg({<PurchaseDate = {'<=2015-01-15'} >} Sales )

You can use it dynamically also

Regards

Anand

manojkulkarni
Partner - Specialist II
Partner - Specialist II


set vCompareDate=Date('2015-01-15','YYYY-MM-DD')


avg({<PurchaseDate={"<=$(vCompareDate)"}>}Sales


Make sure both the dates are in same format

Anonymous
Not applicable

Your set analysis syntax is incorrect. Please try below expression

avg({<PurchaseDate = {'<=2015-01-15'}>}Sales)

Regards,

Greeshma

Not applicable

Hi,

if you want to compare a field value with a specific date or variable then use code like this

set vCompareDate=Date('2015-01-15','YYYY-MM-DD')


avg({<PurchaseDate={"<=$(vCompareDate)"}>}Sale)

----------------------------------

if you are facing problem then covert the date into number format then use (num(PurchaseDate)).

set vCompareDate=num(Date('2015-01-15','YYYY-MM-DD'))


avg({<PurchaseDate={"<=$(vCompareDate)"}>}Sales)

Regards

Vimlesh

arixooo123
Creator III
Creator III
Author

the above expression does not work, i don't know why.

but, what if i try this?


avg({<Year(PurchaseDate)<2015,Month(PurchaseDate)<1>}Sales)


it is like in sql i try:

where

datepart(year,PurchaseDate)<2015 and DatePart(Month,PurchaseDate)<1