Display all value is disabled

[sergio0592]

Hi all,

I have a chart with DT_MM field, i check 'Show all values' in dimension propertie. But, in order to make an ascending sort (01/01 to 31/12), i use date#(TEMPS_DT_MM,'DD/MM').

The sort is OK, but now i cant' check  'Show all values' anymore. How to resolve this?

Regards

[avinashelite]

I think for the calculated dimension this  option will be  disabled

[avinashelite]

You need to make the changes in the script and then use the same in the chart , this will allow you to use the show all values option

[adamdavi3s · Accepted solution]

Have you tried having your dimension as just your field name then sorting the dimension by using something like:

=only({1}date#(TEMPS_DT_MM,'DD/MM'))

Just thinking out loud, not sure if it will work!

[sergio0592]

Indeed, it's not available for calculated dimension. I'll try to make it in script.

[sergio0592]

Thanks Adam, it works with sort as expression. But i don't understand why it works with only function. Could you explain?

[adamdavi3s]

The use of Only() just means you can use set analysis e.g. in this case {1} to exclude everything from the sort, its a handy trick I use frequently for sorting

[avinashelite]

But use of only() function doesn't enable you the Show all values option rite ?

Your getting all the values from {1} this option

[adamdavi3s]

We're not using the only() in the dimension here, just in the sort which means you can use the original dimension value which then enables the show all values again.

The only purpose of the only function is to enable you to use set and ensure the sort expression isn't affected by any selections

[sergio0592]

Use of only don't allow to select 'Show all values' in dimension propertie. But, i put the expression given by Adam not here but in Sort Tab/ Sort by expression