double values

[#1]

Hi Guys,

May be I am missing something or not understanding this simple thing.

In Table box it is like this:

and In Pivottable

Normally the count must show only 3. Why it is taking count as Six, I cannot understand. The databank table has only 3 field values. Why it is double in Qlikview??

Thankyou
Sravan

[#2 · Accepted solution]

Solved.. There was a join on the databank side.