Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

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
Creator
Creator

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

View solution in original post

2 Replies

Yes, you can use

YTQ, QTD, MTD and WTD

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Creator

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

View solution in original post