Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Can someone help me,
1)
How do I hide the months and year (Expression) Apr-2012, May-2012, Jun-2012 titles onwards but still keep the data split by month, but still have the ability to qlik on the year
2) How do I hide the word "Time" highlighted in Bold which is also an expression
But I would like to achieve is:
Can anyone help me
Thanks
Helen
hi helen ,
On presentation tab there is an option of suppress header.
Deepak
Hi
To remove "Time" goto properties -> Dimensions -> select the dimensions -> Label -> give one space.
Even though the Label part is not enabled you can give the label.
Hope this helps to fix 2 point.
Regards
Krishna S
Hello
Thank you for responses
I am unfortunately unable to find suppress header on the presentation tab of the pivot table
Are you able to provide further assistance?
I am looking to suppress Apr-2012, May 2012, Jun 2012 onwards
Thanks
Helen
Hi
Make the font color of the Dimensions Label to white.
Object Properties -> Dimensions -> Click on the + sign of the MonthYear Dimension -> Double Click the Text Color -> type =RGB(255,255,255) .
Hope this helps
Regards
Krishna S
Hi,
Please referred to below attached image.hope its help for u.
Inside both Text and Background using the white color = RGB('255','255','255')
Iyyappan.