Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Appearance of columncontent on depending on selection of dimension

Hi Folks,

i am facing with the following situation (please see attached screenshot).

is that possible to make visible the content of column if i select the certain dimension. for instance: my pivot table consists of 3 Dimension: Projectmanager, Project, Costcenter,and if i select Dimension: Project i want see the column: Comments only for Dimension: Project.

is that possible? Does have anybody any idea?

Thanks a lot

Beck

example.PNG

4 Replies
dan_sullivan
Creator II
Creator II

could you use a formula to color code the comments white if the conditions were not met to artificially hide them from being visible?

beck_bakytbek
Master
Master
Author

i dont see your point, what do you mean with "formula to color code"

dan_sullivan
Creator II
Creator II

within a pivot table you have the option to change the color of the text.  so write a formula that will make the color of text white until the user selects a project.

example:   if(GetFieldSelections(project)=0,White(),Blue())

beck_bakytbek
Master
Master
Author

Hi Dan,

first of all thanks a lot for your feedback, in my case i am facing with problem of appearance of content of column not of color of column. i.e: if i select dimension: Project i want only see the column: comment. in pivot table if i select any dimension, the pivot tables shows me always the column: comment. i try to create the dependence between dim: Project and Column: Comment. i hope, i explained well.

Thanks a lot

Beck