topic Re: Accumulate data for missing months in QlikView https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363070#M417517 <HTML><HEAD></HEAD><BODY><P>Check 'Show All Value' on Dimension tab AND uncheck 'Suppress Zero Value' on presentation tab.</P></BODY></HTML> Wed, 17 May 2017 18:57:10 GMT neelamsaroha157 2017-05-17T18:57:10Z Accumulate data for missing months https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363065#M417512 <HTML><HEAD></HEAD><BODY><P>Hi I have a question, I have to create an accumulated bar chart. I have a data up to April 2017 for HR dept but I only have March 2017 data for IT dept. I would like to show month of april in the IT chart even if i dont have the data. I just want to show the up to date data. Thank you in advance for the help.</P></BODY></HTML> Wed, 17 May 2017 16:00:53 GMT https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363065#M417512 2017-05-17T16:00:53Z Re: Accumulate data for missing months https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363066#M417513 <HTML><HEAD></HEAD><BODY><P>I'm sorry,the data for IT dept is until Feb 2017 only</P></BODY></HTML> Wed, 17 May 2017 16:37:50 GMT https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363066#M417513 2017-05-17T16:37:50Z Re: Accumulate data for missing months https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363067#M417514 <HTML><HEAD></HEAD><BODY><P>I didn't follow you properly. Can you share expected result?</P></BODY></HTML> Wed, 17 May 2017 17:11:58 GMT https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363067#M417514 Anil_Babu_Samineni 2017-05-17T17:11:58Z Re: Accumulate data for missing months https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363068#M417515 <HTML><HEAD></HEAD><BODY><P>Hi apologies, I would like this table:</P><P><IMG alt="Untitled.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163793_Untitled.png" style="height: auto;" /></P><P></P><P></P><P><SPAN style="font-size: 13.3333px;">to show this way:</SPAN></P><P><IMG alt="Untitled.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/163794_Untitled.png" style="height: 281px; width: 620px;" /></P><P></P><P>I just want the user to see that as of april, there are total of 3 completed training.</P></BODY></HTML> Wed, 17 May 2017 17:58:24 GMT https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363068#M417515 2017-05-17T17:58:24Z Re: Accumulate data for missing months https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363069#M417516 <HTML><HEAD></HEAD><BODY><P>It's still these reports there in QVW. What you are looking for? May be show in Straight table or excel file which is output need?</P></BODY></HTML> Wed, 17 May 2017 18:16:29 GMT https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363069#M417516 Anil_Babu_Samineni 2017-05-17T18:16:29Z Re: Accumulate data for missing months https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363070#M417517 <HTML><HEAD></HEAD><BODY><P>Check 'Show All Value' on Dimension tab AND uncheck 'Suppress Zero Value' on presentation tab.</P></BODY></HTML> Wed, 17 May 2017 18:57:10 GMT https://community.qlik.com/t5/QlikView/Accumulate-data-for-missing-months/m-p/1363070#M417517 neelamsaroha157 2017-05-17T18:57:10Z