Qlik Community

Ask a Question

New to Qlik Sense

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

Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Set analysis sintax for date range

Hi guys,


can you say me what is wrong in this sintax:

Sum({$<DATUM={">=$(=Date(weekstart(rangemin(today(), max(DATE)))))<=$(=Date(RANGEMIN(today(), MAX(DATE))))"}  >}VALUE)

For default, without choosing a date, it gives a good data in table. But if I choose one date, result give me just data for this picked date, not for interval weekstart(DATE)- DATE.






2 Replies

Do you have two fields? DATE and DATUM? If you do, do you make selection in DATE field? Try this

=Sum({$<DATUM = {">=$(=Date(WeekStart(RangeMin(Today(), Max(DATE)))))<=$(=Date(RangeMin(Today(), Max(DATE))))"}, DATE>} VALUE)
Creator III
Creator III

No, all is one word (DATE)... I forgot to change DATUM into DATE, when I was changing...