topic What does green color in selection indicates? in QlikView

What does green color in selection indicates?

Thu, 16 Sep 2010 04:50:12 GMT

Hi All,

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?

What does green color in selection indicates?

Thu, 16 Sep 2010 05:53:41 GMT

Hi,

If you can share that QV file, probably Root Cause can be traced.

May be you can partial data.

Happy Thoughts

What does green color in selection indicates?

Thu, 16 Sep 2010 06:25:10 GMT

Hi Ravi,

Have attached the document for you to work on. Please provide some solution at the earliest.

What does green color in selection indicates?

Thu, 16 Sep 2010 06:56:58 GMT

Hi,

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.

Happy Thoughts

What does green color in selection indicates?

Thu, 16 Sep 2010 08:08:47 GMT

Let me know what has to be done for this? This is really confusing! Whatever the reason may be but this has to be avoided. Let me know what has to be done for this.

What does green color in selection indicates?

Thu, 16 Sep 2010 08:22:55 GMT

Select Quarter Only; Don't select Financial Year (It will be automatically selected).

What does green color in selection indicates?

Thu, 16 Sep 2010 11:09:32 GMT

In my case I have selected only the year(2009). Still it shows grey,white and as well as green in the month.

What does green color in selection indicates?

Thu, 16 Sep 2010 11:53:17 GMT

Hi Rikab,

instead of creating fields like YEAR, MONTH, etc. in your script there are expressions in each listbox like

=QuarterName(TranDate)

If you select a year so the corresponding values are signed green.

Create your time fields in the script by:

Load

Year(DateField) as Year,

Month(DateField) as Month

.....

and so on.

Good luck!

Rainer

What does green color in selection indicates?

Thu, 16 Sep 2010 12:24:14 GMT

Hi Rainer,

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.

http://community.qlik.com/forums/t/34086.aspx

What does green color in selection indicates?

sunil2288 — Thu, 16 Sep 2010 13:01:57 GMT

Hi Rikab ,

You can take Monthname as the list box Field..

It will solve your problem..

Regards

Sunil