topic Re: Strings comparison, letter by letter in App Development

Strings comparison, letter by letter

XavierL — Tue, 29 Sep 2020 10:07:57 GMT

Hi community,

I started on Qlik several months ago and I use your advice every day... but today, I don't find any idea...

I have entries with specific associated strings and I want to compare those strings, position by position.

1 ABCDEF

2 ZBCDEF

3 ABXDEF

4 YBXDEF

5 AWCDEF

I succeeded for each position separately with a calculated dimension using the mid() function to extract the letter. I defined a variable vpos to dynamically select the position. It's ok for a pie chart.

Now, how to generate a bar chart showing the maximum frequency for all positions?

I started by creating a calculated dimension defining the different positions: ValueLoop($(vpos_min), $(vpos_max),1) to put on the x-axis. And... nothing, no idea!

Thanks a lot for your help.

Xavier

Re: Strings comparison, letter by letter

Kushal_Chawda — Tue, 29 Sep 2020 10:33:36 GMT

@XavierL How you have calculated positions? What is expression? What is expected output?

Re: Strings comparison, letter by letter

XavierL — Tue, 29 Sep 2020 14:35:11 GMT

To obtain this pie chart about a single position, I use the calculated dimension mid(string, $(vpos), 1) where vpos is the analysed position. The measure is count(ID).

Now I woul like obtain a graph like this one :

Thanks

Re: Strings comparison, letter by letter

XavierL — Fri, 06 Nov 2020 14:26:54 GMT

Hi,

I revive my topic with a file, maybe easier to understand the question...

So, the pie chart provides the frequency of letters, position by position.

I would like a bar chart with the frequency of the most represented letter for each position.

=> the idea is to determine at a glance which positions vary the most.

Thanks a lot.

Re: Strings comparison, letter by letter

QFabian — Fri, 06 Nov 2020 14:53:23 GMT

Hi, just because they are few letters, i should try a word cloud visualization

Re: Strings comparison, letter by letter

XavierL — Fri, 06 Nov 2020 15:08:25 GMT

It's a simple example but you have to imagine the same with several hundred letters.

Thank you for your proposition.

Re: Strings comparison, letter by letter

GaryGiles — Sat, 07 Nov 2020 13:18:40 GMT

In your load script, create Positions table using the following

Positions:
Load RowNo() as Position
AutoGenerate 200;

Then, in your line chart, use Position for the x-Axis and count(distinct mid(string, Position, 1)). Replacing string with your string field.

Re: Strings comparison, letter by letter

marcus_sommer — Mon, 09 Nov 2020 15:14:21 GMT

I think I would try to do the most work within the script and not in the UI. This means to split the words into single letter within a field, for example with something like this:

load ID, Word, iterno() as IterNo, subfield(Word, iterno(), 1) as Letter
from Source while iterno() <= len(Word);

Afterwards you could simply count the letters und IterNo referenced to the positions of them.

- Marcus