Selective response for a subset of values

[#1]

Hello,

I am working on the below dataset:

Year	Month	Month_Week	Manufacturer	Model_NM	ZFor_Run1	ZFor_Run2
2014
2015

I have data from Dec,2014 to June,2015 week wise. The data for ZFor_Run1 and ZFor_Run2 is 0 for all months except for Jun 2016.

I have the following chart:

Dimensions:

Month_Week,

=Aggr( If(Rank(Sum({1}Units_Sold))<=5,Model_Name),Model_Name)

Expressions:

=sum(ZFor_Run1)

=sum(ZFor_Run2)

Since there is no data for any weeks except for those of June,2016, I get 'No data to Display' message on the chart whenever I select any month or week other than those of June,2016. Same happens when i select any Manufacturer other that that of the Top 5 models displayed.

The way I want it to work is the data should change if I select any week/month of June,2016 (i.e. having non-zero data), but should remain constant (i.e. showing data for weeks with non-zero data) if some other week/month values are selected. Similar operation for selection of Manufacturers other than those for the Top 5 models displayed.

Please suggest.

Thanks in advance.

[jonas_rezende]

Hi, Tejas Kumbhar.

Could you share the qvw?

Regards,

Jonas Melo.

[#3]

jonas.rezende  A bit new to the community, could you tell me how I would do that ?

Did not find an option to upload in this reply section.

[jonas_rezende]

Hi, Tejas Kuymbhar.

Click on the upper right side, will appear in your language.

The next step is to click the clips, bottom right side and choice the file.

[#5]

Thanks Jonas,

Please check the attached file.

[jonas_rezende]

Hi, Tejas Kumbhar.

In the Model dimension checkbox is marked like Suppress When Value is Null. So, when the condition is equal false, the value no appears.

The option was unmarked (checkbox) and I inserted the word 'Others' in else condition. Verify if solves your necessity. Otherwise, it will give you an idea.

Ex.:

Aggr( If(Rank(Sum({1}Units_Sold))<=5,Model_Name,'Others'),Model_Name).

Test the example attached.

I hope this helps!