Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI!
I must say I have my difficulties to understand the new QVSense numeric search behavior. See attached video.
I have a field with numeric IDs:
1) I do a search in ther filter panel for "<5" --> the current selection shows 1,2,3,4 --> behavior OK
2) I do a search for "<10" --> the current selection shows me 5,6,7,8,9 --> to me thats a strange behavior
Questions:
- Why does the "current selection box" shows selected items, instead of the search query. What happens if I do a snapshot. Will it save the search expression, or the selected values?
- I would expect the second .search to return 1,2,3,4,5,6,7,8,9. Why are the green values from Step1) excluded?
Roland / Janusz
OK - this is what I have found:
Pressing the ENTER key - seems to remove the current selections. (i picked up on that after watching the video again)
I will report this to our support team to log as a bug or to see if this is by design, etc. However, seems to be odd behavior to me too.
Work-around: - DO NOT USE the ENTER Key use the mouse and select the values and click the apply button - green check
Thanks for taking the time to report this.
Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike
Hi Roland - let's take each question 1 at a time -
My example - works using <10
Here is my sample data you can use in the Data Load Editor:
load * Inline [
Id,age
1,30
2,40
3,50
4,60
5,70
6,80
7,90
8,100
9,110
10,120
]
Can you check your data model and see what the datatype of your column is flagged as - I am curious to see if this has something to do with it defining it as ascii or something.
let me know
Mike Tarallo
Qlik
Hi Michael!
See attached the .qvf and screenshot
"Standalone" Search for < 10 works for me as well.
Its just when you first search for "<5", after that search for "<10" --> only values 5,6,7,8,9 are selected.
The simple workaround is, that a user always has to clear a field before it starts a new search; but I think that's not a very natural behavior.
Hello Roland - first thank you for the screenshots and the sample - very valuable to our team when trying to troubleshoot.
However, I AM NOT seeing this behavior with your app or mine - see the attached video attached to the bottom of this reply.
Are you using Desktop version 1.0 - or an older release?
Regards,
Let me know.
Mike
Hello Michael,
The "incorrect" behavior happens then you performs the following steps:
1. Search for "<5" and apply selection. The current selection will show you numbers 1,2,3,4
2. Search again but this time for "<10" and apply selection. You would expect QlikView to show in the current selection numbers from 1 to 9. However it's not the case. Instead it shows numbers from 5 to 9.
In your testing scenario you're missing the selection stage following the first search.
I hope the above description is clear. If not, let me know.
Best regards,
Janusz
Hi Janusz -
Please see attached video to this reply - also please include a screenshot of what you are seeing, as I am not seeing this behavior. I'd like to narrow this down, before identifying this as by design, bug etc. I assume you are using the latest version 1.0 as well.
In the video:
So far what I am seeing is by design.
After the first 6 values are selected, the current selection bar shows the id - the number of values selected OUT OF x.
Let me know.
Regards,
Mike
BTW - I watched the video a few times - and I am not seeing this behavior.
Still investigating.
OK - I see it now - I HAD TO PRESS <ENTER> om my keyboard after the selection.
Let me investigate with our products team
Mike
Exactly!!! Instead of selecting each value individually apply "search selection" by pressing Enter.
Best regards,
Janusz
Roland / Janusz
OK - this is what I have found:
Pressing the ENTER key - seems to remove the current selections. (i picked up on that after watching the video again)
I will report this to our support team to log as a bug or to see if this is by design, etc. However, seems to be odd behavior to me too.
Work-around: - DO NOT USE the ENTER Key use the mouse and select the values and click the apply button - green check
Thanks for taking the time to report this.
Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike