Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
arvindjha2050
Creator
Creator

Custom Color By Dynamic Dimension

Hello Team,

I have a below situation.

Dimension : Last 8 quarters

Measure : Total Sales

I would like to have custom colors(By expression) for my last 7 quarters.

The last 7 quarters will be dynamic as per Today's date.

For instance as of today's date , quarter will start from 1st January 2017.

So Q1-2017 will have a rgb(),

Q2-2017 will have different rgb value so on and so forth

Thanks & Regards,

Arvind

7 Replies
vishweshwarisun
Partner - Creator
Partner - Creator

hi,

In the custom colour expression you will have to write the if Condition

=If(Quarter='Q1',rgb(),

If(Quarter='Q2',rgb())) an so on

prashantsanchet
Creator
Creator

Hi,

What is the field name of Dimension for Quarter and what are the values inside it ?

Does it calculated dimension ?

Regards,

Prashant

arvindjha2050
Creator
Creator
Author

Hello Sunketa,

The Quarter is not fixed, last 8 quarters will continuously change with time hence we cannot put static values, hence this will not work.

Thanks

arvindjha2050
Creator
Creator
Author

Hello Prashant,

Yes it's a calculated dimension.

'FY'& fYear&'-'&FQuarter

Thanks

arvindjha2050
Creator
Creator
Author

The values are like :

FY2017-Q2

Anil_Babu_Samineni

For sure it is possible to use Master Items with custom colors for last 8 Quarters.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
balabhaskarqlik

May be you can add one more dimension or measure.

After that, try an expression like:

Count({$<Cust_Lost={"1"}>} distinct Customer)