topic count shows same figures in QlikView https://community.qlik.com/t5/QlikView/count-shows-same-figures/m-p/239875#M90441 <HTML><HEAD></HEAD><BODY><P>Hi Patricia.</P><P>Would you be able to post a small application that illustrates this issue. It's best if you can use an inline load with a small sample data set.</P><P>John.</P></BODY></HTML> Tue, 19 Oct 2010 13:59:52 GMT john_duffy 2010-10-19T13:59:52Z count shows same figures https://community.qlik.com/t5/QlikView/count-shows-same-figures/m-p/239874#M90440 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>The last weeks I made my first qlikview application and I think I succeeded. It is a questionnaire application based on weighted average and targets.</P><P>Now we want to load more data into the application which source is an access database. The data deliverer says that it is not possible to load 2 years of data in the access database, so he is going to deliver flat files.</P><P>So, to give him the requirements about the layout of the flat files, I am trying to set up the same application based on flat files. So I exported data from the access database into flat files. I made a copy of my qlikview application and changed the script based on the new flat files. Everything looks fine, even the tables and joins, except for 1 thing. A count on the questions. For each question i see the same figure. It looks like the application is counting the total number of questions instead of how many answers were given on a question. The strange thing is that I did not change anything in the formula. And all other formula (the results) are exactly the same as in the original qlikview application.</P><P>Please advice how this can be solved (and maybe an explanation how this can happen so I can understand)!</P><P>Thank you in advance!</P><P>Best regards,</P><P>Patricia</P></BODY></HTML> Mon, 18 Oct 2010 11:07:37 GMT https://community.qlik.com/t5/QlikView/count-shows-same-figures/m-p/239874#M90440 2010-10-18T11:07:37Z count shows same figures https://community.qlik.com/t5/QlikView/count-shows-same-figures/m-p/239875#M90441 <HTML><HEAD></HEAD><BODY><P>Hi Patricia.</P><P>Would you be able to post a small application that illustrates this issue. It's best if you can use an inline load with a small sample data set.</P><P>John.</P></BODY></HTML> Tue, 19 Oct 2010 13:59:52 GMT https://community.qlik.com/t5/QlikView/count-shows-same-figures/m-p/239875#M90441 john_duffy 2010-10-19T13:59:52Z count shows same figures https://community.qlik.com/t5/QlikView/count-shows-same-figures/m-p/239876#M90442 <HTML><HEAD></HEAD><BODY><P>John, I did not thank you for your reply.</P><P>I had to make my own small set of data and i did not have time for that.</P><P>So, I choosed to wait for the extraction to see what happened. It was ok, no more double counts.</P><P>I think it has something to do with loading the data myself from an access database into a flat file.....</P><P></P><P>Patricia</P></BODY></HTML> Wed, 17 Nov 2010 09:05:02 GMT https://community.qlik.com/t5/QlikView/count-shows-same-figures/m-p/239876#M90442 2010-11-17T09:05:02Z