topic Re: Search Frequency count in QlikView

Search Frequency count

shyamcharan — Tue, 09 Sep 2014 00:13:35 GMT

Hi Experts,

My requirement might sound strange but this I might require in near future in my project.

My client want to know the frequency of the search word repeated in a column/field( this means some location for the end user and they got their own high level analytics involved in this)

I have attached a screenshot on what I am talking about.

Is this possible or somehow be able to show in a separate table box or some other object in qlik dashboard.

Thanks in advance.

Regards,

Shyam.

Re: Search Frequency count

JonnyPoole — Tue, 09 Sep 2014 00:26:33 GMT

2 possibilities shown here:

The first will count the number of distinct values in a field called [FieldName] that have a specific WORD. Its a case insensitive search.

= count( DISTINCT if( SubStringCount( upper([FieldName]) , 'WORD'),[FieldName]))

This is also case insensitive but it will count up multiple hits of the WORD in the same value, ultimately telling you the number of times WORD appears in all the distinct values that exist in [FieldName]

= sum ( distinct SubStringCount(upper([FieldName]),'WORD'))

Re: Search Frequency count

shyamcharan — Tue, 09 Sep 2014 00:46:01 GMT

Hi Jonathan,

Thats an Interesting way of doing it. Thanks heaps.

Will give a try and will get back to you at the earliest.

Regards,

Shyam.

Re: Search Frequency count

shyamcharan — Tue, 09 Sep 2014 00:50:39 GMT

Hi Jonathan,

Can I somehow get the words in the strings 'WORD' dynamic?

It Should match the words they enter in the Search box.

Regards,

Shyam.

Re: Search Frequency count

JonnyPoole — Tue, 09 Sep 2014 01:08:10 GMT

If you were searching an individual field you could use getfieldselections() but only once the selection has actually been made.

You could also use an input box to capture a word as a variable . Once its in a variable you are good to go but obviously thats not a search box.