topic Re: Challenge to Experts in QlikView https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636705#M233488 <HTML><HEAD></HEAD><BODY><P>Tresco ,</P><P>your logic is fine . But what about when there will be plenty of data and plenty of values to the dimension.</P></BODY></HTML> Tue, 03 Jun 2014 10:29:51 GMT 2014-06-03T10:29:51Z Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636698#M233481 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/120622">Table data to be converted in chart.</A></P></BODY></HTML> Tue, 03 Jun 2014 08:15:39 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636698#M233481 2014-06-03T08:15:39Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636699#M233482 <HTML><HEAD></HEAD><BODY><P>See the attached sample. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 Jun 2014 08:46:37 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636699#M233482 tresB 2014-06-03T08:46:37Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636700#M233483 <HTML><HEAD></HEAD><BODY><P>Tresco it do not work for Oct month</P></BODY></HTML> Tue, 03 Jun 2014 09:15:13 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636700#M233483 2014-06-03T09:15:13Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636701#M233484 <HTML><HEAD></HEAD><BODY><P>Any expert have any trick to resolve this.</P></BODY></HTML> Tue, 03 Jun 2014 09:32:31 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636701#M233484 2014-06-03T09:32:31Z Re: Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636702#M233485 <HTML><HEAD></HEAD><BODY><P>See attached. Try to get the logic. You would be able to get it for all scenarios</P></BODY></HTML> Tue, 03 Jun 2014 09:35:41 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636702#M233485 tresB 2014-06-03T09:35:41Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636703#M233486 <HTML><HEAD></HEAD><BODY><P>What logic are you talking?</P></BODY></HTML> Tue, 03 Jun 2014 10:06:31 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636703#M233486 2014-06-03T10:06:31Z Re: Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636704#M233487 <HTML><HEAD></HEAD><BODY><P>I expected you to notice some additional scripting. Not an issue, let me explain: If there is no data associated against a field value (like your Months - MARCH, Oct) your stack accumulation would not work. Hence, I added two additional rows in the script:</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>,,MARCH,Sold</P> <P>,,Oct, Not Sold</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>because these combinations were not there before. Then you have to uncheck 'Supress Zero Values' in the presentation tab to make the stack accumulation work properly. Hope it helps you comprehend.</P></BODY></HTML> Tue, 03 Jun 2014 10:12:17 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636704#M233487 tresB 2014-06-03T10:12:17Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636705#M233488 <HTML><HEAD></HEAD><BODY><P>Tresco ,</P><P>your logic is fine . But what about when there will be plenty of data and plenty of values to the dimension.</P></BODY></HTML> Tue, 03 Jun 2014 10:29:51 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636705#M233488 2014-06-03T10:29:51Z Re: Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636706#M233489 <HTML><HEAD></HEAD><BODY><P>If you can't find a way of populating all combinations(you can think of another table with them), I am afraid that the bar chart with stack accumulation would not work.</P></BODY></HTML> Tue, 03 Jun 2014 10:33:07 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636706#M233489 tresB 2014-06-03T10:33:07Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636707#M233490 <HTML><HEAD></HEAD><BODY><P>Sometimes appending rows with a WHERE NOT EXISTS statement is the way to go, when you need something for all combinations.</P></BODY></HTML> Wed, 04 Jun 2014 06:37:29 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636707#M233490 stevedark 2014-06-04T06:37:29Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636708#M233491 <HTML><HEAD></HEAD><BODY><P>Thank you Steve for your suggestion. However, here the issue was slightly different. The metadata was not there in the transaction table. Therefore, I thought of an alternative of having a master table with all combinations of metadata. You might want to have a look at the issue from the start and may come up with a better solution. Your inputs are always great ones to have .</P></BODY></HTML> Wed, 04 Jun 2014 07:06:53 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636708#M233491 tresB 2014-06-04T07:06:53Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636709#M233492 <HTML><HEAD></HEAD><BODY><P>Hi King K,</P><P></P><P>maybe it is not important for you, but don't you think, that months should be sorted better than alphabetical order?</P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Wed, 04 Jun 2014 08:45:23 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636709#M233492 2014-06-04T08:45:23Z Re: Challenge to Experts https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636710#M233493 <HTML><HEAD></HEAD><BODY><P>Guys can script level Accumulation work here.</P></BODY></HTML> Fri, 06 Jun 2014 12:21:37 GMT https://community.qlik.com/t5/QlikView/Challenge-to-Experts/m-p/636710#M233493 2014-06-06T12:21:37Z