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: 
sagnikrana
Partner - Contributor II
Partner - Contributor II

Removing selected rows from pivot table

Hello Everyone,

Can anyone help me to remove few of the rows from the pivot table ? The table looks like this:

 

Screen Shot 2020-04-06 at 3.45.28 PM.png

 

I want to remove all the rows from the measure which has "There are no further subtasks" for the selected item.

Appreciate your time!

 

Thanks,

Sagnik

 

Labels (1)
  • Chart

1 Reply
Anil_Babu_Samineni

You need to write dimension like

If(name2<>'There are no further subtasks', name2)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful