Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)