Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

madnanansari
New Contributor III

Set Analysis - YTD Sales

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?


1 Solution

Accepted Solutions
madnanansari
New Contributor III

Re: Set Analysis - YTD Sales

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

2 Replies

Re: Set Analysis - YTD Sales

Yes, you can use

YTQ, QTD, MTD and WTD

madnanansari
New Contributor III

Re: Set Analysis - YTD Sales

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

Community Browser