Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
madnanansari
Creator
Creator

Set Analysis - YTD sales for current Hijri Year

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?



0 Replies