topic help with count in QlikView

help with count

gerrycastellino — Fri, 25 Sep 2015 02:50:04 GMT

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 — Fri, 25 Sep 2015 03:13:56 GMT

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 — Fri, 25 Sep 2015 04:20:36 GMT

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 — Fri, 25 Sep 2015 04:45:20 GMT

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

PrashantSangle — Fri, 25 Sep 2015 04:45:55 GMT

Hi,

try with TOTAL keyword.

Regards

avinashelite — Fri, 25 Sep 2015 05:12:27 GMT

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