Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
johncahillhp
Not applicable

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

Tags (2)
1 Solution

Accepted Solutions
anbu1984
Not applicable

Re: List Box Fequency either not showing or only showing 1

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

3 Replies
anbu1984
Not applicable

Re: List Box Fequency either not showing or only showing 1

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

mov
Not applicable

Re: List Box Fequency either not showing or only showing 1

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
Not applicable

Re: List Box Fequency either not showing or only showing 1

Thank you anbu,

Joining the two tables worked!

Community Browser