Using visual cues in pivot table

[#1]

Hi,

I need to color the concepts in green which have green background for two consecutive columns (Ex: Headlamps)

and need to color the concepts in red which have red color font for two consecutive columns. (Ex: shutter speed, disk partitioning)

I have attached the pivot table, the dimensions, the expression used and the visual cues used.

Thanks in advance!

[#2]

That case let it be blank, since it has random pattern.

I want to specifically identify the best and worst cases.

and how do I do that ( previous month latest month thing ??)

[saumyashah90]

Check Value for Latest month and previous Month.

If(Latest Month(Value)<0) and PrevMonth(Value)>0,Green,red)

Depends how you want to take it

[#4]

what should be in value ?

[saumyashah90]

I guess you are taking me wrong

Latest Month is not a function it is a field name of the latest month which consist of the values

[#6]

I have no formal training in QV. Self learning mode.

Can you kindly type the expression based on my data and fields that I've used. Got the point but I'm not able to formulate it.

Looks easy but I'm unable to do it.

[saumyashah90]

okay no problem.

you need to tell me how are you getting these values or from where you are getting this

Apr1990 Jul1990 Oct1990

these columns?

[#8]

It is a dimension named Start_Period

[saumyashah90]

Okay and its format is MMM-YYYY ? or those are text ?

[#10]

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CONCEPT_TEMP:

LOAD MonthName(Start_Period) as Start_Period,

[saumyashah90]

Okay thats nice,

Can you Load

CONCEPT_TEMP:

Load Date(Start_Period,'MMM-YYYY') as Start_Period,

and where does the below values comes from? i.e 1,2,-4,-3 etc?