Qlik NPrinting Filter on strings with spaces and numbers not showing any results with "value is"?

[Giansonn]

Hi all,

This is probably quite an easy question so an opportunity to earn some easy Kudos I hope.

I am doing some basic filtering on my first NPrinting report and I am having trouble with a particular field. This field has spaces in it so I think that is why NPrinting wont accept the "Value is" argument.

Please see image for context:

This is how my chart looks now:

If I choose "Numeric value is" I get some data but not all of it and I don't think that is what I want to be doing.

Any help is much appreciated.

Giansonn

[robert_mika]

I would not say is the space - I have some values with spaces.

But it could be the '£' sign.

Have you tried the 'Advanced Search 'option?

[Giansonn]

@robert_mika  I would agree that it could be the £ symbol. How should I use the advanced search? I have tried with the actual string but it does not work.

[Giansonn]

As a bit more background, these items are part of a dual function so they have the dual value of for instance:

Dual('£0 to £2', 1)

I have also tried using the numerical value but I only get half the results as before.

[Lech_Miszkiewicz]

thats what i thought - typical mistake..If it is dual filter in nprinting needs to be set to "numerical value is" and you should use numerical filters values 

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

[Giansonn]

Unfortunately this is not showing all of the data 😕

[robert_mika]

Which values did you get?

Maybe there are clues there?

[Giansonn]

Here is a picture of the graph with those filters applied:

Whilst the same graph in NPrinting only shows this:

The filters are the same (NPrinting uses dual with the numbers)

[robert_mika]

What does the red, blue and green in NPrinting represent?

Which filtered values?

[Giansonn]

They are different categories that are not filtered. i.e. the two graphs should still look the same there is no difference in filtering or data between the two and the filters do not affect these categories.