Ignore selections on dimension

[#1]

Hi All,

I have data from January 2015 to April 2016

I have created a line chart with different months and want to show all the months available irrespective of any selection except Year.

Dimesnsion : Month

Expression : If(Isnull(1-(Column1/Column2)),1,(1-(Column1/Column2)))

Case 1: If I select Year as 2015, I want to show all months(Jan - Dec) irrespective of any selection

Case 2 : If I select Year as 2016, I want to show only 4 Months (Jan - April) irrespective of any selection

on the dimension.

PS : Show all values will fail for Case 2 as it will show all the months and not only 4.

Also, there are no values for some Month - Year. Where it should display 1 as per the expression.

Regards,

Anjali Gupta

[#2]

Can you please help me on creating the dummy dimension?

If you can tell me step by step, it would be great.

Regards,

Anjali gupta

[vikramv]

I guess you can use this directly in for Month dimension without any dummy field

if( GetFieldSelections(Year) = '2016' and Match(Month,1,2,3,4), Month,Month)

[sunny_talwar]

So regardless of selection in Field1, you want to see all these 7 UniqueID on your chart?

[#5]

No Sunny, I want regardless of any selection the dimension should change.

Apologies on missing sum() in expression

The correct expression is  if(Isnull(1-(sum(Column1)/Sum(Column2))),1,(1-(sum(Column1)/Sum(Column2)))

I want to calculate this for each Field1

for E,F,G,I,J and K of Field1 it should be 1 for all the months.

Regards,

Anjali Gupta

[#6]

Hi Vikram,

This is also not working for me.

Regards,

Anjali Gupta

[sunny_talwar]

No Sunny, I want regardless of any selection the dimension should change.

Not sure I understand this statement? Did you miss a 'NOT' here?

[ziadm]

Hi

if you have made a master calendar having the max date as of last Date in your fact Table and Min Date is the starting Date of you data, then selecting Year 2016 will give you only up to current months as your dimension. 

I am not sure why you have make changes to the chart set analysis

[maksim_senin]

Hi,

Why not to use set analisys? E.g. Sum({<Month=,Week=,Date=>} Amount) will ignore selection in Month, Week and Date fields.

Best regards,

Maxim

[#10]

Yes I missed it.

I want regardless of any selection, the dimension should  not change.

Regards,

Anjali Gupta

[#11]

Yes, you are correct that on selection it gives me a particular month. But it misses the month where there is No Data.

Example:

If I have data for May, Aug and Nov

It will show only these 3 months in the chart and not all the 12 months for 2015.

If I make it show All Values.

It will show all months for 2016. But for 2016 I want wants till the Max Date.

i.e Jan, Feb, Mar and Apr.

Regards,

Anjali Gupta