Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
user467341
Creator II
Creator II

Removing data row based on condition

Hi all,

I have created a pivot table, as an example below:

user467341_1-1675035500902.png

I will need to remove the data where the "Level" has "Out" (as you can see, work A is duplicated in price because of the "Out").

I tried the set expression:

=Aggr(Only({<Level-={"Out"}>} Level), Level)

But the result is this:

user467341_2-1675035635354.png

The "Out" is removed, but the data row remains.

I need the end result to be:

user467341_3-1675035703346.png

 

Any help or advice on this is greatly appreciated. Thank you.

Labels (2)
5 Replies
vinieme12
Champion III
Champion III

on the Level Dimension uncheck Include Null Values

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
user467341
Creator II
Creator II
Author

Hi, if I do that then my work "C" will also be gone. Please see my end result table...

 

Thank you.

ogster1974
Partner - Master II
Partner - Master II

add your set analysis

{<Level-={"Out"}>}

to Price instead

user467341
Creator II
Creator II
Author

Hi it does not seems to work.

 

My price has a formula using SUM(X) in set analysis.

ogster1974
Partner - Master II
Partner - Master II

 

{<Level-={'Out'}>}

Works for me

ogster1974_0-1675433398510.png