topic Re: Exclude dimension if no value exist in QlikView https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267582#M861630 <HTML><HEAD></HEAD><BODY><P>or with variable on selected field:</P><P>Sum({&lt;Year={'FY2016'},Country=p({&lt;Year={'$(Variable1)'}&gt;}Country)&gt;}Sales), where Variable1 is =right(GetCurrentSelections(Year),len(GetCurrentSelections(Year))-6)</P></BODY></HTML> Wed, 18 Jan 2017 08:19:00 GMT Anonymous 2017-01-18T08:19:00Z Exclude dimension if no value exist https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267580#M861628 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i have the sample file attached and explained my issue...</P><P></P><P>can anyone help???</P><P></P><P>Thanks</P><P>Gautham</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267580#M861628 gauthamchilled 2020-11-25T16:16:04Z Re: Exclude dimension if no value exist https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267581#M861629 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is what you are searching?</P><P>Sum({&lt;Year={'FY2016'},Country=p({&lt;Year={'MY2015'}&gt;}Country)&gt;}Sales)</P><P></P><P>Best regards,</P><P>Cosmina</P></BODY></HTML> Wed, 18 Jan 2017 08:03:34 GMT https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267581#M861629 Anonymous 2017-01-18T08:03:34Z Re: Exclude dimension if no value exist https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267582#M861630 <HTML><HEAD></HEAD><BODY><P>or with variable on selected field:</P><P>Sum({&lt;Year={'FY2016'},Country=p({&lt;Year={'$(Variable1)'}&gt;}Country)&gt;}Sales), where Variable1 is =right(GetCurrentSelections(Year),len(GetCurrentSelections(Year))-6)</P></BODY></HTML> Wed, 18 Jan 2017 08:19:00 GMT https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267582#M861630 Anonymous 2017-01-18T08:19:00Z Re: Exclude dimension if no value exist https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267583#M861631 <HTML><HEAD></HEAD><BODY><P>Hi There </P><P></P><P>Select properties&gt;Dimension Limits&gt;Show only values that are greater than:&gt;&nbsp; enter 0 and exact amount on the drop down.</P></BODY></HTML> Wed, 18 Jan 2017 08:44:57 GMT https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267583#M861631 rido1421 2017-01-18T08:44:57Z Re: Exclude dimension if no value exist https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267584#M861632 <HTML><HEAD></HEAD><BODY><P>Attached QVW</P></BODY></HTML> Wed, 18 Jan 2017 08:47:21 GMT https://community.qlik.com/t5/QlikView/Exclude-dimension-if-no-value-exist/m-p/1267584#M861632 rido1421 2017-01-18T08:47:21Z