Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ECEK
Contributor
Contributor

hide rows in a column

hello, how can I hide different rows in a column.

I have a sheet that have a column with 33 questions.. 
I want to answer only 3 of them and hide the rest of the questions,. how to do that?

Labels (2)
5 Replies
Mark_Little
Luminary
Luminary

Can you share an example of the data. 

Probably just need to add an expression or an expression  to your dimension. But not knowing your data can't advise anymore than that 

ECEK
Contributor
Contributor
Author

ECEK_1-1698995832881.png

 

I want in Column A, if Names = Joe, then Hide row and only keep Laila's rows..

 

ECEK
Contributor
Contributor
Author

Yes, Its true that I want to write an expression but I need some help to know what is the expression

thank you in advance.

Best regards,

😄

G3S
Creator III
Creator III

for this example, replace dimension Names with:
=if(Names='Joe',null(),Names)

then clear the tick from show/include null values checkbox.

Gabbar
Specialist
Specialist

Suppose you have a table with Dimension D1 and measure M1, D1 values are 1,2,3 and you want to hide 2.

and you M1 expression normally is Sum(M1)
Then you can use in M1:-
Sum({<D1 = {'1','3'}>}M1)    or you can also use      Sum({<D1-={'2'}>}M1)   , you will need to do this for every measure.

Else you can also change you dimension caluclation using aggr,
Use this expression as dimension rather than using D1,
Aggr(Only({<D1={'1','3'}>}D1),D1)   or    Aggr(Only({<D1={'2'}>}D1),D1)   and then select dont include null values.