Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Partner

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
balabhaskarqlik

May be you can add one more dimension or measure.

After that, try an expression like:

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