topic Sum(), Count() issue in chart in QlikView

Sum(), Count() issue in chart

Wed, 25 Apr 2012 06:11:20 GMT

I am facing a strange issue and I am unable to find the cause of it.

I have a table which records the responses of many students to a set of questions and its with many rows..and am making a dashboard to analyse the count of each type of answers given by stsudents to questions.

few of the rows are Question number, Question Text, Answer, Ans_Counter

So many rows in the table gets loaded with null values.

I load the table to QVW file. and in the qvw file, I create a table chart..pulling all fields from this table and display..to test, i export it to excel and give filters there in excel..select in question filter, question_no 23 (this has 4 possible answers--> good, fair, poor, very poor) ..that result in a set of rows..again i put the answer filter as 'good' and i get a count..the count of responses that are 'good' for question_no 23..lets say the count be C

Now I create simple bar chart with Answer as the dimension and Count({<question_no='23'>}Answer)

But here, the count shown for 'good' is not at all matching with C

I thought it might be some issue with Count() fn, and I used a Ans_Counter to try out the same thing using sum(), as

Sum({<question_no='23'>}Ans_Counter) But the count still doesnt match

Anyone have any clue??

Sum(), Count() issue in chart

Wed, 25 Apr 2012 06:12:52 GMT

typo .. i meant table box, not table chart !

Sum(), Count() issue in chart

Wed, 25 Apr 2012 06:34:49 GMT

sum and count are used in expressions, that are available in every chart but not in table box.

You can use straight table chart and use the same expression with the required dimension. And it will work.

In some cases, the word DISTINCT can be used in order to count only distinct values(non-repeated).

Regards.

Sum(), Count() issue in chart

Wed, 25 Apr 2012 06:44:06 GMT

@Saad,

I am not using sum/count in table box.

What I told was.. for testing purpose.. I create a table box having all columns for this internal table..export the values to excel..and apply filters in excel to cross compare with the bar chart I create in qlikview for the same table.

But these are not matching..

Sum(), Count() issue in chart

martinpohl — Wed, 25 Apr 2012 07:20:40 GMT

Hello,

did you use one fact table or many?

The result in a table box is the result of all matches, especially in the join of two table by one field and the fields of both tables.

Are the result in QV higher or lower than in excel?

Regards?

Sum(), Count() issue in chart

Wed, 25 Apr 2012 11:08:27 GMT

Using only one fact table.

The result in QV is much higher than what i get from excel

Sum(), Count() issue in chart

Nicole-Smith — Wed, 25 Apr 2012 16:10:12 GMT

Since your results in QV are much higher, I would suggest taking a closer look at your load script. I had a similar issue and it was with the way my tables were linked.