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

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

Fri, 12 Mar 2010 15:03:29 GMT

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.

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

Fri, 12 Mar 2010 15:47:39 GMT

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())

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

Tue, 16 Mar 2010 07:37:45 GMT

Noboddy has a clue ??

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

Tue, 16 Mar 2010 08:28:32 GMT

All columns are empty?

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

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

rwunderlich — Wed, 17 Mar 2010 08:46:48 GMT

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

-Rob

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

Wed, 17 Mar 2010 13:51:40 GMT

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