Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarmie_Akintona
Contributor II
Contributor II

Using Date in Set Analysis

Hello All,

I am trying to use a Date Field, codenamed PayDate, in a Set Analysis. However, it's not turning out right for me. I want the summation of the 'Payment' Field from a particular date

Sum({<PayDate={">=$(=Date((PayDate), 'DD.MM.YYYY'))"}>}Payment)

This is not yielding any result whatsoever. Could anyone help me out here?

Labels (4)
1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @Sarmie_Akintona !

        You cannot use a field in set analisys without agregation. 

Sum({<PayDate={">=$(=Date((PayDate), 'DD.MM.YYYY'))"}>}Payment)

You need to use something like this

Sum({<PayDate={">=$(=Date((Max(PayDate)), 'DD.MM.YYYY'))"}>}Payment)

You also can use a variable to set the date:

Sum({<PayDate={">=$(varDate)"}>}Payment)

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @Sarmie_Akintona !

        You cannot use a field in set analisys without agregation. 

Sum({<PayDate={">=$(=Date((PayDate), 'DD.MM.YYYY'))"}>}Payment)

You need to use something like this

Sum({<PayDate={">=$(=Date((Max(PayDate)), 'DD.MM.YYYY'))"}>}Payment)

You also can use a variable to set the date:

Sum({<PayDate={">=$(varDate)"}>}Payment)

Help users find answers! Don't forget to mark a solution that worked for you!
Sarmie_Akintona
Contributor II
Contributor II
Author

Thank you, Joaopaulo. I got the concept now with your explanation.