topic Show frequency in QlikView

Show frequency

Thu, 06 Jan 2011 17:14:01 GMT

Hi,

What is the functionlity of Show frequency in listbox?.

consider i have shown city names in the list box and if i check the show frequency will it show the count for each city?

Show frequency

Thu, 06 Jan 2011 17:41:19 GMT

Hi XXX,

yes, this is it. Sometimes I am using it to look for duplicates. For ex. if I had load a table by mistake twice. Or my source data isn't proper as I expected it.

Show frequency

Fri, 07 Jan 2011 07:12:41 GMT

Hi,

In my case it is shwoing wrong data.If take the count() and show frequency are different values how to verify it.

Show frequency

Fri, 07 Jan 2011 15:42:53 GMT

Hi,

this is not easy to answer without having any data. Are you able to send a exam app?

For the moment: I am using for such purposes a unique rowidentifier (if not exits in the source table, I create one temp. during load, normally with rowno()) and then start searching and validating, checking my tables via table viewer in combination with one or more tablebox(es) and/or a straight table without expressions.

HtH
Roland

Show frequency

Bill_Britt — Fri, 07 Jan 2011 15:45:00 GMT

Try doing a distinct count and see what you come up with.

Show frequency

Mon, 10 Jan 2011 05:48:25 GMT

Hi Roland,

Thanks for your resposne. There was issue with the join and duplicate data was there. And it has been fixed.Now Show frequency is showing correct data.