help with count

[gerrycastellino]

I have a single table loaded,  trying to reconcile the counts that are showing in my list box, with what my chart is actually displaying,

The number do not add up - what am I missing.

The total records in this table is 32653.

When I print out the rowno()  the max it is displaying is 1401.

My list box shows the count of the frequency of the values which matches up to my totals.

😞

[qlikviewwizard]

Hi,

Please use these two expressions in text boxes and see the results.

='All Values of ETB is ' &Count(ETB) &

'and '

& 'All Distinct Values of ETBis ' &Count(DISTINCT ETB)

='All Values of KTB is ' &Count(KTB) &

'and '

& 'All Distinct Values of KTBis ' &Count(DISTINCT KTB)

FYI, I enclosed test file with the data.

Hope you will understand.

[tamilarasu]

Hi,

Add RowNo() field as a dimension and see the result. I guess, %Datekey must contains replicated entries. Could you explain your exact requirement.?

[jonathandienst]

You are asking to see what's going on in your script. It might help if you posted it here.

[PrashantSangle]

Hi,

try with TOTAL keyword.

Regards

[avinashelite]

Hi Gerry,

Do you have any where condition with that table? if so RowNo( ) cannot be used....please use RecNo( ) this should resolve the issue