Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johncahillhp
Contributor III
Contributor III

List Box Fequency either not showing or only showing 1

Hello,

I am trying to provide list box that uses either the ID field from my primary table or Name field from a reference table.

The schema for the two table is very straight forward;

T1T2
Field1ID
Field2Name
Field3
ID

When I create a new list box and select ID, with frequency enabled, I get the ID displayed with a frequency of zero for each.

IDFreq
2416460
321933 0
2416440
2416420

My end goal is to provide the reference name along with the frequency count. Therefore I create a new list box with the Name field selected, with frequency enabled. However it only displays 1 for each. Most likely the reference table is not joined to the primary table in the list box object.

NameFreq
3PAR StoreServ Storage 1
EVA Storage 1
HP ProLiant DL Servers1
Integrity Servers1

The frequency counts are much more than 1.

What am I missing? Is there an alternative method?

Thank you ,

John

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

Check this qvw. Try commenting Join in script and check frequency

View solution in original post

3 Replies
anbu1984
Master III
Master III

Check this qvw. Try commenting Join in script and check frequency

Anonymous
Not applicable

John,

Frequency is not defined for the key fields.  Field ID is a key field because it exists in both tables.  If necessary, you can create copies of ID - ID1 in T1 and ID2 in T2 - and use ID1 and ID2 to find frequency.

Regards,

Michael

johncahillhp
Contributor III
Contributor III
Author

Thank you anbu,

Joining the two tables worked!