Get Free Trial
Get Free Trial

How to show row with empty columns values

Answered
Patrick TAVARIS asked on December 5, 2019

Hi,
I’ve a real use case on a flexmonster table where I have several rows with several columns ([Measures]).
Some of this rows (present in the dataset) are hidden on screen. It is all rows with “empty value” (or no value at all) for ALL the columns measured.
 
Here an example :
https://jsfiddle.net/euryhnmq/1/
 
The line “Toronto” has an empty “Quantity” value.
The line “Toronto2” has no column key “Quantity”.
As long as “Price” measure is displayed, we will see Toronto and Toronto2, with an empty cell for Quantity column.
But if I hide the “Price” measure (right click, “hide measure”), both “Toronto” and “Toronto2” lines are not displayed anymore, even if there are present in the datasource AND also in the “city filter”.
Is it an issue ? Or is there any “options” that let me display these kind of lines ?
 
 
 
Regards
 
Luc Bonnin

4 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 5, 2019

Hello, Patrick,
 
Thank you for reaching out to us.
 
Rows representing members “Toronto” and “Toronto2” are displayed until there is at least one not empty measure associated with them. In the example you have provided, the measure named “Price” is defined for “Toronto” and “Toronto2”, whereas the measure named “Quantity” is defined and not empty only for “Los Angeles”. That is why the component hides unused rows if you are hiding the “Price” measure.
 
You are welcome to contact us in case of additional questions.
 
Best Regards,
Illia

Public
Patrick TAVARIS December 5, 2019

Hi Illia,
Is there any option to display these “unused” rows ?
Because for example if we have several measures (price/VAT/…) with only one measure filled and all others not, this row won’t be considered as unused.
In our real use cases sometimes we have to display these unused rows to let the end user see “used rows” (with data) and those without (which is important for the end user and hiding them is to hard to distinguish if there are hundreds of lines).
 
Is there any option to display these “unused” rows ? (very important feature for us)

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 6, 2019

Hello,
 
Thank you for your feedback.
 
Your suggestion sounds reasonable; the described option will be provided with the minor update ETA Jan 13.
 
Our team will inform you when the version with a fix will be available to download.
 
Please, contact us in case of additional questions.
 
Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 4 days ago

Hello, Patrick,
 
We are glad to announce that the option grid.showEmptyValues to show members with empty values on the grid was added.
 
This is available in the 2.7.23 version of Flexmonster: https://www.flexmonster.com/release-notes/
 
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Please contact us in case any questions arise.
 
Best regards,
Illia

Please login or Register to Submit Answer