Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
cocalero
Creator
Creator

Display only Rows with values on all Expressions

Hello,

I would like to display only rows into the Straight Table where Values are presents in all Expressions:

Capture.PNG

How can i do that please ?

Thank you in advance for your help,

Sébastien.

19 Replies
swuehl
MVP
MVP

You can create a hidden expression t(labeled COND ) that checks that all expressions return something:

=Len(Trim( Only(FTE) )) AND Len(Trim( Only(Path) )) AND Len(Trim( Concat(Job) ))

adapt to your expressions used.

Then change all your existing expressions like

=If( "COND", YourCurrentExpression)

And enable 'suppress zero values' on presentation tab.

cocalero
Creator
Creator
Author

A Hidden Expression ?!?

How can i do that please ? 

swuehl
MVP
MVP

Basically create an expression on expression tab and set this expression column to hidden on presentation tab.

edit:

You can also do the same by repeating the conditional statement in each If() condition of each expression.

cocalero
Creator
Creator
Author

Sorry, but I do not see the option to hid the Expression 😕

swuehl
MVP
MVP

2016-06-16 18_57_16-Chart Properties [-].png

cocalero
Creator
Creator
Author

Ok, thanks for your help but do not see the Option:

Capture.PNG

Then, I write this for each Expression but it doesn't work:
If(Len(Trim( Only(Region) ))<>0,Region)

Do you have an idea please ?

swuehl
MVP
MVP

You don't see this option to hide the expression because you are using a pivot table chart, not a straight table chart.

But I think you should still be able to remove the lines where not all expressions return a value.

Could you post all your current expressions?

Or could you create a small sample QVW and upload this to the thread?

idogridish2
Creator II
Creator II

You can create a calculated dimension with an if statement that checks if all expressions returns a value,

and use the "suppress when value is null" on this field in dimensions tab.

how big is your model? and is it already slow? - you can try the solution and decide after.


best regards.


cocalero
Creator
Creator
Author

Ok, here my hidden expression:

"=Len(Trim(Only(Nom_DHACCOR))) <> 0 And Len(Trim(Only(Employee_CD))) <> 0 And Len(Trim(Only(Region))) <> 0 And Len(Trim(Only(Fte))) <> 0 and Len(Trim(Only(Path))) <> 0 and Len(Trim(Only(FTC_Nm))) <> 0"

And all my Expression here:

Capture.PNG

Thanks in advance for your help.

Sébastien.