one solution could be:
table1: LOAD 'Region '&RecNo() as Region, 'Indicator '&IterNo() as Indicator, Pick(Ceil(Rand()*3),0,Ceil(Rand()*100)) as Value AutoGenerate 5 While IterNo() <= 10;
hope this helps
QlikCommunity_Thread_167643.qvw 159.8 K
The indicator which you are showing is not the only dimension I am having in the view and though the dimension consists of lower level fact id's which are actually null. So the dimension is a group of different fact_id's which are null in the database. And also there are not only region expressions in the view, there are expressions like total,prior,Prior week change%,12 week avg etc. So the zeros are not only causing due to region cut but also due to so many expressions divided.I want to find out among all these those zeros which are caused by the fact_id nulls in the database and grey them out.
Thanks in Advance.