Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide Column based on Expression

Hi,

I have a table as below with record type as dimension.. I need to hide the rows which have no issue and display only the once with the issue. How can I achieve this.

Capture.PNG

Thanks in advance

15 Replies
Not applicable
Author

Sure will do.. Might take some time though.. thank you so much for your help..

Not applicable
Author

Anonymous
Not applicable
Author

Hi Mohan,

Try with Set Analisys, YourIssueField -= {'No Issue'}

Regards!!

ecolomer
Master II
Master II

Anonymous
Not applicable
Author

Hi Mohan,

I usually use a workaround method for this and that is using the same condition in all expressions.

In you case

if(Issue<>'No Issue', DM)

if(Issue<>'No Issue', Oats)

if(Issue<>'No Issue', DM-Oats)

if(Issue<>'No Issue', Issue)


Hope this helps.


Laxmi

Not applicable
Author

Thanks every on for the reply...

Laxmi It's Working,Awesome....Thanks a lot