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

Issue using fields inside set analysis

I have two fields: "KeyDate" and "Chosen Date".  I am trying to make a chart expression that outputs all data for KeyDate<"Chosen Date".  Basically I'd like the user to select a date in a filter pane (Chosen Date), and the chart output all data from the earliest date up until that point.

My current chart expression: This doesn't work.  I have tried with quotes, without quotes, and many different syntax options and it outputs nothing.

     Sum({$<[KeyDate] = {'<[Chosen Date]'}>} Usage)

The same expression works when I input the date num manually.

Sum({$<[KeyDate] = {'<48462'}>} Usage)


If anybody could tell me what I'm doing wrong it would be much appreciated.

1 Solution

Accepted Solutions
Not applicable
Author

Miguel that didnt work. Fortunately I found an expression that worked.

Sum({$<[KeyDate]={'<= $(=[Chosen Date])'}>}Usage)

View solution in original post

2 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Make this change:

     Sum({$<[KeyDate] = {' < & 'num([Chosen Date])' '}>} Usage)


If that doesn't work let me know


Regards,

MB

Not applicable
Author

Miguel that didnt work. Fortunately I found an expression that worked.

Sum({$<[KeyDate]={'<= $(=[Chosen Date])'}>}Usage)