topic Set Analysis - YTD Sales in QlikView

Set Analysis - YTD Sales

madnanansari — Mon, 18 Sep 2017 11:53:06 GMT

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 — Mon, 18 Sep 2017 13:31:02 GMT

Yes, you can use

madnanansari — Mon, 18 Sep 2017 14:35:35 GMT

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