Re: Chart Visual Cues / Calculation - Page 2 - Qlik Community

Anonymous · ‎2016-04-20

Hi !

When i expand the table, i want the cells that are markd red to not show any calculated value. Is this possible?

jonas_rezende · ‎2016-04-20

Hi, Marius August Larsen.

Do you have some metric that must be shown gray or other color? Example:

>=60000 = color white;

>= 100 and <60000 gray;

Regards,

Jonas Melo.

vikasmahajan · ‎2016-04-21

Attach your sample please

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2016-04-21

When the pivot table is collapsed, everything is okey.

when i expand the table, it gets messi.

The values in DIFF-HM-UM and avvik avr hm are calculated values from HM, UM and diff.
i want the red calculated values to show grey when i expand the pivot table.

If there are none values in HM AND UM to calculate with, show grey. How can i implimantate this in my qv application ?

jonas_rezende · ‎2016-04-21

Hi, Marius August Larsen.

Try:

In background color of expression DIFF-HM-UM. Ex.:

if(above(HM,0)>0, RGB(192,192,192), Red()) //If you need, use Dimensionality().

Case solve your problem, adapt for your necessity.

Hope this helps!