MaxString() all values including Null with Aggr() function
Using Chart Object,
Dimensions: (Store, StoreName,Category)
Only Expression (using Aggr() function)
I have a table in QlikView and I am aggregating a column (Proposition) in that table based on all possible dimensions but the problem is that MaxString() function is not returning the Null values in that table.
MaxString is removing the Categories (Cubes and Noodles) as these two categories have no data, but i need them too.
Re: MaxString() all values including Null with Aggr() function
Sir, I have posted DataTable and Expression as sample and the actual problem is that it is not calculating NULL values in the Proposition column. All data and colunms are sample in this post as i can not post the actual data.