Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
On one of Qlikview tasks I was asked to build a chart where time dimension was supposed to be dynamically calculated and the dates range was supposed to be between min and max dates.
I wasn't sure how to do it and I was told there is an option in Qlikview to set min and max values in charts...
Does anyone familiar with this option?
I'll appreciate your answers,
Thanks
See attachment
Use Set Analysis with Min and Max Date criteria.
SUM({<Date=,Year=, Week=, Month=, Quarter=, Date = {">=$(=Min(Date))<=$(=Max(Date))"}>}Sales)
OK.. this is the expression, but how I build a dimension based on the interval between min(date) and max(date)?
Provide sample application. Would try for you!
it should work automatically if you check 'surpress when value is nul' for your dimension?
Hi Linoy,
If Dim is Your Dimension, Date Your Date
vMinDate Variable Min Date, vMaxDate Variable Max Date
In Chart (e.g. Pivot Table)
Dimension :
=Aggr(If(Date >= '$(vMinDate)' and Date <= '$(vMaxDate)',Dim),Dim)
Regards,
Antonio
Hi Antonio, this looks like a reasonable solution, I'll try that
Thanks
OK, attached
The task is to show the chart only if one of the projects (Project Name) is chosen by user.
Every project has versions and there is a field that indicates if it is the last version or not.
Let's say the chart has to show how many "bad" Stats and how many "good" Stats there were for a specific project.
The dimension is supposed to be between min and max dates which are supposed to be calculated in a following way:
we need to take only last version's Project Start Date, for min value we need to take 2 months before that date and for max value we need to take 3 months after that date.
For example, if we choose 'bbb' project, the last version's date is 15/03/2015. So min date for this project would be 15/01/2015 and max date would be 15/06/2015.
See attachment
Yes!
Thanks, Antonio