Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dimension Background Colour expression to ignore Fiscal Year and Month

Hi All

I have a straight table and all the Expressions ignore the Fiscal Year and Month if selected. I have also used an expression in the background colour of the Dimensions and this works fine UNTIL the user selects a year or month. I am sure I have to also ignore the FiscalYear and Month selections in this background colour expression but I cannot seem to get this in the right place? See examples below:

1 of the Expressions:

Max({<ItemActNowExcFromLookup={'0'}, ItemProductGroup-= {'EXPENSES', 'SERIAL', 'SERVICES'}, ItemBrand-={'FREIGHT', 'SERVICE'},FiscalYear=, Month=>}ItemUnitSellStore)

Background Colour Expression:

=If(ItemProductStatus= 'DELETED' 
and  ItemActNowWebsite= 'P',RGB(230,185,184),
If(ItemProductStatus= 'CURRENT' 
and  ItemActNowWebsite= 'P',RGB(230,185,184),
If(Dimensionality()=3, RGB(186,241,254),
White
())))

Thanks I have been searching the forum for days!

Karen

1 Solution

Accepted Solutions

Re: Dimension Background Colour expression to ignore Fiscal Year and Month

Try this:

=If(Only({<FiscalYear=, Month=>}ItemProductStatus)= 'DELETED' 
and Only({<FiscalYear=, Month=>} ItemActNowWebsite)= 'P',RGB(230,185,184),
If(Only({<FiscalYear=, Month=>}ItemProductStatus)= 'CURRENT' 
and  Only({<FiscalYear=, Month=>}ItemActNowWebsite)= 'P',RGB(230,185,184),
If(Dimensionality()=3, RGB(186,241,254),
White
())))


talk is cheap, supply exceeds demand
3 Replies

Re: Dimension Background Colour expression to ignore Fiscal Year and Month

Try this:

=If(Only({<FiscalYear=, Month=>}ItemProductStatus)= 'DELETED' 
and Only({<FiscalYear=, Month=>} ItemActNowWebsite)= 'P',RGB(230,185,184),
If(Only({<FiscalYear=, Month=>}ItemProductStatus)= 'CURRENT' 
and  Only({<FiscalYear=, Month=>}ItemActNowWebsite)= 'P',RGB(230,185,184),
If(Dimensionality()=3, RGB(186,241,254),
White
())))


talk is cheap, supply exceeds demand
Not applicable

Re: Dimension Background Colour expression to ignore Fiscal Year and Month

Thankyou for the quick response it worked perfectly!

oknotsen
Honored Contributor III

Re: Dimension Background Colour expression to ignore Fiscal Year and Month

If your question is now answered, please flag the Correct Answer.

If not, please make clear what part of this question you still like help with .

May you live in interesting times!
Community Browser