Conditional Line Style not working when >1 Expressions Enabled

[#1]

Hi,

I have a chart with two expressions,one for 2016, one for 2017 (and possibly more will be added later). Both expressions use the same Metric, [Gross Value of Sales]. The expressions have line style set to:

If([Week_Commencing]>vThisWeek,'<s3>','<s1>')

so that if the data displayed is for a week greater than the date the qvw was last reloaded (ie it's a forecast), then the line style will be dashed, not solid.

In addition, each expression is conditional on whether that year is selected in a list box, using respectively:

GetFieldSelections(WSSI_Year)like '*2016*'

GetFieldSelections(WSSI_Year)like '*2017*'

MY ISSUE:

if only one year is selected, in the list box, the line style works as intended. If both years are selected at the same time, both years display, but both with their lines all solid (<s1>). Note that data was last reloaded Week 46, 2016

Any help/ideas much appreciated

[#2]

Hi Sunny, screenshot is attached.

The first columns is Week(Week_Commencing)-1 as a dimension, the 5th is as an expression. Ignore the fact that there's a column for 2017 Forecast - as explained before, the 2017 column is actual values, until the 2nd week (or as far as we have them), and then becomes Forecasts. Again, your help on this is very much appreciated.

[sunny_talwar · Accepted solution]

So you basically have 1 dimension (week) and three expressions, right? and you are using the same line style expression for all three of them?

If([Week_Commencing]>vThisWeek,'<s3>','<s1>')

I am not sure what your expression for each of the year is, but you need to use same set analysis in your line style expression

2016

If(Only({<SetAnalysis4m2016Exp>}[Week_Commencing]) > vThisWeek, '<s3>', '<s1>')

2017

If(Only({<SetAnalysis4m2017Exp>}[Week_Commencing]) > vThisWeek, '<s3>', '<s1>')

2017Forecast

If(Only({<SetAnalysis4m2017ForecExp>}[Week_Commencing]) > vThisWeek, '<s3>', '<s1>')

[#4]

Thought it'd be something along those lines. Many thanks Sunny.