Please see attached .qvf - just copy to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps and refresh with F5 or restart Desktop. (In most cases it should refresh automatically)
Launch the Sales Analysis with Master Calendar app
NOTE: I have used a Master Calendar with mine, to define the various date components.
Here is the expression:
I just replaced Sales and MonthYear:
If you need to get the Master Calendar to work with your data do this:
Locate the Calendar script and put in your date field here in this section:
min(OrderDate) as minDate,
max(OrderDate) as maxDate
Define the data that you load with the date field (first should be on top of Calendar tab)
with the a table definition named Orders as in:
Your Data fro example:
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Thank you for the reply,
So i do have same exact filed like you have in your example
in my case its called MonthYearText (example Dec-2014)
Im using this code and it doesn't work .
Could you please explain i think i'm missing something here. I ran your application and it does work but when i do it in my app it doesn't.Do i need master calendar? i have exactly same filed defined in my app.
Thank you .
Hi Tigran - how is your MonthYearText defined - that may be the issue, as you can see how mine is defined in the screenshot:
It is $numeric,$integer, $timestamp, $date
You can see this in the data model viewer?
Did you use the Master Calendar that was in the app I gave you?
Can you attach your example?
It would be good to see it soon. It's quite a tricky one to explain to
clients why it is not there. Particularly when they then see me trying to
craft a straight line in an expression - a horrible looking expression in a
tool that is supposed to be about simplicity.
As with Variables and KPI objects, I guess the best things come to those
who wait... I shall keep an eye out in the future releases.