topic Re: how to show missing nulls and zero values for all branches? in QlikView https://community.qlik.com/t5/QlikView/how-to-show-missing-nulls-and-zero-values-for-all-branches/m-p/1069600#M357401 <HTML><HEAD></HEAD><BODY><P>hi try dis,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">) In Dimension make sure that suppress null values is unchecked for ur dimens.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2) try this expression - Alt(YourExpression,0)</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">3) In presentation tab uncheck Suppress zero value</P><P></P><P>and chk dis below link</P><P></P><P><A href="https://community.qlik.com/thread/164540">How to create static dimension in pivot table</A></P></BODY></HTML> Fri, 19 Feb 2016 10:06:03 GMT Chanty4u 2016-02-19T10:06:03Z how to show missing nulls and zero values for all branches? https://community.qlik.com/t5/QlikView/how-to-show-missing-nulls-and-zero-values-for-all-branches/m-p/1069599#M357400 <HTML><HEAD></HEAD><BODY><P>Hi everyone i had report which consists of two products data and for those things i taken dimension as branch, and taken suppress nulls,etc in my pivot table report. the problem is for some branches i don't one product values but for other product i have, but the for two products on particular date it's showing those branches just because it's not there in one category products.</P><P></P><P>So, how can i display all branches and for missing products i need to show zero's, how can i do that?</P></BODY></HTML> Fri, 19 Feb 2016 05:21:46 GMT https://community.qlik.com/t5/QlikView/how-to-show-missing-nulls-and-zero-values-for-all-branches/m-p/1069599#M357400 2016-02-19T05:21:46Z Re: how to show missing nulls and zero values for all branches? https://community.qlik.com/t5/QlikView/how-to-show-missing-nulls-and-zero-values-for-all-branches/m-p/1069600#M357401 <HTML><HEAD></HEAD><BODY><P>hi try dis,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">) In Dimension make sure that suppress null values is unchecked for ur dimens.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2) try this expression - Alt(YourExpression,0)</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">3) In presentation tab uncheck Suppress zero value</P><P></P><P>and chk dis below link</P><P></P><P><A href="https://community.qlik.com/thread/164540">How to create static dimension in pivot table</A></P></BODY></HTML> Fri, 19 Feb 2016 10:06:03 GMT https://community.qlik.com/t5/QlikView/how-to-show-missing-nulls-and-zero-values-for-all-branches/m-p/1069600#M357401 Chanty4u 2016-02-19T10:06:03Z