Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem PivotTable-Graph still creating lines even if all expressions are Null

Hello,

I'm having a pivot table that calculates all of it expressions with SetAnalysis.

Create a weekrank and also a last-week-rank.

All expressions are working, the data is correct and if the data should show nothign a Null() is generated.

But still it show all records for the dimension. The flag Suppress when null is On.

5 Replies
Not applicable
Author

This is a example of an expression

=IF(SUM({<[ZZSYS_COUC_YWEEK]={"$(Dash_SelWeek)"} >} [Performance Tickets])>0, SUM({<[ZZSYS_COUC_YWEEK]={"<=$(Dash_SelWeek)"} >} [Performance Tickets]), Null())



Not applicable
Author

Noboddy has a clue ??

Not applicable
Author

All columns are empty?

for if I can help: I usually write the expression like this >> sum (if (value> 40, sales, 0))

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Do you have "show all values" on in the Dimension?

-Rob

Not applicable
Author

No, is not flagged, the Suppress When value is nill is flagged