Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi !
When i expand the table, i want the cells that are markd red to not show any calculated value. Is this possible?
check this thread with my reply
https://community.qlik.com/message/458863#458863
Vikas
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.
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
see attached file
Vikas
That's not easy to do, I think. I suggest you have a look at Dimensionality() and SecondaryDimentionality() as a start.
Background color you can give expression to get desired colors.
Thanks
Vikas
its a pivot table..
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.