Remove Empty rows from pivot table

[bhavyad]

NEw to qliksense, I am trying to build the hierarchy, I do not want the empty rows should be shown.

Could someone help me in this.

Note: tried unchecking include null values in the data handling as well as in the dimension

[bhavyad]

I haven't done anything...just created the pivot table with dimension and measure..

In the screenshot ,it is showing the level of hierarchy in the organisation and last row should always show the username and here i have not added yet

[BrunPierre]

Please share qlik document (.qvf file) it will help a lot.

[Hania]

Hii,

this logic is not for remove empty rows from table ,

it's for hiding row in table.

You can use following code in your table (in the expression of your dimension field )

IF(not Match(Dimension_field,'field want to hide',0),Dimension_field)  ,

above is the syntax for hiding row , you can use your field in syntax.

hope this will help for you!

[bhavyad]

yes I want to hide the row, which has nthn in it...

where Am I supposed to enter the expression,

My data editor page is blank, I am just attaching the csv file directly

[Hania]

if possible can you share .qvf file.

[bhavyad]

Its just the CSV file I have now, I would not be able to share the info here

[bhavyad]

@Brun and Hania, I have attached the sample data....

I am looking for the output like...Tier 1 to tier 12 and the user mail id...in pivot table
However , if no info any any of the Tiers should hide the row and show at the end of the heirarchy an email id

[bhavyad]

Any suggestion please

[BrunPierre]

Could you clarify the output?

[bhavyad]

In the below screenshot,i want the blank rows to be hidden .

First screenshot only till tier 6 the rows should be there and the email id

and for second screenshot till 8th row it should show and then email id