topic Re: How to write the expression in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064121#M919701 <HTML><HEAD></HEAD><BODY><P>Hi, checking 'Supress null values' in [Division Code] dimension can be an option?</P></BODY></HTML> Tue, 03 May 2016 13:03:10 GMT rubenmarin 2016-05-03T13:03:10Z How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064119#M919699 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>How to ommit the null division code :</P><P>See attachment:</P><P></P><P>For eg,</P><P>The NULL Division Code is summing up the "Budget Units" for other division code</P><P></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123399_Capture.PNG" style="height: 91px; width: 620px;" /></P><P></P><P>I dont want the sum up of "Budget Units" in NULL Division Code.</P><P>Output should be "Budget Units":</P><P></P><P>CI10 9878</P><P>U001 12</P><P></P><P></P><P>How to write the expression for Inbound Orders , Blocked Stock and Actual receipts as they are not having division code.</P><P></P><P>See attachment.</P><P></P><P><IMG alt="Capture2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/123400_Capture2.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064119#M919699 suvechha_b 2020-11-25T16:16:04Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064120#M919700 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>I dont want the sum up of "Budget Units" in NULL Division Code.</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Type Indicator]</SPAN><SPAN style="font-size: 8pt;"> = {'B'}, </SPAN><SPAN style="color: #800000; font-size: 12pt;">[Division Code]</SPAN><SPAN><SPAN style="font-size: 12pt;">={'*'}</SPAN> &gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><BR />Same for the other expressions.</P></BODY></HTML> Tue, 03 May 2016 13:02:23 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064120#M919700 Gysbert_Wassenaar 2016-05-03T13:02:23Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064121#M919701 <HTML><HEAD></HEAD><BODY><P>Hi, checking 'Supress null values' in [Division Code] dimension can be an option?</P></BODY></HTML> Tue, 03 May 2016 13:03:10 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064121#M919701 rubenmarin 2016-05-03T13:03:10Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064122#M919702 <HTML><HEAD></HEAD><BODY><P>Beside your question - you have a lot of sythetic keys within your datamodel which could cause problems. Recomended is to resolve these sythetic keys, see for this: <A href="https://community.qlik.com/qlik-blogpost/3064">Synthetic Keys</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 03 May 2016 13:46:05 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1064122#M919702 marcus_sommer 2016-05-03T13:46:05Z