Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner - Contributor II
Partner - Contributor II

Hide row in pivot table

Hi. I want to hide all rows in a column based on when a criteria is fulfilled.

In this example I want to show the rows only when:

Field: Company-salary-level is higher than 1,2*Market salary level.

I have seen some suggestions about set analysis but haven´t received correct output yet. 

 

Any suggestions on how to write it (or another approach) in order to only show the job positions with a salary-level higher than 1,2 times the market-salary level?

Labels (2)
1 Reply
Anil_Babu_Samineni

Perhaps this

If([Company-salary-level]>1 and [Company-salary-level]>(2*[Market salary level]), [Company-salary-level])

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