topic Re: Highlighting the dimension when date or value is selected. in QlikView

Highlighting the dimension when date or value is selected.

Mon, 28 Apr 2014 08:58:21 GMT

Hi there

Need some help getting the footer of the dimension highlighted ( '<B>' ), i have manage the get the bars highlighted when i selected one of the value in the listbox.

I use this expression for the bars

if(isnull(only(Bruger)),ARGB(255,141, 170, 203) ,if($(Formula)) > 0, red(),if($(Formula)) < 0, Green())

Thanks

Teis

Re: Highlighting the dimension when date or value is selected.

Mon, 28 Apr 2014 09:10:27 GMT

Hi Teis,

start from there:

http://community.qlik.com/thread/114441

Unfortunetely i'am afraid, that we cant use there calculated color

Some workaround will be to generate own x-axis values.

You may use another chart (table) with those values. But this may be difficult to manage on the screen.

For me better solution is to use technique like here:

http://community.qlik.com/message/514275#514275

regards

Darek

Re: Highlighting the dimension when date or value is selected.

whiteline — Mon, 28 Apr 2014 09:27:27 GMT

Hi.

Have you tried something like this as 'Text format' expression for that dimension ?

if(isnull(only(Bruger)), null() , '<B>')

Re: Highlighting the dimension when date or value is selected.

Mon, 28 Apr 2014 09:46:57 GMT

Hi and thanks for fast reply

Yes I have tried exactly the same expression as you suggest and it does not seem to work -

should it?

Re: Highlighting the dimension when date or value is selected.

whiteline — Mon, 28 Apr 2014 15:16:24 GMT

Hi.

If the simple expression ='<B>' doesn't work then it's a chart/client/version limitation.