Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Creator
Creator

include null values not working in dynamic table

Hi
In this dynamic report (ad hoc report) there is a constant dimension - StoreID, and the other 2 dynamically change according to the user's selections in the upper filters (same with the measure)

aheavy95_1-1696850407455.png

 

each column is showed conditionally:  =SubStringCount(Concat([Float2.Num],'|'),01)

aheavy95_3-1696850968068.png

 

 

This is my measure: 

if( $(vFloatMeasure)>=  Max( total <StoreID> Aggr( $(vFloatMeasure),StoreID, $(vDimFloat2),$(vDynFloat1)) )-1,
     Max( total <StoreID> Aggr( $(vFloatMeasure),StoreID, $(vDimFloat2),$(vDynFloat1)) ),
     Null()
)

I'm showing the highest value per store, meaning one row only per store.
For some reason, although unchecked the "include nulls" checkbox, I still have rows with null values.
any idea how do I get rid of it?

 

Thanks 

aheavy95_2-1696850406938.png

 

Labels (6)
0 Replies