Qlik Community

New to Qlik Sense

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jasmina_karcic
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.

 

Thanks,

 

Jasmina

 

2 Replies
sunny_talwar

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)
jasmina_karcic
Creator III
Creator III
Author

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