Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.


Set Analysis - YTD sales for current Hijri Year

I have a master calendar which has the below values :



Month Year

Hijri Date

Hijri Year

Hijri Month Year

I can calculate the current year sales as below:

Sum({$<[Date] = {"<=$(=Today()-1)"},[Year]={"$(=Year(Today()))"}  [Sales])

I have a requirement to produce current Hijri Year sales. How can i write a similar set analysis function as above for it?