Discussion board where members can get started with Qlik Sense.
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?
If([Company-salary-level]>1 and [Company-salary-level]>(2*[Market salary level]), [Company-salary-level])