Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

Re: Hide row in pivot table

Perhaps this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)