topic Show all fields in a calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851906#M298737 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a calculated dimension in a table. That dimension has about 10 types but only want to show a table 5 .</P><P>If i have no data of any of those 5 then don´t show that field and if i check the option to show all the values ​​shown me the 10 types of dimension.</P><P>How I can do to show that 5 ?</P><P></P><P>Thanks ! </P></BODY></HTML> Tue, 09 Jun 2015 05:44:35 GMT 2015-06-09T05:44:35Z Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851906#M298737 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a calculated dimension in a table. That dimension has about 10 types but only want to show a table 5 .</P><P>If i have no data of any of those 5 then don´t show that field and if i check the option to show all the values ​​shown me the 10 types of dimension.</P><P>How I can do to show that 5 ?</P><P></P><P>Thanks ! </P></BODY></HTML> Tue, 09 Jun 2015 05:44:35 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851906#M298737 2015-06-09T05:44:35Z Re: Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851907#M298738 <HTML><HEAD></HEAD><BODY><P>If they are sortable, then you could use dimension limits and select Top 5.</P></BODY></HTML> Tue, 09 Jun 2015 05:53:24 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851907#M298738 jonathandienst 2015-06-09T05:53:24Z Re: Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851908#M298739 <HTML><HEAD></HEAD><BODY><P>The problem is:</P><P>DIMENSION - PEOPLE</P><P></P><P>PEOPLE</P><P>A,B,C,D,E,F</P><P></P><P></P><P>PEOPLE - MONEY</P><P>A - 5</P><P>B - 6</P><P>C - 7</P><P></P><P>If D - 0 not included in my table and i want to show all the values</P></BODY></HTML> Tue, 09 Jun 2015 06:14:49 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851908#M298739 2015-06-09T06:14:49Z Re: Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851909#M298740 <HTML><HEAD></HEAD><BODY><P>Populate missing values in the script. And then uncheck 'Supress zero values' in the presentation tab?</P></BODY></HTML> Tue, 09 Jun 2015 06:26:09 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851909#M298740 tresB 2015-06-09T06:26:09Z Re: Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851910#M298741 <HTML><HEAD></HEAD><BODY><P>Assuming your expression is something like Sum(Money), then turn off Suppress Zero Values on the Properties | Presentation.</P></BODY></HTML> Tue, 09 Jun 2015 06:27:55 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851910#M298741 jonathandienst 2015-06-09T06:27:55Z Re: Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851911#M298742 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P>Chart Properties -&gt; Presentation </P><P>Uncheck the "Suppress Zero Values" checkbox.</P><P></P><P>Hope it helps</P></BODY></HTML> Tue, 09 Jun 2015 06:46:57 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851911#M298742 MayilVahanan 2015-06-09T06:46:57Z Re: Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851912#M298743 <HTML><HEAD></HEAD><BODY><P>I have unchecked this option of course.</P><P></P><P>My Calculated Dimension: if(DIMENSION='A' or DIMENSIOn='B' or DIMENSION='C',DIMENSION)</P></BODY></HTML> Tue, 09 Jun 2015 07:24:29 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851912#M298743 2015-06-09T07:24:29Z Re: Show all fields in a calculated dimension https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851913#M298744 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Could you please say your requirement in details?</P><P>You are using <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">if(DIMENSION='A' or DIMENSIOn='B' or DIMENSION='C',DIMENSION) as Calculated Dimension, then its not possible to bring "D" in Dimension..</SPAN></P><P></P><P>Instead of using, Try like this</P><P>Dimension as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DIMENSION</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Measure as = If(Match(DIMENSION, 'A','B','C'), YourExp, 0)</SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Chart Properties -&gt; Presentation</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Uncheck the "Suppress Zero Values" checkbox.</P></BODY></HTML> Tue, 09 Jun 2015 07:32:50 GMT https://community.qlik.com/t5/QlikView/Show-all-fields-in-a-calculated-dimension/m-p/851913#M298744 MayilVahanan 2015-06-09T07:32:50Z