Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Chart Visual Cues / Calculation

Hi !

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

Tags (2)
13 Replies
Highlighted
Champion
Champion

Re: Chart Visual Cues / Calculation

check this thread with my reply

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

Vikas

Highlighted
Creator II
Creator II

Re: Chart Visual Cues / Calculation

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.

Highlighted
Specialist III
Specialist III

Re: Chart Visual Cues / Calculation

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

Highlighted
Champion
Champion

Re: Chart Visual Cues / Calculation

see attached file

Vikas

Highlighted
Specialist II
Specialist II

Re: Chart Visual Cues / Calculation

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

Highlighted
Champion
Champion

Re: Chart Visual Cues / Calculation

Highlighted
Champion
Champion

Re: Chart Visual Cues / Calculation

Background color you can give expression to get desired colors.

Thanks

Vikas

Highlighted
Creator II
Creator II

Re: Chart Visual Cues / Calculation

its a pivot table..

Highlighted
Creator II
Creator II

Re: Chart Visual Cues / Calculation

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.