Strange thing is happening in one of my document. When I select the year from the year list box in the month field, jan-mar is in grey, apr-sep is in white and oct-dec is in green. As per qlikview grey is non selected value, white is selected value and about those which are in green???
That is the one which is confusing me. What does green color mean?
This had happened with one of my project also.
I will give you an example to understand this.
e.g. Department: A, B, C and Designation: a, b, c.
Assume that all these designations are in each of the department.
If you select Dept A, all designations will be in white (all applicable).
Now if you select Desgn b, this is there in all Dept A, B and C. So, they turn green.
This shows that before selecting Designation, you had selected something else (Dept).
In your case, if you select Quarter first, you won't have green color in FYear.
But if you select FYear after selecting Quarter, you will get green color for all the Quarters which are applicable.
I hope this clarifies the difference.
instead of creating fields like YEAR, MONTH, etc. in your script there are expressions in each listbox like
If you select a year so the corresponding values are signed green.
Create your time fields in the script by:
Year(DateField) as Year,
Month(DateField) as Month
and so on.
Many thanks to you. I will try as per your suggestions.
I am facing major problem in the below post. Could you please help me out.