Re: Chart Visual Cues / Calculation - 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?

vikasmahajan · ‎2016-04-20

check this thread with my reply

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

Vikas

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-20

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.

kkkumar82 · ‎2016-04-20

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

vikasmahajan · ‎2016-04-20

see attached file

Vikas

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.

ThornOfCrowns · ‎2016-04-20

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

vikasmahajan · ‎2016-04-20

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.

vikasmahajan · ‎2016-04-20

Background color you can give expression to get desired colors.

Thanks

Vikas

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-20

its a pivot table..

Anonymous · ‎2016-04-20

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.