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: 
Anonymous
Not applicable

Set Analysis date, issue with the expression editor

Hi all,

I'm pretty new to Qlik Sense (especially with set analysis) and I have some trouble.

I just want to get all past operations for the current year (so before today).

Here is my code :

Sum({$<[OPERATION_DATE.autoCalendar.Date] = {"<=$(Date(Today(),'MM/DD/YYYY'))"} ,[OPERATION_DATE.autoCalendar.Year] = {2018}>} OPERATION_ACCRUED_INT_AMOUNT_EUR)

I think there is an error in my code because the result is not the expected one (it seems that the today section does not work).

But I have some trouble to debug it using Qlik Sense Desktop (February version) because it seems that the expression analyser does not work as you can see in the screens attached.

Perhaps I'm not using it in the right way.

Any help would be appreciated.

Thanks.

1 Solution

Accepted Solutions
sunny_talwar

Try these changes

1) Add an equal sign after dollar sign expansion for Date set modifier

2) Add single quotes for Year (not necessary, but good practice)

Sum({$<[OPERATION_DATE.autoCalendar.Date] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"} ,[OPERATION_DATE.autoCalendar.Year] = {'2018'}>} OPERATION_ACCRUED_INT_AMOUNT_EUR)

View solution in original post

4 Replies
sunny_talwar

Try these changes

1) Add an equal sign after dollar sign expansion for Date set modifier

2) Add single quotes for Year (not necessary, but good practice)

Sum({$<[OPERATION_DATE.autoCalendar.Date] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"} ,[OPERATION_DATE.autoCalendar.Year] = {'2018'}>} OPERATION_ACCRUED_INT_AMOUNT_EUR)

zebhashmi
Specialist
Specialist

all i see

Sum({$<[OPERATION_DATE.autoCalendar.Date] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"} ,[OPERATION_DATE.autoCalendar.Year] = {2018}>} OPERATION_ACCRUED_INT_AMOUNT_EUR)

zebhashmi
Specialist
Specialist

Come on Sunny you are quick and fast

Anonymous
Not applicable
Author

Many thanks it works well !