Set Analysis - YTD Sales

[madnanansari]

I have a master calendar which has the below values :

Date

Year

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?

[Anil_Babu_Samineni]

Yes, you can use

YTQ, QTD, MTD and WTD

[madnanansari · Accepted solution]

your solution is not helpful for Hijri Calendar. All the functions which Qlik provides for Gregorian calendar are not applicable for Hijri.