Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
BouwerVa
Contributor II
Contributor II

Conditional Visibility

Hi

I created a Pivot Table.

But I only want to show the Rows in red.

Any Suggestions:

Loan @.png

 

Labels (1)
1 Solution

Accepted Solutions
JordyWegman
Partner
Partner

Hi,

Use the conditional coloring code also for your measures. But instead or returning LightRed(), return null(). Then you should go to Data Handling in your pivot table properties and disable include null values.

Jordy

Climber

Work smarter, not harder

View solution in original post

2 Replies
JordyWegman
Partner
Partner

Hi,

Use the conditional coloring code also for your measures. But instead or returning LightRed(), return null(). Then you should go to Data Handling in your pivot table properties and disable include null values.

Jordy

Climber

Work smarter, not harder

View solution in original post

BouwerVa
Contributor II
Contributor II
Author

It Worked somewhat but it still will not hide the null values.

Capture.JPG

 

  • "Include Null Values" is unticked in all Dimensions
  • My Loan at's Formula : 
    • if(sum(if(TTYPE ='Lo',1)) > 3, sum(if(TTYPE ='Lo',1)), Null())
  • My Loans Granted Formula:
    • if(sum(if(TTYPE ='Lo',1)) > 3, sum(if(TTYPE = 'Lo', CAPITAL)), Null())

Not sure what I'm doing wrong