Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can anyone help me with the following.
i need to display/highlight only those Name in my report where flag is gray for two consecutive months(date col).
(till now only jan, Feb data is loaded. )
SNO | Date | Name | Flag |
1 | 20130117 | del | Gray |
2 | 20130117 | p099 | Gray |
3 | 20130117 | plm099 | Green |
4 | 20130117 | f044 | Gray |
5 | 20130117 | d100 | Gray |
6 | 20130213 | del | Gray |
7 | 20130213 | p099 | Gray |
8 | 20130213 | plm099 | Gray |
9 | 20130213 | f044 | Green |
10 | 20130213 | d100 | Gray |
thanks
Leo
See attached example
Hi Gysbert,
thanx for you reply it was helpful. however i need some more help with a similar but more complex problem.
i recieve a excel data on monthly basis the sheet looks like the following.(only col in use are shown here)
jan data
20130117 | |||
Name | Flag1 | Flag2 | Flag2 |
del | Gray | Green | Green |
p099 | Gray | Green | Green |
plm099 | Green | Gray | Green |
f044 | Green | Gray | Gray |
d100 | Green | Gray | Green |
Feb Data
20130201 | |||
Name | Flag1 | Flag2 | Flag3 |
del | Gray | Gray | Gray |
p099 | Gray | Gray | Gray |
plm099 | Green | Green | Green |
f044 | Gray | Gray | Gray |
d100 | Gray | Green | Gray |
now i need to show only the latest in the dashboard the latest data i.e. data from feb file. But i need to highlight those flag values that are gray in both files. the dashboard op can be like
note: number of rows in each file can be more than 1000.
data is recieved monthly once
See attached qvw
edit: All the dimensions also have a Background Color expression defined. On the Dimension tab of the properties window click on the + sign in front of a dimension. Select Background Color and the click the Edit button.
Thanx
Hi Gysbert,
In this solution how did you manage to highlight the whole row on the basis of one row? (Rows highlighted in green)
Leo