topic Re: Chart Visual Cues / Calculation in QlikView

Chart Visual Cues / Calculation

Anonymous — Wed, 20 Apr 2016 11:07:52 GMT

Hi !

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

Re: Chart Visual Cues / Calculation

vikasmahajan — Wed, 20 Apr 2016 11:45:07 GMT

check this thread with my reply

https://community.qlik.com/message/458863#458863

Vikas

Re: Chart Visual Cues / Calculation

Anonymous — Wed, 20 Apr 2016 11:51:31 GMT

not sure you understod the problem.

look at the pictures, when i expand the table i want the calculated rows/cells to show grey, like in HM, UM and DIFF.

DIFF HM-UM, AVVIK HM, AVVIK UM are calculated rows.

Re: Chart Visual Cues / Calculation

kkkumar82 — Wed, 20 Apr 2016 11:56:00 GMT

If it is a straight table you can conditionally hide the column or if you want only the values in the column not to show then make the font and background color same conditionally

For the first , goto presentation tab

and for the second one goto the visual cues or + (background) in the expression tab

Re: Chart Visual Cues / Calculation

vikasmahajan — Wed, 20 Apr 2016 11:56:13 GMT

see attached file

Vikas

Re: Chart Visual Cues / Calculation

ThornOfCrowns — Wed, 20 Apr 2016 11:56:39 GMT

That's not easy to do, I think. I suggest you have a look at Dimensionality() and SecondaryDimentionality() as a start.

Re: Chart Visual Cues / Calculation

vikasmahajan — Wed, 20 Apr 2016 11:57:13 GMT

Re: Chart Visual Cues / Calculation

vikasmahajan — Wed, 20 Apr 2016 11:59:53 GMT

Background color you can give expression to get desired colors.

Thanks

Vikas

Re: Chart Visual Cues / Calculation

Anonymous — Wed, 20 Apr 2016 12:47:56 GMT

its a pivot table..

Re: Chart Visual Cues / Calculation

Anonymous — Wed, 20 Apr 2016 12:55:06 GMT

thank you for reply, but that not solved the problem..

When i expand the pivot table it gets messi, all the calculated rows.

I have grey'd out the cells with no value in it, i want the same for the calculated cells when the pivot table are expanded.

When the pivot table is collapsed it shows the right calculation and colour.

Re: Chart Visual Cues / Calculation

jonas_rezende — Wed, 20 Apr 2016 13:18:04 GMT

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.

Re: Chart Visual Cues / Calculation

vikasmahajan — Thu, 21 Apr 2016 04:54:13 GMT

Attach your sample please

Re: Chart Visual Cues / Calculation

Anonymous — Thu, 21 Apr 2016 06:05:09 GMT

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 ?

Re: Chart Visual Cues / Calculation

jonas_rezende — Thu, 21 Apr 2016 16:31:24 GMT

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!