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]

Hi Maxim Senin,

Thanks for the suggestion.

But it won't give me the correct value for that particular month.

Regards,

Anjali Gupta

[Digvijay_Singh]

Can you see this attached sample and suggest what exactly you need in this -

[Digvijay_Singh]

I had to change the order of mapping data as field2 needs to be a look up to associate field1 with second table. Not sure if I did the right thing

[#5]

Hi Digvijay Singh,

Thanks for the sample qvw.

I have made the Field1 as always one selected.

Now you can help me get all the months on the line chart.

Based on the year selection. It would be great.

Regards,

Anjali Gupta

[Digvijay_Singh · Accepted solution]

I think this is what you want, see the attached one -

[Digvijay_Singh]

Since you have always one selected value in field1, you cannot select unassociated year( as per data model)  with your selected Field1 value . It won't allow you to select year to respect association defined in the data model.

[#8]

Thanks Digvijay Singh for the help.

Regards,

Anjali Gupta

[#9]

Hi Digvijay,

Is there a way to show the months or line chart with value 1 where there is no data. Not in any year.

Regards,

Anjali Gupta

[Digvijay_Singh]

Can you share the modified sample data to see the possibilities. The current data has values for 2015,and 16 where available months are showing calculated values and absent months are showing 1. Now I need to understand how you can have other years 2014 or 17 with no data against any month.