topic Re: Hierarchy listbox condition formating in QlikView

Hierarchy listbox condition formating

Thu, 19 Jun 2014 17:22:54 GMT

Hi all,

I've just started working with Qlikview, so sorry if the question is stupid.

I have a data with construction project stages (each stage may be subdivided on smaller stages) and need to show it in Hierarchy manner (n-level).

I created normal hierarchy in list box and for each stage added sum of "Budget cost", "Actual cost" and "% difference".

So the problem is that I need to highlight with the red color values of "% difference", when it becomes negative.

Is it possible to do and how?

Thanks in advance!

Any help is highly appreciated.

Regards,

Alex

Re: Hierarchy listbox condition formating

venkatg6759 — Thu, 19 Jun 2014 17:28:48 GMT

Go to the visual cues in the chart properties and add values in upper and lower and change the colour as you need

Re: Hierarchy listbox condition formating

Thu, 19 Jun 2014 18:38:45 GMT

I use not a Chart, but a List box (I understand that it is the only way to create hierarchy structure). Is there any visual cues for Expressions in the List box?