Displaying values in a straight table on certain selection

[#1]

Hi,

I have a requirement wherein I have to display the metric names,status1,status2 and sales in a chart wherein status1 and status2 must appear as images.I have acheived this,but the issue is that the chart is not providing the summarised view of the data.i.e.,

In my application i have four Metrics A,B,C,D and thus i would want to see only four rows in my chart,one for each metric name, with status1 and status2 displaying null value when no selection is being made on year and month, and once the selection is made on the year and month i would want the chart to display the values for Status1 and status2.Can anyone please help acheive this

I have also attached the sample application

[kaushiknsolanki]

Hi,

    Have a look at the application.

Regards,

Kaushik Solanki

[sasikanth]

HI anu

Kaushik Solanki`s example is perfect ,

if you want to enable the status,status2 based on only My_date field.. Then use

enable condition as GetSelectedCount(My_data)>0.

[#4]

Hi Kaushik,

In the application put up, you have made the columns status1 and status2 to appear only when month is selected.But I would want to display the columns status1 and status2 even when the month is not selected.But it must be having Null Values (i.e., '-') when no values are selected.Can you please let me know how this could be acheived.

[kaushiknsolanki · Accepted solution]

Hi,

     Write the calculated expression as

=if(isnull(GetCurrentSelections()),Null(),

if(Status='GREEN','qmem://<bundled>/BuiltIn/led_g.png',

if(Status='RED','qmem://<bundled>/BuiltIn/led_r.png',

if(Status='YELLOW','qmem://<bundled>/BuiltIn/led_y.png'))))

     And remove the Enable condition.

Regards,

Kaushik Solanki