topic Re: Display all value is disabled in QlikView

Display all value is disabled

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Display all value is disabled

avinashelite — Wed, 08 Feb 2017 13:51:29 GMT

I think for the calculated dimension this option will be disabled

Re: Display all value is disabled

avinashelite — Wed, 08 Feb 2017 13:52:23 GMT

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

Re: Display all value is disabled

adamdavi3s — Wed, 08 Feb 2017 13:57:33 GMT

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!

Re: Display all value is disabled

sergio0592 — Wed, 08 Feb 2017 14:04:40 GMT

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

Re: Display all value is disabled

sergio0592 — Wed, 08 Feb 2017 14:20:39 GMT

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

Re: Display all value is disabled

adamdavi3s — Wed, 08 Feb 2017 14:23:40 GMT

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

Re: Display all value is disabled

avinashelite — Wed, 08 Feb 2017 14:28:57 GMT

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

Your getting all the values from {1} this option

Re: Display all value is disabled

adamdavi3s — Wed, 08 Feb 2017 14:33:27 GMT

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

Re: Display all value is disabled

sergio0592 — Wed, 08 Feb 2017 14:34:58 GMT

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

Re: Display all value is disabled

avinashelite — Wed, 08 Feb 2017 14:43:06 GMT

OK got it !