topic Re: How to view all month? in App Development https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214350#M23375 <HTML><HEAD></HEAD><BODY><P>Dear vasiliy</P><P>find the attchment file </P><P>I add another expression and the transparent&nbsp; of it is 100%</P></BODY></HTML> Fri, 17 Feb 2017 10:33:51 GMT Anonymous 2017-02-17T10:33:51Z How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214340#M23365 <HTML><HEAD></HEAD><BODY><P>Hello, everyone! </P><P>So what i need to do to see all 12 months in my graph even with zero or null measures??</P><P></P><P><IMG alt="2017-02-17 12_51_51-Controlling_new(1) _ Листы - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/153486_2017-02-17 12_51_51-Controlling_new(1) _ Листы - Qlik Sense.png" style="height: 160px; width: 620px;" /></P></BODY></HTML> Fri, 17 Feb 2017 09:55:44 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214340#M23365 Vasiliy_Beshentsev 2017-02-17T09:55:44Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214341#M23366 <HTML><HEAD></HEAD><BODY><P>Did you checked show null values option in Add on's tab</P></BODY></HTML> Fri, 17 Feb 2017 09:59:10 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214341#M23366 Chanty4u 2017-02-17T09:59:10Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214342#M23367 <HTML><HEAD></HEAD><BODY><P><IMG alt="2017-02-17 12_59_48-Controlling_new(1) _ Листы - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/153489_2017-02-17 12_59_48-Controlling_new(1) _ Листы - Qlik Sense.png" style="height: 153px; width: 620px;" /></P></BODY></HTML> Fri, 17 Feb 2017 10:02:21 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214342#M23367 Vasiliy_Beshentsev 2017-02-17T10:02:21Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214343#M23368 <HTML><HEAD></HEAD><BODY><P>try this in front end</P><P>in dimension</P><P>=Month(YearMonth)</P></BODY></HTML> Fri, 17 Feb 2017 10:11:09 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214343#M23368 Chanty4u 2017-02-17T10:11:09Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214344#M23369 <HTML><HEAD></HEAD><BODY><P>Change your Expression to show something other than 0; so suppress zero doesn't take effect</P><P></P><P>= if(sum(Expression)=0,<STRONG>0.0001</STRONG>,sum(Expression))</P></BODY></HTML> Fri, 17 Feb 2017 10:18:47 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214344#M23369 vinieme12 2017-02-17T10:18:47Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214345#M23370 <HTML><HEAD></HEAD><BODY><P>Result:</P><P></P><P><IMG alt="2017-02-17 13_23_32-Controlling_new(1) _ Листы - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/153490_2017-02-17 13_23_32-Controlling_new(1) _ Листы - Qlik Sense.png" style="height: 162px; width: 620px;" /></P></BODY></HTML> Fri, 17 Feb 2017 10:25:59 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214345#M23370 Vasiliy_Beshentsev 2017-02-17T10:25:59Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214346#M23371 <HTML><HEAD></HEAD><BODY><P>What is YearMonth? </P></BODY></HTML> Fri, 17 Feb 2017 10:28:45 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214346#M23371 Vasiliy_Beshentsev 2017-02-17T10:28:45Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214347#M23372 <HTML><HEAD></HEAD><BODY><P>OK, I think you are using the year month field from your fact table and those missing months don't exist in your FACT table. </P><P></P><P>Use the year month field from your Master Calendar that relates to your fact, the same approach will work</P></BODY></HTML> Fri, 17 Feb 2017 10:30:54 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214347#M23372 vinieme12 2017-02-17T10:30:54Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214348#M23373 <HTML><HEAD></HEAD><BODY><P>okay. try with&nbsp; Synthetic dimensions&nbsp; create variable for months and use that in value list.. like below</P><P><SPAN style="color: #333333; font-family: &amp;font-size:10pt;">“=if(ValueList($(VarMonths…” </SPAN></P></BODY></HTML> Fri, 17 Feb 2017 10:32:20 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214348#M23373 Chanty4u 2017-02-17T10:32:20Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214349#M23374 <HTML><HEAD></HEAD><BODY><P>So there is no way to show up all months without using master ca<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">lendar??? </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">It's so sad... I prepared to use this in very last moment...</SPAN></P></BODY></HTML> Fri, 17 Feb 2017 10:33:16 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214349#M23374 Vasiliy_Beshentsev 2017-02-17T10:33:16Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214350#M23375 <HTML><HEAD></HEAD><BODY><P>Dear vasiliy</P><P>find the attchment file </P><P>I add another expression and the transparent&nbsp; of it is 100%</P></BODY></HTML> Fri, 17 Feb 2017 10:33:51 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214350#M23375 Anonymous 2017-02-17T10:33:51Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214351#M23376 <HTML><HEAD></HEAD><BODY><P>How can we show something that doesn't exist <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />, </P><P></P><P>Right now the chart is aggregating over 7 possible dimension values that exist in your FACT</P><P></P><P>if you create a master calendar that basically fills the gap in dates in your FACT , you will have a list of all 12 months and using the month from the master calendar will cause the chart to aggregate over all 12 months simply because they exist in the Master calendar and then you can use the expression i provided</P><P></P><P>Hope this makes sense</P><P></P><P>Cheers</P><P>V</P></BODY></HTML> Fri, 17 Feb 2017 10:47:40 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214351#M23376 vinieme12 2017-02-17T10:47:40Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214352#M23377 <HTML><HEAD></HEAD><BODY><P>It's good decision. But master calendar is most powerfull.</P></BODY></HTML> Fri, 17 Feb 2017 12:17:58 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214352#M23377 Vasiliy_Beshentsev 2017-02-17T12:17:58Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214353#M23378 <HTML><HEAD></HEAD><BODY><P>YearMonth field is working?&nbsp;&nbsp; </P></BODY></HTML> Fri, 17 Feb 2017 13:40:09 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214353#M23378 Chanty4u 2017-02-17T13:40:09Z Re: How to view all month? https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214354#M23379 <HTML><HEAD></HEAD><BODY><P>I haven't got this field</P></BODY></HTML> Fri, 17 Feb 2017 13:42:23 GMT https://community.qlik.com/t5/App-Development/How-to-view-all-month/m-p/1214354#M23379 Vasiliy_Beshentsev 2017-02-17T13:42:23Z